Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Unable to chain dynamic populated multiple select list boxes

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Unable to chain dynamic populated multiple select list boxes
 Login/Join
 
Member
posted
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
 
Posts: 5 | Registered: December 09, 2008Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 103 | Registered: June 12, 2009Report This Post
Gold member
posted Hide Post
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
 
Posts: 72 | Location: Flowood , MS | Registered: May 11, 2011Report This Post
Guru
posted Hide Post
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
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Member
posted Hide Post
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
 
Posts: 5 | Registered: December 09, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Unable to chain dynamic populated multiple select list boxes

Copyright © 1996-2020 Information Builders