Focal Point
(Solved) Chaining from a dynamic value passed to html (!IBI.AMP.varname)

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5847012386

July 26, 2016, 01:28 PM
mpbMDE
(Solved) Chaining from a dynamic value passed to html (!IBI.AMP.varname)
I need to pass a parameter value to the html page (which I can successfully do); then chain another variable to it.

1) Pass the value of COUNTRY to an html page (countrycar.htm)
 -SET &COUNTRY = 'ENGLAND';
-RUN
-HTMLFORM countrycar.htm

2) HTML page displays the country appropriately
 <SCRIPT type=text/javascript>//confidential_id=IBI_OptionsScript
var szHtmlAlias="/ibi_apps/ibi_html";var szRunTimeHtmlAlias="runTimeHtmlAlias";var cgipath="cgipath";var ibirls="ibirls3";var rltdyncalendar="rltdyncalendar";var map="ibimap";var olap="olap";var olappanebase="olappanebase";var olapdrill="olapdrill";var ibiOptions = new Array(cgipath,ibirls);var nlsScript="/javaassist/nls.js";var nlsVarsScript="/javaassist/nlsvars.js";var glbScript="/javaassist/ibi/html/js/ibigbl.js";var replacePart="<replace>";
var scriptTemplate='<SCRIPT src="'+replacePart+'" type="text/javascript"><\/SCRIPT>';if(typeof(szRunTimeHtmlAlias) === 'string' && szRunTimeHtmlAlias.indexOf('/') == 0)szHtmlAlias=szRunTimeHtmlAlias;document.write(scriptTemplate.replace(replacePart, szHtmlAlias + nlsScript));document.write(scriptTemplate.replace(replacePart, szHtmlAlias + nlsVarsScript));document.write(scriptTemplate.replace(replacePart, szHtmlAlias + glbScript));</SCRIPT>

<SCRIPT type=text/javascript>//confidential_id=IBI_ibigblloadCss
if(typeof ibigblloadCss === 'function'){ibigblloadCss(null);addIntlTranslatedJS("composertrans.js");}else {alert("JavaScript alias '/ibi_apps/ibi_html'  is not valid");window.location("about:blank");}</SCRIPT>
<TITLE>HtmlPage</TITLE><LINK id=ITEM2 rel=stylesheet type=text/css UserSuppliedFullPath="1" rtFileName="cgipathsub/ibi_html/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/default_theme.css"><LINK id=IBI_THEME_CSS rel=stylesheet type=text/css UserSuppliedFullPath="1" desc="Information Builders" rtFileName="cgipathsub/ibi_html/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/ibi.css">
<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>

<SCRIPT>//confidential_id=clientEventHandlersJS

