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     [SOLVED] HTML Composer: Chained controls - values not sorted when "All" is selected

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] HTML Composer: Chained controls - values not sorted when "All" is selected
 Login/Join
 
Francis Mariani
Expert
posted
I have three chained select boxes, each with the 'Add "ALL" option' checked. I also have 'Sort' checked with 'Sort by' set to 'Display'.

When I select "All" in the first select box, I am expecting the second and third to be sorted in alphabetical order with "All" at the top. "All" is at the top, but the values are not sorted alphabetically - they are sorted alphabetically but only within each value of the first select box, so I will have Aa Ba Ca Ab Cb Bc Dc... instead of Aa Ab Ba Bc Ca Cb Dc...

Do I expect too much?

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
J
Guru
posted Hide Post
I don't have this issue with the car file, are you using an embedded or external procedure?


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Francis Mariani
Expert
posted Hide Post
I use an external procedure that feeds all three select boxes.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
J
Guru
posted Hide Post
You wouldn't happen to group by or do anything different in those external procedures by chance? I don't think I have had this problem before. (the code would be nice to see)


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Francis Mariani
Expert
posted Hide Post
There are BY statements in the external procedure which obviously orders the rows a certain way, but why is there sorting options on each of the chained controls if they cannot resort the data supplied by the external procedure? 
BY CHAIN_COLUMN1
BY CHAIN_COLUMN2
BY CHAIN_COLUMN3

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Wep5622
Virtuoso
posted Hide Post
I think those sort options are usually used with embedded procedures (as opposed to external ones), where you're not allowed to decide on the sort order of the output of the procedure yourself.

With an external procedure, you are in control, in which case it doesn't make so much sense to sort the results again. Besides, that approach to sorting sorts on the (slow) client side using javascript instead of on a (fast) database server.

To summarise; I think it's reasonable to expect the results of an external procedure to be sorted correctly.

Of course that leaves the question why those options are available for external procedures, but the same goes for several other elements in that toolbox window. For example, you can modify the TABLE request of an embedded procedure, which causes it to stop working... That particular bit of interface is not very well thought out (which is something IBI said, not me).


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
J
Guru
posted Hide Post
Again I was unable to reproduce your issue. Two controls with the last one having
 
BY CHAIN_COLUMN1
BY CHAIN_COLUMN2


Everything still works out. The second listbox is an external procedure here is the code:

 
TABLE FILE CAR
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END



<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7703, 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" nextelementuniquenumber="2" thumbnailscale="4" elementtype="21" edaconnectionrequired="true">
<SELECT style="Z-INDEX: 1; POSITION: absolute; WIDTH: 140px; HEIGHT: 180px; TOP: 30px; LEFT: 150px" id=listbox1 tabIndex=1 multiple size=3 defaultselection="1" persistentuniqueid="compUid_1" name="listbox1"></SELECT> 
<SELECT style="Z-INDEX: 2; POSITION: absolute; WIDTH: 170px; HEIGHT: 180px; TOP: 30px; LEFT: 350px" id=listbox2 tabIndex=2 multiple 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=josh_hapner 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="20" left="627" width="150" height="130">
		
<variables></variables>
		
<input_controls>
			
<input_control bindcontrolid="compUid_1" elementtype="9" name="listbox1" id="listbox1" multiple="1" inbinding="1" onetimepopulated="0">
				
<link linktype="default" persistentuniqueid="compUid_1">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" sourcetype="typeMaster" datatype="1" modifiedrequest="0" ibiapp_app="josh_hapner" datasource="CAR.mas" displayfield="CAR.ORIGIN.COUNTRY" ibiformat="A10" dfformat="A10" datafield="CAR.ORIGIN.COUNTRY" dosorting="1" sorttype="1">
							
<![CDATA[TABLE FILE CAR
SUM FST.CAR.ORIGIN.COUNTRY
 BY CAR.ORIGIN.COUNTRY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
			
<input_control bindcontrolid="compUid_2" elementtype="9" name="listbox2" id="listbox2" multiple="1" inbinding="1" 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="0" datasource="cartest.fex" displayfield="CAR" datafield="CAR" ibiapp_app="josh_hapner" dosorting="1" sorttype="1">
							
<![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>


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Francis Mariani
Expert
posted Hide Post
Well, I've got it working with the CAR file, I'll debug my real code this morning...

external fex - fm_chain1_data.fex:

SET HOLDLIST=PRINTONLY
TABLE FILE CAR
SUM
COUNTRY NOPRINT
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT XML
END


HTML page - fm_chain1.htm

<!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7705, 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" nextelementuniquenumber="2" thumbnailscale="4" elementtype="21" edaconnectionrequired="true">
<SELECT style="Z-INDEX: 1; POSITION: absolute; WIDTH: 160px; HEIGHT: 110px; TOP: 50px; LEFT: 100px" id=listbox1 tabIndex=1 size=3 defaultselection="1" persistentuniqueid="compUid_1" name="listbox1"></SELECT>
<SELECT style="Z-INDEX: 2; POSITION: absolute; WIDTH: 200px; HEIGHT: 110px; TOP: 50px; LEFT: 330px" 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=test 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="0" 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 checkForDuplicateValues="1" sourcetype="typeFex" datatype="1" modifiedrequest="1" datasource="fm_chain1_data.fex" displayfield="COUNTRY" datafield="COUNTRY" ibiapp_app="test" addalloption="1" dynalldisplayvalue="ALL" dosorting="1" sorttype="1">
<![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="0" datasource="fm_chain1_data.fex" displayfield="CAR" datafield="CAR" ibiapp_app="test" dosorting="1" sorttype="1" addalloption="1" dynalldisplayvalue="ALL">
<![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>


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
I had to check the Sort checkbox and Sort by Display:



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
J
Guru
posted Hide Post
I thought you said you had already done that in your original post. Which control was throwing you off (first, second, third, or all three?)


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Francis Mariani
Expert
posted Hide Post
I'm not sure what happened. The Sort checkbox was not checked, so I checked it and changed the sort option.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report 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     [SOLVED] HTML Composer: Chained controls - values not sorted when "All" is selected

Copyright © 1996-2020 Information Builders