Focal Point
Unable to chain dynamic populated multiple select list boxes

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

May 16, 2011, 04:29 PM
JK
Unable to chain dynamic populated multiple select list boxes
All,

I am trying to chain together two multiple select list boxes with an external fex, but I seem unable to do so, has anyone had any success with this in 7.7.02?

I am pulling up a list box of clients using an external fex. Each client (A, B, C) has an associated list of regions (1, 2, 3). When I single select on a client (A) it properly populated the second list box with the associated regions through that list box's external fex (1, 2) or selecting another client (B) I am able to display the corresponding regions (B, C) If I multi select and choose A & B, the chained list box does not properly populate the regions (1, 2, & 3) and seems to just hang. I have tried just about every trick I know of, any help would be wonderful.

Thank you!


7.7.02/AIX/Excel, PDF, HTML
May 16, 2011, 05:03 PM
Severus.snape
Hi,
Can you post the code here...
Did you check the tag for an attribute called OPERATION which in this case should be set to OR..

Try running the fex file on it own and see if it is producing the desired output.

thanks
Sashanka


WF 7.7.03/Windows/HTML,PDF,EXL
POC/local Dev Studio 7.7.03 & 7.6.11
May 17, 2011, 01:51 AM
Rajna Nannat
Ensure that these points are taken care
1) Fex used to populate the regions has a filter passed from the client that support multiselect as WHERE FEILD EQ &CLIENT;
2) The variables created under tag for these list boxes support multiselect
3) Ensure u have kept operation="OR" in select tag
4) Try Setting cacheruntimedata=0


WebFOCUS 8.1.05
Windows
Excel, PDF, HTML
May 17, 2011, 03:16 AM
Ramkumar - Webfous
In case if your XML Generating FEX is something like this,

SQL ****
SELECT REGION_CODE FROM ALL_REGION

TABLE FILE SQLOUT
PRINT
REGION_CODE
BY REGION_CODE
WHERE CLIENT EQ '&CLIENT_ID'
ON TABLE PCHOLD FORMAT XML
END

THis wont work...

You need to pass the Where paramters in the SQL Query itself.. WHERE does not work with SQLOUT table file...

With Previouys versions, this working perfectly....


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
May 17, 2011, 01:48 PM
JK
Here is the HTMl code:

 <HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 77, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>

<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";

var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";

var ibixmltree="ibixmltree";

var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>

<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>

<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>

<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>

<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//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
</SCRIPT>

<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" thumbnailscale="4" nextelementuniquenumber="2" elementtype="21" edaconnectionrequired="true">
<SELECT style="Z-INDEX: 1; POSITION: absolute; WIDTH: 230px; HEIGHT: 130px; TOP: 50px; LEFT: 90px" id=listbox1 tabIndex=1 multiple size=3 addquotes="no" defaultselection="1" persistentuniqueid="compUid_1" name="listbox1"></SELECT> 
<SELECT style="Z-INDEX: 2; POSITION: absolute; WIDTH: 270px; HEIGHT: 330px; TOP: 50px; LEFT: 410px" id=listbox2 tabIndex=2 size=3 defaultselection="1" persistentuniqueid="compUid_2" name="listbox2"></SELECT>    
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=dev_joe type=hidden name="ibiapp_app">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASERVE type=hidden isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml" nextelementuniquenumber="3">
	
<rootxmlnode focoption="_FOC_NULL" top="50" left="10" width="150" height="130">
		
<variables></variables>
		
<input_controls>
			
<input_control bindcontrolid="compUid_1" elementtype="9" name="listbox1" id="listbox1" multiple="1" inbinding="1" top="20" left="30" width="60" height="20" onetimepopulated="0">
				
<link linktype="default" persistentuniqueid="compUid_1">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info operation="OR" checkForDuplicateValues="0" sourcetype="typeFex" datatype="1" modifiedrequest="0" datasource="lb_country_pop.fex" displayfield="COUNTRY" datafield="COUNTRY" ibiapp_app="dev_joe" cacheruntimedata="1" addalloption="1" dynalldisplayvalue="ALL">
							
<![CDATA[]]></data_info></condition></link></input_control>
			
<input_control bindcontrolid="compUid_2" elementtype="9" name="listbox2" id="listbox2" multiple="0" inbinding="1" top="20" left="140" width="60" height="20" onetimepopulated="0">
				
<link linktype="default" persistentuniqueid="compUid_2" from="compUid_1">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="COUNTRY" resolveparameter="COUNTRY">
						
<data_info checkForDuplicateValues="0" sourcetype="typeFex" datatype="1" modifiedrequest="1" datasource="lb_city_pop.fex" displayfield="" datafield="" ibiapp_app="dev_joe" cacheruntimedata="0">
							
<![CDATA[]]></data_info></condition></link></input_control></input_controls>
		
<other_bound_objects></other_bound_objects>
		
<requests></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML> 


The Source for my first fex:

 -* File lb_country_pop.fex
TABLE FILE PERSINFO
SUM FST.COUNTRY
 BY COUNTRY

ON TABLE PCHOLD FORMAT XML
END
 


And for the chained fex:

 -DEFAULT &COUNTRY = '';

TABLE FILE PERSINFO
BY CITY
WHERE COUNTRY EQ '&COUNTRY'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
ON TABLE SET HTMLCSS ON
END 


I can get it to run with the ALL option, and a single selection, but when I try to pull the multiple selections, it goes blank.


7.7.02/AIX/Excel, PDF, HTML