//Begin function window_onload
function window_onload() {

UpdateData();

// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload

//Begin function button1_onclick
function button1_onclick(ctrl) {
// TODO: Add your event handler code here
OnExecute(ctrl)
}
//End function button1_onclick
</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" thumbnailscale="4" maptype="0" nextelementuniquenumber="2">
<IFRAME id=iframe1 style="HEIGHT: 480px; WIDTH: 844px; POSITION: absolute; LEFT: 60px; Z-INDEX: 1; TOP: 130px" name="iframe1"></IFRAME>
<INPUT tabIndex=1 id=button1 language=javascript style="HEIGHT: 60px; WIDTH: 170px; POSITION: absolute; LEFT: 510px; Z-INDEX: 2; TOP: 30px" onclick=button1_onclick(this) type=button value=Button requests_list="0" autoExecute="false" name="button1">
<FORM id=form1 style="HEIGHT: 70px; WIDTH: 382px; POSITION: absolute; LEFT: 80px; Z-INDEX: 3; TOP: 40px" method=post form_dist_between_desc_and_input="10" form_hor_dist_between_controls="10" vert_dist_between_controls="10" form_number_of_columns="4" form_number_of_visible_rows="4" form_prompt_location="1" form_type="1" default_slider_type="4" form_newline_chain="1" fexlist_list="button1" tempwidth="250" tempheight="102" name="form1">
<LABEL id=label1 style="CURSOR: default; HEIGHT: 13px; WIDTH: 49px; POSITION: absolute; LEFT: 5px; Z-INDEX: 5; TOP: 5px" for=COUNTRY name="edit1">COUNTRY</LABEL>
<INPUT tabIndex=3 id=COUNTRY style="OVERFLOW: visible; WIDTH: 138px; OVERFLOW-Y: visible; POSITION: absolute; LEFT: 5px; Z-INDEX: 6; TOP: 28px" spellcheck=false type=text hspace=0 value=!IBI.AMP.COUNTRY; persistentuniqueid="compUid_1" requiredfield="1" boundtovariable="1" defaultlocation="0,0,15,118" defaultselection="1" name="edit1">
<LABEL id=label2 style="CURSOR: default; HEIGHT: 13px; WIDTH: 20px; POSITION: absolute; LEFT: 153px; Z-INDEX: 7; TOP: 5px" for=combobox1 name="">CAR</LABEL>
<SELECT tabIndex=4 id=combobox1 style="OVERFLOW: visible; WIDTH: 177px; OVERFLOW-Y: visible; POSITION: absolute; LEFT: 153px; Z-INDEX: 8; TOP: 28px" spellcheck=false size=1 persistentuniqueid="compUid_2" requiredfield="1" boundtovariable="1" defaultlocation="0,0,19,45" defaultselection="1"></SELECT></FORM>
<INPUT id=layoutinfo style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden resourcectrlids="ITEM2;IBI_THEME_CSS" name="inputhidden1">
<INPUT id=ibiapp_app style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden value="car baseapp" name="ibiapp_app">
<xml id=focus_xmlelement><script type="text/xml" nextelementuniquenumber="3">
	<rootxmlnode focoption="_FOC_NULL" top="100" left="10" width="150" height="130">
		<variables>
			<variable controltype="7" parametercreatedinreslay="0" type="unresolved" desc="COUNTRY" name="COUNTRY" default="" textvarname="" accept="0" select="0" create="1" top="70" left="30" width="60" height="20" inbinding="1">
				<link linktype="default" from="compUid_1">
					<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						<data_info datatype="0" modifiedrequest="0" displayfield="COUNTRY" ibiformat="A10" datafield="COUNTRY" datasource="car.mas" ibif_ex="car" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster"></data_info></condition></link>
				<requestid id="0"></requestid></variable>
			<variable controltype="8" parametercreatedinreslay="0" type="unresolved" desc="CAR" name="CAR" default="" textvarname="" accept="0" select="0" create="1" top="70" left="140" width="60" height="20" inbinding="1">
				<link linktype="default" from="compUid_2">
					<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						<data_info datatype="0" modifiedrequest="0" displayfield="CAR" ibiformat="A16" datafield="CAR" datasource="car.mas" ibif_ex="car" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster"></data_info></condition></link>
				<requestid id="0"></requestid></variable>
		</variables>
		<input_controls>
			<input_control bindcontrolid="compUid_1" elementtype="7" name="edit1" id="COUNTRY" multiple="0" inbinding="1" top="20" left="30" width="60" height="20" onetimepopulated="1">
				<link linktype="default" persistentuniqueid="compUid_2">
					<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						<data_info datatype="0" modifiedrequest="0" datasource="car.mas" ibif_ex="car" datafield="COUNTRY" displayfield="COUNTRY" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" ibiformat="A10" dfformat="A10" accept="0" operation="NONE" selectedvalue=""!IBI.AMP.COUNTRY;";">
							<![CDATA[TABLE FILE car
SUM FST.COUNTRY
 BY COUNTRY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]>
							<static_values><static value="!IBI.AMP.COUNTRY;" display="!IBI.AMP.COUNTRY;" selected="1" noinput="0"></static></static_values></data_info></condition></link>
			</input_control>
			<input_control bindcontrolid="compUid_2" elementtype="8" name="combobox1" id="combobox1" multiple="0" inbinding="1" top="20" left="140" width="60" height="20" onetimepopulated="0">
				<link linktype="default" persistentuniqueid="compUid_1" from="compUid_1">
					<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="COUNTRY" resolveparameter="COUNTRY">
						<data_info datatype="1" modifiedrequest="1" datasource="car.mas" ibif_ex="car" datafield="CAR" displayfield="CAR" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" ibiformat="A16" dfformat="A16" accept="0" operation="NONE" checkForDuplicateValues="0">
							<![CDATA[TABLE FILE car
SUM FST.CAR
BY CAR
WHERE COUNTRY EQ '&COUNTRY'
ON TABLE PCHOLD FORMAT XML
END
				]]></data_info></condition></link>
			</input_control>
		</input_controls>
		<requests nextrequestsid="0"><request requestid="0" sourcetype="typeFex" targettype="iframe" targetname="iframe1" ibif_ex="-typecountrycar.fex" activereport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="car baseapp"></request>
		</requests>
		<other_bound_objects></other_bound_objects>
	</rootxmlnode></script>
</xml></BODY>
<SCRIPT type=text/javascript>//confidential_id=IBI_loader
if(typeof doBeforeLoad === 'function'){doBeforeLoad();}function AdjustChildrenPosition(){
}
</SCRIPT>
</HTML>
<!-- cc 00000 -->

3) Then I want to chain variable country (edit1) to the car dropdown (combobox1) to list cars within that country. This is where I am having trouble. I have embedded the code to populate the car dropdown, but it is empty!

I appreciate any assistance in resolving this issue!

Thanks!
Marilyn

This message has been edited. Last edited by: mpbMDE,


WebFOCUS 8.1.05 Windows 7, all output
July 29, 2016, 12:39 PM
mpbMDE
I discovered that for IE, it is necessary (at least in our shop) to set compatibility view on. Then it works perfectly.
Marilyn


WebFOCUS 8.1.05 Windows 7, all output