 |
|||||
|
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Chained Comboboxes | Login/Join |
| Platinum Member |
We have a self service application built by using WebFocus HTML Layout tool. We have may parameters to be passed from GUI to the reports on each tab (a html page). We have many tabs in that application. The application is working just fine. Now we are asked to pass parameters from one tab to another tab. If users click SUBMIT button on the same tab, use the current selected parameters. If users jump from one tab to another tab, default to the previous parameters (need to pass the parameters from tab to tab). I save all users selections to a database and can pass all the parameters to the next tab and reports generated correctly without issues. I use javascript in the window_onload() function in the html file to hightlight the selections in the comboBoxes and radio buttons. The only issue is with the chained listbox by using this approach (I use focexec programs to get data). For car database as an example, the combobox shows country, the listBox shows car when country is selected. When the form opens, I can have JAPAN selected as a country from the comboBox, but how can I have DATASUN, TOYOTA shown(not JAGUAR, JENSEN and TRIUMPH) in the listbox by using javascript code through window_onload function. Has anyone done this through this approach or done in different ways? I am thinking Webfocus must have an internal event handler or functions to call for the chained comboBoxes. When you click on chained box1, the values in chained box2 will be refreshed automatically based on your selection. Is there any way we can trigger this event handler or call this type of function? We are using webfocus 7.63 for Windows Server 2003. COUNTRY CAR ENGLAND JAGUAR JENSEN TRIUMPH FRANCE PEUGEOT ITALY ALFA ROMEO MASERATI JAPAN DATSUN TOYOTA W GERMANY AUDI BMWThis message has been edited. Last edited by: Kerry, | ||
|
| Expert |
Not knowing what you do in your onload step, but I would have thought, that what loads or positions your first list could then populate the second, and so on. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
Lush, When an HTML file, created within painter, is opened the onload function is called. This onload function is held within IBIRLS2.js and contains most of the js used to control things such as chained combo boxes etc. One of the things that the onload function does is to prepend "onchange" events to combo boxes in general which is designed to call the AJAX process to load control values from a fex or a master. You can see that what you need to do is to call that function yourself at the appropriate time. The function is called "populateDynamicCtrl();" and it expects an object variable to be passed - so something like - objCtrl = document.getElementById(your control id goes here); populateDynamicCtrl(objCtrl); Good luck T
| |||||||||
|
| Platinum Member |
Thank you Tonay and Waz for your response. I did try to call a few js functions in ibirls2.js, such as populateDynamicCtrl(objCtrl) and populateChainElementFromServer(element), and it just inialized to the default, which showed the first (for car db as an example) COUNTRY in the combobox and the CAR belongs to the first country. To answer Waz question: I use onload function to position users' selections from comboboxes, radio buttons. When I have this statement document.all.COUNTRY.options[3].selected = true; WHICH MEANS user selected JAPAN as a country. Meanwhile, I wish it shows DATASUN and TOYOTA in the chained listbox. However it shows JAGUAR JENSEN TRIUMPH. The chained box does not automatically refresh if you set your selected COUNTRY in js unless you make a different selections from GUI (I guess it fires onchange event). I tried to code onchange event handler and then call it from onload function, but not successful. This is a kind of 2 steps process, first you carry over the parameters in focexec and send your request to the reporting server to get report right, then you also want users see their selections on GUI correctly. I have everything working correctly except the chained listbox. Any help is appreciated. | |||
|
| Platinum Member |
Hope some experts from IBI can provide some ideas, or tell us if this is feasible with this product. | |||
|
| Virtuoso |
Suggestion: rather than trying to push the content to the new tab (which is a challenge when the content is not a simple "value"), an alternative is to have the tab pull the content, whenever the tab comes into view, from the most recently visible tab that shares each of its respective parameters use a global array of objects, keyed to parameter name, to hold source info for obtaining the latest content and status: before a tab loses focus, it sets the pointer for each of its parameters to itself. (I'm not sure that the tab's 'loss of focus' can be sensed -- if not, do it whenever it loads or regains focus, but after it updates its content from other tabs.) Thus, on a perpetual accounting basis, you know what's the freshest source for each parameter. On load of a tab and when it regains focus, if the global array's pointer is non-null and points to a different tab as the latest source, then refresh from that tab: Depending on the type of control, either copy the value from the other tab, or (for a SELECT group) copy the array of options and their attributes. Radio groups can also be handled. At any given moment, some hidden tabs may be out of sync, but that does not matter -- they get updated as needed whenever they come into view. - Jack Gross WF through 8.1.05 | |||
|
| Guru |
Lusheng, Rather than call the onchange handler from your onload, just call UpdateData(). What I always when I want to mimic WebFOCUS screen behaviours is to use a javascript debugger to find out what they are doing and then replicate it. Fernando Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03 | |||
|
| Platinum Member |
Fernando, the UpdateData() function is called in window_onload function by default. However I did try to pass different values in the argument by calling it again after some js statements. It did not do that work. | |||
|
| Expert |
Lusheng, Have you thought about setting Cookie values, writing out to a txt file, the, read them back in??? Short example:
FI VARS DISK vars.txt
-RUN
-WRITE VARS setC("CHTX","&CHTX.EVAL");
-WRITE VARS setC("CHT","&CHT.EVAL");
-WRITE VARS setC("CHTTXT","&L0TXT.EVAL");
-WRITE VARS setC("ORG","&ORG.EVAL");
-WRITE VARS setC("LEV","&LEV.EVAL");
-WRITE VARS setC("LEVUP1","&LEVUP1.EVAL");
-WRITE VARS setC("LEVDN1","&LEVDN1.EVAL");
-WRITE VARS setC("STRLEV","&STRLEV.EVAL");
-WRITE VARS setC("ORGDIV","&ORGDIV.EVAL");
etc...
THEN
LOOP or -REPEAT to get the variables you need..
-READ VARS NOCLOSE etc....
In your JavaScript, some functions:
function htmCall(){
//This function is called when the user clicks on HTM.
//Set the Format cookie:
setC("WFFMT",'HTML');
document.getElementById('iframe1').src="/ibi_apps/WFServlet?IBIC_server=EDASERVE&IBIAPP_app=" + '!IBI.AMP.RPMAPP;' + "&IBIF_ex=waldo&Random=" + Math.random();
}
function pdfCall(){
//This function is called when the user clicks on PDF.
//Set the Format cookie:
setC("WFFMT",'PDF');
pdf_fmt_src = fmt_src + "&Random=" + Math.random();
window.open(pdf_fmt_src, '_blank', "toolbar=0,resizable=1");
}
function exlCall(){
//This function is called when the user clicks on EXL.
//Set the Format cookie:
setC("WFFMT",'EXL2K');
exl_fmt_src = fmt_src + "&Random=" + Math.random();
window.open(exl_fmt_src, '_blank', "toolbar=1,resizable=1");
}
var bGrps = '!IBI.AMP.BTNCD;';
setC("BTNCD",bGrps);
//
var bGrp1 = bGrps.substr(0, 1);
var bGrp2 = bGrps.substr(1, 1);
var bGrp3 = bGrps.substr(2, 1);
var bGrp4 = bGrps.substr(3, 1);
var bGrp5 = bGrps.substr(4, 1);
var bGrp6 = bGrps.substr(5, 1);
var bGrp7 = bGrps.substr(6, 1);
var bGrp8 = bGrps.substr(7, 1);
var bGrp9 = bGrps.substr(8, 1);
var bGrp10 = bGrps.substr(9, 1);
var bGrp11 = bGrps.substr(10, 1);
var bGrp12 = bGrps.substr(11, 1);
var bGrp13 = bGrps.substr(12, 1);
Just a thought... Hope this helps... Tom Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Virtuoso |
-- Camel-cased function names? -- Double-quoted arguments? Appears to be an odd marriage of js and DM. Please explain. - Jack Gross WF through 8.1.05 | |||
|
| Expert |
Jack, Maybe this will help:
-* Run the Previous FEX with the new ORG and LEV values (use "most-of" the cookie)
-*-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-*
-HTMLFORM BEGIN
<HTML>
<HEAD>
<SCRIPT src="/ibi_html/javaassist/ibi/html/js/ibicookie.js" type=text/javascript></SCRIPT>
<SCRIPT type=text/javascript>
//
function setC(parm,val) {
SetIBICookieElement("WF_USER", parm, val, "/");
}
//
function setVars() {
//
setC("CHTX","&CHTX.EVAL");
setC("CHT","&CHT.EVAL");
setC("CHTTXT","&L0TXT.EVAL");
setC("ORG","&ORG.EVAL");
setC("LEV","&LEV.EVAL");
setC("LEVUP1","&LEVUP1.EVAL");
setC("LEVDN1","&LEVDN1.EVAL");
setC("STRLEV","&STRLEV.EVAL");
setC("ORGDIV","&ORGDIV.EVAL");
setC("L1KEY","&L1KEY.EVAL");
setC("L2KEY","&L2KEY.EVAL");
setC("L3KEY","&L3KEY.EVAL");
setC("L4KEY","&L4KEY.EVAL");
setC("L5KEY","&L5KEY.EVAL");
setC("L6KEY","&L6KEY.EVAL");
setC("L1TXT","&L1TXT.EVAL");
setC("L2TXT","&L2TXT.EVAL");
setC("L3TXT","&L3TXT.EVAL");
setC("L4TXT","&L4TXT.EVAL");
setC("L5TXT","&L5TXT.EVAL");
setC("L6TXT","&L6TXT.EVAL");
setC("GVW","&GVW.EVAL");
setC("GVWTXT","&GVWTXT.EVAL");
setC("GEOLBL","&GEOLBL.EVAL");
setC("MKTLBL","&MKTLBL.EVAL");
setC("MKTTXT","&MKTTXT.EVAL");
setC("DMALBL","&DMALBL.EVAL");
setC("DMATXT","&DMATXT.EVAL");
setC("STLBL","&STLBL.EVAL");
setC("STCD","&STCD.EVAL");
setC("STTXT","&STTXT.EVAL");
setC("SEP1","&SEP1.EVAL");
setC("SEP2","&SEP2.EVAL");
setC("SEP3","&SEP3.EVAL");
setC("SEP4","&SEP4.EVAL");
setC("SEP5","&SEP5.EVAL");
setC("BUSDATE","&BUSDATE.EVAL");
setC("RPMAPP","&RPMAPP.EVAL");
setC("RPMFEX","&RPMFEX.EVAL");
setC("WFFMT","&WFFMT.EVAL");
//
top.cntl.runFex('!IBI.AMP.RPMAPP;', '!IBI.AMP.RPMFEX;');
}
</SCRIPT>
</HEAD>
<BODY onLoad="setVars();">
</BODY>
</HTML>
-HTMLFORM END
Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Platinum Member |
Tom, thanks for your response and sample code. I write the values to a database, and can get back values to the reports. The only issue is positioning in the chained listbox on the GUI side. I think setting cookie values is no difference comparing with writing values to the database within a session, though I have not tried that. | |||
|
| Virtuoso |
Got it. - Jack Gross WF through 8.1.05 | |||
|
| Expert |
Lush, Apologies for not replying yesterday, I didn't have a great deal of time to spare here. Ok, so calling the populate ctrl function only gave you the first entry in the selection and what you really want is to position the combo box at the value being passed to the HTML page? That being the case, then just have a javascript function of your own which instantiates a variable with the value required and then locate it within the combo box and set the selected attribute for that index to true. Using this function you can achieve just that. Just make a call to the function and pass the combo box Id and the value at which point you want the combo box positioned. function position_ctrl(ctrlid,value) {
objCtrl = document.getElementById(ctrlid);
for (i=0; i<objCtrl.length; i++) {
if (objCtrl[i].value == value) {
objCtrl.selectedIndex = i;
}
}
}Good luck T
| |||||||||
|
| Platinum Member |
Hi Tony, To make my question more clear, I coded a simple sample htm file and 3 focexec. The htm file contains a chained listbox and a combobox. I added js function there called position_controls() which is called from window_onload. I position COUNTRY to index 3, which is JAPAN, how can I position the car which are made in JAPAN in the chained listbox (by default it shows cars made in ENGLAND)? Below are my sample programs (1 htm file and 3 focexecs), and you can copy to your DeveloperStudio to test (I created project folder called test): [CODE]< !-- Generated by Report Layout Painter --> <script id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){ } <script id=IBI_OptionsScript type=text/javascript> var rltVersion = "764"; var cgipath = "cgipath"; var ibirls = "ibirls2"; 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 id=IBI_nls src="/ibi_html/javaassist/nls.js" type=text/javascript> <script id=IBI_ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript> <script id=IBI_ibigblloadCss type=text/javascript> ibigblloadCss(null); <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 position_controls(); } //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 function position_controls() { document.all.COUNTRY.options[3].selected = true; //how to positon CARs made in the above specified country in the listbox CAR } <script for=window eventname="onload">window.onload = function() { window_onload(); } <iframe id=report1 style="Z-INDEX: 3; LEFT: 110px; OVERFLOW: auto; WIDTH: 610px; POSITION: absolute; TOP: 260px; HEIGHT: 260px" tabIndex=3 name=report1 elementtype="2" autoExecute="False" requests_list="0"> <script id=IBI_ChainScript type=text/javascript> < !-- window.chain0=new Array(1); window.chain0[0]=new String("combobox1;listbox1"); window.chain0[1]=1242368 //--> <script id=IBI_ChainScript type=text/javascript> < !-- window.chain0=new Array(1); window.chain0[0]=new String("combobox1;listbox1"); window.chain0[1]=0 //--> <script> < ![CDATA[TABLE FILE CAR PRINT MODEL SALES BY COUNTRY BY CAR WHERE COUNTRY EQ '&COUNTRY' AND CAR EQ '&CAR' END]]> | |||
|
| Expert |
Lush, Firstly, go back and edit your previous post and place all of your code between [ code] and [/code] tags (without spaces in the tags). Try this code within your position_controls() function - remove your existing code as this will replace it. document.getElementById("combobox1").selectedIndex = 3;
objCtrl = document.getElementById("listbox1");
setTimeout('populateDynamicCtrl(objCtrl)',250);Let me know how you get on T
| |||||||||
|
| Platinum Member |
<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var rltVersion = "764";
var cgipath = "cgipath";
var ibirls = "ibirls2";
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_ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript></SCRIPT>
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);</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
position_controls();
}
//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
function position_controls() {
document.all.COUNTRY.options[3].selected = true;
//how to positon CARs made in the above specified country in the listbox CAR
}
</SCRIPT>
<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true">
<SELECT id=combobox1 style="Z-INDEX: 1; LEFT: 100px; WIDTH: 150px; POSITION: absolute; TOP: 160px" tabIndex=1 name=COUNTRY newchainnumber="0" ibiapp_app="test" ibic_server="EDASERVE" chainnumber="0" inchainindex="1" operation datafield displayfield datasource="GETCOUNTRY.fex" datatype="1" sourcetype="typeFex" cacheruntimedata="0"></SELECT>
<SELECT id=listbox1 style="Z-INDEX: 2; LEFT: 280px; WIDTH: 260px; POSITION: absolute; TOP: 160px" tabIndex=2 multiple size=3 name=CAR newchainnumber="0" ibiapp_app="test" ibic_server="EDASERVE" chainnumber="0" inchainindex="2" operation="OR" datafield displayfield datasource="GETCAR.fex" datatype="1" sourcetype="typeFex" cacheruntimedata="0" addalloption="0" accept="0"></SELECT>
<IFRAME id=report1 style="Z-INDEX: 3; LEFT: 110px; OVERFLOW: auto; WIDTH: 610px; POSITION: absolute; TOP: 260px; HEIGHT: 260px" tabIndex=3 name=report1 elementtype="2" autoExecute="False" requests_list="0"></IFRAME>
<INPUT language=javascript id=button1 style="Z-INDEX: 4; LEFT: 600px; WIDTH: 120px; POSITION: absolute; TOP: 170px; HEIGHT: 30px" onclick=button1_OnClick(this) tabIndex=4 type=button value=Run name=button1 requests_list="1">
<SCRIPT id=IBI_ChainScript type=text/javascript>
<!--
window.chain0=new Array(1);
window.chain0[0]=new String("combobox1;listbox1");
window.chain0[1]=1242368
//--></SCRIPT>
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden inputcontrolids="combobox1;listbox1">
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value="test baseapp" name=ibiapp_app>
<SCRIPT id=IBI_ChainScript type=text/javascript>
<!--
window.chain0=new Array(1);
window.chain0[0]=new String("combobox1;listbox1");
window.chain0[1]=0
//--></SCRIPT>
<xml id=ibi_requests>
<script>
<requests>
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0">
<![CDATA[TABLE FILE CAR
PRINT MODEL SALES
BY COUNTRY
BY CAR
WHERE COUNTRY EQ '&COUNTRY' AND CAR EQ '&CAR'
END]]>
<variables>
<variable field="COUNTRY" file="car.mas" desc="COUNTRY" datatype="0" operation="" default="" name="COUNTRY" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="7" create="1"></variable>
<variable field="CAR" file="car.mas" desc="CAR" datatype="0" operation="" default="" name="CAR" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="7" create="1"></variable></variables></request>
<request requestid="1" sourcetype="typeFex" targettype="iframe" targetname="report1" ibif_ex="ShowCnCars.fex" ibic_server="" activereport="0" reportcolumns="" ibiapp_app="test baseapp">
<variables>
<variable field="COUNTRY" file="car.mas" desc="COUNTRY" datatype="0" operation="" default="" name="COUNTRY" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="7" create="1"></variable>
<variable field="CAR" file="car.mas" desc="CAR" datatype="0" operation="" default="" name="CAR" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="7" create="1"></variable></variables></request></requests></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
getActiveReportJscript();
setUserInfo();
</SCRIPT>
</HTML> | |||
|
| Platinum Member |
Thanks Tony! I did not realize some htm code were gone, so reposted. The focexec programs are same. | |||
|
| Platinum Member |
I opened a case with IBI support, the consultant had replicated the problem and presented to the product manager. Thanks for everyone's response. | |||
|
| Virtuoso |
Two oddities: 1. no FORM 2. This script code appears twice: <SCRIPT id=IBI_ChainScript type=text/javascript> <!-- window.chain0=new Array(1); . . . - Jack Gross WF through 8.1.05 | |||
|
| Platinum Member |
1. FORM is optional in html layout. 2. Why did script code appear twice? I don't know. I guess I tried to chain the controls twice. First time I did see the code generated, so I did it again. However it does not affect funcitoning from my developer studio. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 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 |