[CLOSED] Chaining does not work with PLUS sign

April 02, 2012, 12:57 PM

Hi All,

We are having issues with chaining and it seems the cause is a "+" sign. I was able to replicate the issue with the CAR file. Below are 3 FEXES with output to XML and a HTML launch page. The value from the CAR dropdown is passed properly to the MODEL dropdown if the value does not have a "+" sign.

Your help is greatly appreciated.

UPDATE: We tried replacing + with - and it behaves the same way.

-* File test_param_country.fex
-*-SET ECHO = ALL;

TABLE FILE CAR
SUM COUNTRY
BY COUNTRY
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE PCHOLD FORMAT XML
END
-RUN

-* File test_param_car.fex
-*-SET ECHO = ALL;

-DEFAULT &COUNTRY = 'ITALY'

DEFINE FILE CAR
CAR/A20 = IF CAR EQ 'ALFA ROMEO' THEN 'ALFA + ROMEO' ELSE CAR;
END

TABLE FILE CAR
SUM CAR AS 'CAR'
BY CAR AS 'CAR'
WHERE COUNTRY EQ '&COUNTRY'
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE PCHOLD FORMAT XML
END
-RUN

-* File test_param_model.fex
-*-SET ECHO = ALL;

-DEFAULT &COUNTRY = 'ITALY'
-DEFAULT &CAR = 'ALFA + ROMEO'

DEFINE FILE CAR
CAR/A20 = IF CAR EQ 'ALFA ROMEO' THEN 'ALFA + ROMEO' ELSE CAR;
END

TABLE FILE CAR
SUM MODEL
BY MODEL
WHERE COUNTRY EQ '&COUNTRY'
WHERE CAR EQ '&CAR'
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE PCHOLD FORMAT XML
END
-RUN

HTML (test_chain_plus_sign.htm):

<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var rltVersion = "76";
var cgipath = "cgipath";
var ibirls = "ibirls2";

var rltdyncalendar = "rltdyncalendar";
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_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>

<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);</SCRIPT>

<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</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
}
//End function window_onload
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true">
<SELECT style="Z-INDEX: 1; POSITION: absolute; WIDTH: 330px; TOP: 80px; LEFT: 150px" id=COUNTRY tabIndex=1 name=COUNTRY newchainnumber="0" sourcetype="typeFex" datatype="1" datasource="test_param_country.fex" ibic_server="EDASERVE" ibiapp_app="dan_test" chainnumber="0" inchainindex="1" cacheruntimedata="1"></SELECT>
<SELECT style="Z-INDEX: 2; POSITION: absolute; WIDTH: 330px; TOP: 130px; LEFT: 150px" id=CAR tabIndex=2 name=CAR newchainnumber="0" sourcetype="typeFex" datatype="1" datasource="test_param_car.fex" ibic_server="EDASERVE" ibiapp_app="dan_test" chainnumber="0" inchainindex="2" cacheruntimedata="1"></SELECT>
<SELECT style="Z-INDEX: 3; POSITION: absolute; WIDTH: 330px; TOP: 180px; LEFT: 150px" id=MODEL tabIndex=3 name=MODEL newchainnumber="0" sourcetype="typeFex" datatype="1" datasource="test_param_model.fex" ibic_server="EDASERVE" ibiapp_app="dan_test" chainnumber="0" inchainindex="3" cacheruntimedata="1"></SELECT>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden inputcontrolids="COUNTRY;CAR;MODEL">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=dan_test type=hidden name=ibiapp_app>
<SCRIPT id=IBI_ChainScript type=text/javascript>
<!--
window.chain0=new Array(1);
window.chain0[0]=new String("COUNTRY;CAR;MODEL");
window.chain0[1]=0
//--></SCRIPT>
</BODY></HTML>

This message has been edited. Last edited by: Kerry,

April 02, 2012, 03:10 PM

Mary Watermann

I was able to get you code to work.

1. In the HTML Composer select the PARAMETER tab
2. Click on the ARROW between COUNTRY and CAR
3. In the Properties and Settings window, select COUNTRY from the "..." for the "Resolves parameter" value.
4. Repeat #3 for the next chain (arrow) but this time select CAR.

April 02, 2012, 04:54 PM

dballest

Thanks for the reply Mary. I switched my DevStudio to 7.7.03 and updated the HTML file as per your suggestion but no luck. I then proceeded to re-create the file in 7703 and it works now. I need to convert test this file into Webfocus 7.6.2 (production version). I'll keep you posted.

Thanks,
Dan

This message has been edited. Last edited by: dballest,