 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [UNHAPPILY CLOSED] Dev Studio HTML Composer: Why can't I chain two select list boxes?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [UNHAPPILY CLOSED] Dev Studio HTML Composer: Why can't I chain two select list boxes? Read-Only TopicGo | Search | Notify | Tools |
| [UNHAPPILY CLOSED] Dev Studio HTML Composer: Why can't I chain two select list boxes? | Login/Join |
| Expert |
I have a simple HTML page. I add two select list boxes. I select these two controls and try to chain them by clicking the "Add to chain" button, but it's inactive. Why? Is it because neither have a Parameter assigned? Why do I need parameters? Puzzled and annoyed.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 | ||
|
| Guru |
Basically in HTML composer, you can chain the list boxes with parameters only... That too till 714, you can chain only the Dynamically populated control, thro' Datasource or FEX. But From 769, Staically populated controls can be added as part of chaining. Please Go through This link. But Select or List or Radio button without parameters cant be chained at all... Thanks, Ramkumar. WebFOCUS/Tableau Webfocus 8 / 7.7.02 Unix, Windows HTML/PDF/EXCEL/AHTML/XML/HTML5 | |||
|
| Expert |
Ramkumar, thanks for letting me know. Until IBI describes why, it seems like an arbitrary decision. From an existing form, I want to open a new window that has chained select lists and also a double list control. I suppose I will have to fake it. 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 | |||
|
| Expert |
Francis, Can you provide that in an example (code)? I'd like to check it out and see what can be done about it. Doug
| |||||
|
| Expert |
Created in baseapp: <!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta http-equiv=Content-Type content="text/html; charset=ISO-8859-1">
<META id=Generation content="Created in release 7611, 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 src="/ibi_html/javaassist/nls.js" type=text/javascript></SCRIPT>
<SCRIPT id=IBI_nlsVars src="/ibi_html/javaassist/nlsvars.js" type=text/javascript></SCRIPT>
<SCRIPT id=IBI_ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript></SCRIPT>
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<META content="MSHTML 6.00.2900.6049" name=GENERATOR>
<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 eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" persistentuniqueid="compUid_1" nextelementuniquenumber="5" elementtype="21" edaconnectionrequired="false">
<SPAN id=panel1 style="Z-INDEX: 1; LEFT: 60px; WIDTH: 790px; POSITION: absolute; TOP: 50px; HEIGHT: 600px" tabIndex=1 persistentuniqueid="compUid_2" elementtype="34">
<SELECT id=combobox1 style="Z-INDEX: 2; LEFT: 110px; WIDTH: 150px; POSITION: absolute; TOP: 40px" tabIndex=2 persistentuniqueid="compUid_3" name="combobox1"></SELECT>
<SELECT id=combobox2 style="Z-INDEX: 3; LEFT: 110px; WIDTH: 150px; POSITION: absolute; TOP: 80px" tabIndex=3 persistentuniqueid="compUid_5" name="combobox2"></SELECT></SPAN>
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden>
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=baseapp name="ibiapp_app">
<INPUT id=ibic_server style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=EDASERVE isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml">
<rootxmlnode>
<variables></variables>
<input_controls>
<input_control bindcontrolid="compUid_3" elementtype="8" name="combobox1" id="combobox1" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_5" elementtype="8" name="combobox2" id="combobox2" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info></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 | |||
|
| Guru |
But Francis, What's that we are going to achieve by chaining select boxes without any parameters. ? If Static lists, you can simulate chaining using Javascript itself. But without any paramters, chaining does not make any much difference I guess.... Thanks, Ramkumar. WebFOCUS/Tableau Webfocus 8 / 7.7.02 Unix, Windows HTML/PDF/EXCEL/AHTML/XML/HTML5 | |||
|
| Expert |
Francis, I took the code which you provided and went to the parameters tab (in the html composer) and assigned a dynamic / embedded procedure using mdbdates.mas which has the following contents YEAR_NUM WEEK_NUM 2011 1 2010 52 2010 51 2010 50 2010 49 2010 48 2010 47 2010 46 2010 45 2010 44 2010 43 More years and weeks follow... I assicted the first one to year and the second on to week. then I clicked on combobox1 and dragged it (the little gray box) to combobox2. And, Wah La, done with chaining. Is there something else that I'm missing in the solution which you seek?  Note the embedded code: SUM FST.MDBDATES.SEG01.WEEK_NUM BY MDBDATES.SEG01.WEEK_NUM -*insert_filters_here ON TABLE PCHOLD FORMAT XML END Here's the new code <HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7611, 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>
<META name=GENERATOR content="MSHTML 8.00.6001.18975"></HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" nextelementuniquenumber="5" persistentuniqueid="compUid_1">
<SPAN style="Z-INDEX: 1; POSITION: absolute; WIDTH: 790px; HEIGHT: 600px; TOP: 50px; LEFT: 60px" id=panel1 tabIndex=1 elementtype="34" persistentuniqueid="compUid_2">
<SELECT style="Z-INDEX: 2; POSITION: absolute; WIDTH: 150px; TOP: 40px; LEFT: 110px" id=combobox1 tabIndex=2 persistentuniqueid="compUid_3" name="combobox1"></SELECT>
<SELECT style="Z-INDEX: 3; POSITION: absolute; WIDTH: 150px; TOP: 80px; LEFT: 110px" id=combobox2 tabIndex=3 persistentuniqueid="compUid_5" name="combobox2"></SELECT></SPAN>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=IBIMR_domain value=webdevel/webdevel.htm type=hidden name="IBIMR_domain">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=IBIMR_folder value=#douglasleee0 type=hidden name="IBIMR_folder">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibif_ex value=app/test_francis.htm type=hidden name="ibif_ex">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value="webdevel storeoperations baseapp" type=hidden ismre="1" name="ibiapp_app">
<xml id=focus_xmlelement>
<script type="text/xml">
<rootxmlnode top="20" left="993" width="150" height="130">
<variables></variables>
<input_controls>
<input_control bindcontrolid="compUid_3" elementtype="8" name="combobox1" id="combobox1" multiple="0" onetimepopulated="0" inbinding="1" unresolved="0" top="80" left="163" width="105" height="20">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="webdevel storeoperations baseapp" datasource="mdbdates.mas" displayfield="MDBDATES.SEG01.YEAR_NUM" ibiformat="I4" dfformat="I4" datafield="MDBDATES.SEG01.YEAR_NUM" modifiedrequest="0">
<![CDATA[TABLE FILE mdbdates
SUM FST.MDBDATES.SEG01.YEAR_NUM
BY MDBDATES.SEG01.YEAR_NUM
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_5" elementtype="8" name="combobox2" id="combobox2" multiple="0" onetimepopulated="0" inbinding="1" unresolved="0" top="87" left="333" width="140" height="20">
<link linktype="default" from="compUid_3">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="MDBDATES.SEG01.YEAR_NUM" resolveparameter="YEAR_NUM">
<data_info sourcetype="typeMaster" datatype="1" ibiapp_app="webdevel storeoperations baseapp" datasource="mdbdates.mas" displayfield="MDBDATES.SEG01.WEEK_NUM" ibiformat="I2" dfformat="I2" datafield="MDBDATES.SEG01.WEEK_NUM" modifiedrequest="0">
<![CDATA[TABLE FILE mdbdates
SUM FST.MDBDATES.SEG01.WEEK_NUM
BY MDBDATES.SEG01.WEEK_NUM
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></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>
| |||||
|
| Expert |
I don't have any parameters in this page because this page is called from a button on a main page. I use Javascript to populate a form element (parameter) on the main page based on the selected values on this popped-up page, hence to parameters here. Of course I will be told that this is not what HTML Composer is designed to do, Perhaps it should be called Parameter Filler-Outer... Doug, I will give your suggestion a try, thanks. 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 | |||
|
| Guru |
Values being populated through JavaScipt - Oh Oh... That way this is really a headache... Then you need to simulate Chaining as well thorugh JavaScript. I mean write couple of Functions on Onchange event and populate the Select box with needed values. Thanks, Ramkumar. WebFOCUS/Tableau Webfocus 8 / 7.7.02 Unix, Windows HTML/PDF/EXCEL/AHTML/XML/HTML5 | |||
|
| Expert |
Francis, thanks for giving my idea a try... Keep in mind that my way is all HTML Composer. May I ask: (if I cannot ask, then stop righ here LOL) Why are you using JS to populate these DDLs? | |||
|
| Expert |
I have a complex main HTML form. On it are several filters that I've decided to populate from a secondary form - a different HTML window containing a double list. I could not fit six double lists on the main form, and probably wouldn't look right GUI wise. My double list HTML form behaves very well - I open it with an onclick, I populate the previously selected values from the main form. Upon Save, I save them to the main form - everything works. Now, I'd like to add a chained select list to the available selections side of the double list. So, to test, I created a blank html page where I want to set up two select lists that are chained, but I've discovered they must be "bound?" to a parameter, which I don't have. I guess I have to create a dummy fex with a parameter on it and then bring that into my HTML page. Needless to say I could do this a lot faster and with cleaner code than the GUI... 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 | |||
|
| Expert |
That sounds complex enough  ... Have you considered doing something like this:1) Fex to DEFAULT what's need in the Launch Page (LP). 2) -HTMLFORM ... (LP 1) which spawns fex 2. 3) Fex 2: takes the info from LP1 and does a -HTMLFORM (LP 2) with all the previous values 4) LP 2 executes (final fex) which has the parameters need for the binding in LP 2? OR starting with "LP 2" and "final fex" with the parm:value pairs hidden and passed from LP 1? I did this at Ford (see Ford Motor Company / Item 1 for a sample). We called it a dual launch page. LP 1 is the top (white section) / LP 2 is the lower (gray section). | |||
|
| Expert |
What about using a hidden <div> to hold the extra controls? T
| |||||||||
|
| Expert |
Tony, which controls do I put in a hidden div? And, if it's hidden it won't display in HTML Composer. I would simply like to chain two select lists and have their values populated by a dynamic execution of a fex. Why on earth do report variables have to be involved? 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 | |||
|
| Guru |
This will be shown in the painter... But not in The Browser. They can be included in chaining as well. I have worked out one complex screen this way. Thanks, Ramkumar. WebFOCUS/Tableau Webfocus 8 / 7.7.02 Unix, Windows HTML/PDF/EXCEL/AHTML/XML/HTML5 | |||
|
| Expert |
In my experience with HTML Composer v7.6.8 and v7.6.11, if something is hidden using CSS, it is hidden on the "Design" tab, it may very well be in the "HTML" tab, but that is not the objective of HTML Composer. 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 | |||
|
| Expert |
Which ever ones you wish to True, but I was just suggesting another method other than creating a new browser session (or tab etc.) so that all your code would be self cotained and therefore easier to deal with. Using methods mentioned in other posts, you could make these visible whilst manipulating within DS. In fact I have just coded such a thing because the of the fact that I was already pushing the limits for sum of by fields and across fields in a report (each "cell" is a potential input control) but still had need for input of more data, so I used a div which I style.display = block or none as necessary. As you know, I prefer hand coding but (with rel 7.7.n) I have now taken to using the GUI for as much as I can and then adding the stuff that would be more "challenging" in the GUI. Works for me and that approach has helped me understand the interaction between the new embedded XML section and the ibirls3.js functions etc. I have used modal dialogues before to give a similar functionality but wouldn't suggest them unless you are definitely only using IE as FireFox doesn't support them. Good luck T
| |||||||||
|
| Expert |
Tony, thanks for your assistance - I hope I one day will have your (new-found?) patience with HTML Composer... 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 | |||
|
| Expert |
... through necessity  T
| |||||||||
|
| Guru |
Francis, I see you are running v7.6.8 so I don't know if this helps or not. In 7.6.9 you can chain controls without the use of any 'parameters'. By this I mean that you don't need to set up the ampervariable in your procedure nor do you need to use the Add Parameter function in the HTML Composer. The key is setting the 'Resolves Parameter' value in the properties and settings screen for the chain itself. Look at the first example in the code below and notice how listboxes 1 and 2 chain together with no parameters used at all. In the second example notice how I am using ampervariables in the procedure code that populates listbox 5 but I did not need to create any within the HTML page. I did use a -DEFAULT in listbox 5 simply to give it a value for when the page initially loads. You'll also notice that there is no report procedure associated with the page so I'm not leveraging any parameters used there either.
<!-- 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="Gen 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>
<META name=GENERATOR content="MSHTML 8.00.7600.16722"></HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" nextelementuniquenumber="6" persistentuniqueid="compUid_1">
<SELECT style="Z-INDEX: 1; POSITION: absolute; WIDTH: 260px; TOP: 10px; LEFT: 10px" id=listbox1 tabIndex=1 size=3 persistentuniqueid="compUid_2" name="listbox1"></SELECT>
<SELECT style="Z-INDEX: 2; POSITION: absolute; WIDTH: 330px; HEIGHT: 300px; TOP: 10px; LEFT: 480px" id=listbox2 tabIndex=2 size=20 persistentuniqueid="compUid_3" name="listbox2"></SELECT>
<SELECT style="Z-INDEX: 3; POSITION: absolute; WIDTH: 260px; TOP: 330px; LEFT: 10px" id=listbox3 tabIndex=3 size=3 persistentuniqueid="compUid_4" name="listbox3"></SELECT>
<SELECT style="Z-INDEX: 4; POSITION: absolute; WIDTH: 190px; HEIGHT: 440px; TOP: 330px; LEFT: 280px" id=listbox4 tabIndex=4 size=26 persistentuniqueid="compUid_5" name="listbox4"></SELECT>
<SELECT style="Z-INDEX: 5; POSITION: absolute; WIDTH: 330px; HEIGHT: 300px; TOP: 330px; LEFT: 480px" id=listbox5 tabIndex=5 size=3 persistentuniqueid="compUid_6" name="listbox5"></SELECT>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=IBIMR_domain value=dantemps/dantemps.htm type=hidden name="IBIMR_domain">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=IBIMR_folder value=#testbieeulvo type=hidden name="IBIMR_folder">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibif_ex value=app/chainwithoutparm.htm type=hidden name="ibif_ex">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value="oelink enginlink cvlink partslink baseapp dantemp" type=hidden ismre="1" name="ibiapp_app">
<xml id=focus_xmlelement>
<script type="text/xml">
<rootxmlnode top="20" left="1157" width="150" height="130">
<variables>
</variables>
<input_controls>
<input_control bindcontrolid="compUid_2" elementtype="9" name="listbox1" id="listbox1" multiple="0" inbinding="1" unresolved="0" onetimepopulated="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="oelink enginlink cvlink partslink baseapp dantemp" datasource="PERSINFO.mas" displayfield="COUNTRY" ibiformat="A15" dfformat="A15" datafield="COUNTRY" modifiedrequest="0" selectedvalue="USA">
<![CDATA[TABLE FILE PERSINFO
SUM FST.COUNTRY
BY COUNTRY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_3" elementtype="9" name="listbox2" id="listbox2" multiple="0" inbinding="1" unresolved="0" onetimepopulated="0">
<link linktype="default" from="compUid_2">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="COUNTRY" resolveparameter="COUNTRY">
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="oelink enginlink cvlink partslink baseapp dantemp" datasource="PERSINFO.mas" displayfield="CITY" ibiformat="A20" dfformat="A20" datafield="CITY" modifiedrequest="0">
<![CDATA[TABLE FILE PERSINFO
SUM FST.CITY
BY CITY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_4" elementtype="9" name="listbox3" id="listbox3" multiple="0" inbinding="1" unresolved="0" onetimepopulated="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="oelink enginlink cvlink partslink baseapp dantemp" datasource="PERSINFO.mas" displayfield="COUNTRY" ibiformat="A15" dfformat="A15" datafield="COUNTRY" modifiedrequest="0" selectedvalue="USA">
<![CDATA[TABLE FILE PERSINFO
SUM FST.COUNTRY
BY COUNTRY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_5" elementtype="9" name="listbox4" id="listbox4" multiple="0" inbinding="1" unresolved="0" top="409" left="373" width="60" height="20" onetimepopulated="0">
<link linktype="default" from="compUid_4">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="COUNTRY" resolveparameter="COUNTRY">
<data_info modifiedrequest="1" sourcetype="typeMaster" datatype="0" selectedvalue="" ibiformat="A1" accept="0" addalloption="0" operation="NONE">
<static_values>
<static value="A" display="A" selected="1"></static>
<static value="B" display="B" selected="0"></static>
<static value="C" display="C" selected="0"></static>
<static value="D" display="D" selected="0"></static>
<static value="E" display="E" selected="0"></static>
<static value="F" display="F" selected="0"></static>
<static value="G" display="G" selected="0"></static>
<static value="H" display="H" selected="0"></static>
<static value="I" display="I" selected="0"></static>
<static value="J" display="J" selected="0"></static>
<static value="K" display="K" selected="0"></static>
<static value="L" display="L" selected="0"></static>
<static value="M" display="M" selected="0"></static>
<static value="N" display="N" selected="0"></static>
<static value="O" display="O" selected="0"></static>
<static value="P" display="P" selected="0"></static>
<static value="Q" display="Q" selected="0"></static>
<static value="R" display="R" selected="0"></static>
<static value="S" display="S" selected="0"></static>
<static value="T" display="T" selected="0"></static>
<static value="U" display="U" selected="0"></static>
<static value="V" display="V" selected="0"></static>
<static value="W" display="W" selected="0"></static>
<static value="X" display="X" selected="0"></static>
<static value="Y" display="Y" selected="0"></static>
<static value="Z" display="Z" selected="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_6" elementtype="9" name="listbox5" id="listbox5" multiple="0" inbinding="1" unresolved="1" onetimepopulated="0">
<link linktype="default" from="compUid_5">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="STARTSWITH" resolveparameter="STARTSWITH">
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="oelink enginlink cvlink partslink baseapp dantemp" datasource="PERSINFO.mas" displayfield="CITY" ibiformat="A20" dfformat="A20" datafield="CITY" modifiedrequest="1">
<![CDATA[-DEFAULT &COUNTRY = 'USA';
-SET &CITYVAL = '''&STARTSWITH.EVAL'||'%''';
TABLE FILE PERSINFO
SUM FST.CITY
BY CITY
WHERE COUNTRY EQ &COUNTRY.QUOTEDSTRING;
WHERE CITY LIKE &CITYVAL;
ON TABLE PCHOLD FORMAT XML
END
]]></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>
Cheers, Dan 7.7.05M/7.7.03 HF6 on Windows Server 2003 SP2 output to whatever is required. | |||
|
| Expert |
LOL | |||
|
| Expert |
Dan, I just saw your response, thanks very much for letting me know - I'll just have to wait until we upgrade. Regards, 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 | |||
|
| Master |
Francis, Please PM me your email address to send you a document I've written to do some dynamic chaining. I'd like to post it here or as a technique, but would like a second set of eyeballs on it to make sure it is ready for public consumption. I'm not sure if it is this exact issue, but I recall you having some frustration on the general topic recently. -ABT ------------------------------------ WF Environment: ------------------------------------ Server/Client, ReportCaster, Dev Studio: 7.6.11 Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist OS: Windows Server 2003 Application/Web Server: Tomcat 5.5.25 Java: JDK 1.6.0_03 Authentication: LDAP, MRREALM Driver Output: PDF, EXL2K, HTM ------------------------------------ Databases: ------------------------------------ Oracle 10g DB2 (AS/400) MSSQL Server 2005 Access/FoxPro | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [UNHAPPILY CLOSED] Dev Studio HTML Composer: Why can't I chain two select list boxes?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [UNHAPPILY CLOSED] Dev Studio HTML Composer: Why can't I chain two select list boxes?Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |