 |
|||||
|
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 |
| Problems with using parameters | Login/Join |
| Platinum Member |
I got an issue with starting an application made in the HTML composer. What I have to make is that web1 has to start using an URL and than thru a drilldown starting web2 with given parameters. The problem is that the first web1 doesn't receive parameter &NAM and the second web2 doesn't receive parameters &NAM and &COUNTRY. What can I do to make this work? Used URL: http://localhost:8080/approot/...web1.htm?&NAM=Person Here by the source source Web1
<!-- 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 7701, 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>
<STYLE id=ibi_defaultstyleElt type=text/css>.tabitemsclass {
BACKGROUND-COLOR: white
}
</STYLE>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" thumbnailscale="4">
<SPAN style="Z-INDEX: 2; POSITION: absolute; WIDTH: 1270px; HEIGHT: 740px; TOP: 70px; LEFT: 50px" id=tab1 tabIndex=2 elementtype="38" tabitemsdefaultdist="5" tablocation="top" tabitemsdefaultwidth="100" tabitemsdefaultheight="25" tabedgerounded="straight">
<SPAN style="Z-INDEX: 5; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 26px; BORDER-TOP: gold 3px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 0px; LEFT: 15px" id=tabitem1 class=tabitemsclass tabIndex=3 elementtype="39" tabbody="tabitembody1" selectedtab="true">Tab #1</SPAN>
<SPAN style="Z-INDEX: 4; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1270px; DISPLAY: block; HEIGHT: 715px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody1 class=tabitemsclass tabIndex=4 elementtype="40">
<IFRAME style="Z-INDEX: 6; POSITION: absolute; WIDTH: 630px; HEIGHT: 660px; OVERFLOW: auto; TOP: 15px; LEFT: 50px" id=report1 tabIndex=7 src="" frameBorder=no elementtype="2" HEIGHTOLD="660" WIDTHOLD="630" autoExecute="True" requests_list="0" name="report1"></IFRAME></SPAN>
<SPAN style="Z-INDEX: 3; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 22px; BORDER-TOP: teal 1px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 3px; LEFT: 120px" id=tabitem2 class=tabitemsclass tabIndex=5 elementtype="39" tabbody="tabitembody2" selectedtab="false">Tab #2</SPAN>
<SPAN style="Z-INDEX: 2; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1270px; DISPLAY: none; HEIGHT: 715px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody2 class=tabitemsclass tabIndex=6 elementtype="40"></SPAN></SPAN>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden tabcontrolids="tab1">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag 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">
<rootxmlnode focoption="_FOC_NULL">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0">
<![CDATA[-* File fex1.fex
-SET &ECHO=ALL;
-DEFAULT &NAM = '';
TABLE FILE CAR
PRINT
'CAR.ORIGIN.COUNTRY'
'CAR.COMP.CAR'
'CAR.CARREC.MODEL'
HEADING
"Name : &NAM"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=DATA,
COLUMN=N1,
TARGET='_parent',
URL=http://localhost:8080/approot/webpag/web2.htm?( \
COUNTRY=N1 \
NAM=&NAM.QUOTEDSTRING \
),
$
ENDSTYLE
END]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
source Web2 <!-- 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 7701, 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" edaconnectionrequired="true" elementtype="21" thumbnailscale="4">
<IFRAME style="Z-INDEX: 1; POSITION: absolute; WIDTH: 560px; HEIGHT: 770px; OVERFLOW: auto; TOP: 20px; LEFT: 30px" id=report1 tabIndex=1 src="" frameBorder=no elementtype="2" HEIGHTOLD="770" WIDTHOLD="560" autoExecute="True" requests_list="0" name="report1"></IFRAME>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag 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">
<rootxmlnode focoption="_FOC_NULL">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="COUNTRY" name="COUNTRY" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="COUNTRY" ibiformat="A10" datafield="COUNTRY" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0">
<![CDATA[-* File fex2.fex
-SET &ECHO=ALL;
-DEFAULT &COUNTRY = '';
-DEFAULT &NAM = '';
TABLE FILE CAR
PRINT
'CAR.ORIGIN.COUNTRY'
'CAR.COMP.CAR'
'CAR.CARREC.MODEL'
WHERE CAR.ORIGIN.COUNTRY = '&COUNTRY'
HEADING
"Name : &NAM"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
| ||
|
| Expert |
You can't pass parameter values via a HTML page URL, without having to resort to complicated JavaScript. A much easier way is to call a fex that includes the HTML page. I created to fexes and made minor tweaks to the HTML and now parameters are passed. web1.fex -DEFAULT &NAM = 'Default Name 1'; -HTMLFORM web1.htm web1.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 7701, 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>
<STYLE id=ibi_defaultstyleElt type=text/css>.tabitemsclass {
BACKGROUND-COLOR: white
}
</STYLE>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" thumbnailscale="4">
<SPAN style="Z-INDEX: 2; POSITION: absolute; WIDTH: 1270px; HEIGHT: 740px; TOP: 70px; LEFT: 50px" id=tab1 tabIndex=2 elementtype="38" tabitemsdefaultdist="5" tablocation="top" tabitemsdefaultwidth="100" tabitemsdefaultheight="25" tabedgerounded="straight">
<SPAN style="Z-INDEX: 5; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 26px; BORDER-TOP: gold 3px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 0px; LEFT: 15px" id=tabitem1 class=tabitemsclass tabIndex=3 elementtype="39" tabbody="tabitembody1" selectedtab="true">Tab #1</SPAN>
<SPAN style="Z-INDEX: 4; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1270px; DISPLAY: block; HEIGHT: 715px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody1 class=tabitemsclass tabIndex=4 elementtype="40">
<IFRAME style="Z-INDEX: 6; POSITION: absolute; WIDTH: 630px; HEIGHT: 660px; OVERFLOW: auto; TOP: 15px; LEFT: 50px" id=report1 tabIndex=7 src="" frameBorder=no elementtype="2" HEIGHTOLD="660" WIDTHOLD="630" autoExecute="True" requests_list="0" name="report1"></IFRAME></SPAN>
<SPAN style="Z-INDEX: 3; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 22px; BORDER-TOP: teal 1px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 3px; LEFT: 120px" id=tabitem2 class=tabitemsclass tabIndex=5 elementtype="39" tabbody="tabitembody2" selectedtab="false">Tab #2</SPAN>
<SPAN style="Z-INDEX: 2; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1270px; DISPLAY: none; HEIGHT: 715px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody2 class=tabitemsclass tabIndex=6 elementtype="40"></SPAN></SPAN>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden tabcontrolids="tab1">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag 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">
<rootxmlnode focoption="_FOC_NULL">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0">
<![CDATA[-* File fex1.fex
-SET &ECHO=ALL;
-SET &NAM = '!IBI.AMP.NAM;';
TABLE FILE CAR
PRINT
'CAR.ORIGIN.COUNTRY'
'CAR.COMP.CAR'
'CAR.CARREC.MODEL'
HEADING
"Name : &NAM"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=DATA,
COLUMN=N1,
TARGET='_parent',
FOCEXEC=web2.fex ( \
COUNTRY=N1 \
NAM=&NAM.QUOTEDSTRING \
),
$
ENDSTYLE
END]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
web2.fex -DEFAULT &COUNTRY = 'FRANCE'; -DEFAULT &NAM = 'Default Name 2'; -HTMLFORM web2.htm web2.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 7701, 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" edaconnectionrequired="true" elementtype="21" thumbnailscale="4">
<IFRAME style="Z-INDEX: 1; POSITION: absolute; WIDTH: 560px; HEIGHT: 770px; OVERFLOW: auto; TOP: 20px; LEFT: 30px" id=report1 tabIndex=1 src="" frameBorder=no elementtype="2" HEIGHTOLD="770" WIDTHOLD="560" autoExecute="True" requests_list="0" name="report1"></IFRAME>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag 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">
<rootxmlnode focoption="_FOC_NULL">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="COUNTRY" name="COUNTRY" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="COUNTRY" ibiformat="A10" datafield="COUNTRY" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0">
<![CDATA[-* File fex2.fex
-SET &ECHO=ALL;
-SET &COUNTRY = '!IBI.AMP.COUNTRY;';
-SET &NAM = '!IBI.AMP.NAM;';
TABLE FILE CAR
PRINT
'CAR.ORIGIN.COUNTRY'
'CAR.COMP.CAR'
'CAR.CARREC.MODEL'
WHERE CAR.ORIGIN.COUNTRY = '&COUNTRY'
HEADING
"Name : &NAM"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
Call web1.fex with a URL similar to http://localhost:8080/ibi_apps/WFServlet?IBIF_ex=web1&NAM=JERRY The parameter values are passed to the report piece of the HTML page via the !IBI.AMP.PARM1; syntax. Some may say this is not the best way to do it, but it's the quickest. The NAM variable defined in the HTML pages is not required, but I left them in. 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 | |||
|
| Platinum Member |
Thank you very much for your quick response. I have test this solution and it works fine for me. So thanks again. Mark | |||
|
| Expert |
I'm happy this works for you. 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 | |||
|
| Platinum Member |
Francis, Do you know what the guidelines are when I want to use 'Reference existing procedure'. - read the querystring with javascipt (probaly onLoad webpage) - filter all parameters - but then ? Source fexc.fex is the same as the application used in web1 (fex1.fex) send previously:
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7701, 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>
<STYLE id=ibi_defaultstyleElt type=text/css>.tabitemsclass {
BACKGROUND-COLOR: white
}
</STYLE>
</HEAD>
<BODY style="OVERFLOW: auto" elementtype="21" thumbnailscale="4" edaconnectionrequired="true">
<SPAN style="Z-INDEX: 2; POSITION: absolute; WIDTH: 1180px; HEIGHT: 650px; TOP: 20px; LEFT: 30px" id=tab1 tabIndex=2 elementtype="38" tabitemsdefaultdist="5" tablocation="top" tabitemsdefaultwidth="100" tabitemsdefaultheight="25" tabedgerounded="straight">
<SPAN style="Z-INDEX: 5; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 26px; BORDER-TOP: gold 3px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 0px; LEFT: 15px" id=tabitem1 class=tabitemsclass tabIndex=3 elementtype="39" tabbody="tabitembody1" selectedtab="true">Tab #1</SPAN>
<SPAN style="Z-INDEX: 4; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1180px; DISPLAY: block; HEIGHT: 700px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody1 class=tabitemsclass tabIndex=4 elementtype="40">
<IFRAME style="Z-INDEX: 6; POSITION: absolute; WIDTH: 530px; HEIGHT: 680px; OVERFLOW: auto; TOP: 15px; LEFT: 20px" id=report1 title=fexc.fex tabIndex=7 src="" frameBorder=no elementtype="2" autoExecute="true" requests_list="0" WIDTHOLD="530" HEIGHTOLD="680" name="report1"></IFRAME></SPAN>
<SPAN style="Z-INDEX: 3; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 22px; BORDER-TOP: teal 1px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 3px; LEFT: 120px" id=tabitem2 class=tabitemsclass tabIndex=5 elementtype="39" tabbody="tabitembody2" selectedtab="false">Tab #2</SPAN>
<SPAN style="Z-INDEX: 2; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1180px; DISPLAY: none; HEIGHT: 625px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody2 class=tabitemsclass tabIndex=6 elementtype="40"></SPAN></SPAN>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden tabcontrolids="tab1">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag 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="2">
<rootxmlnode focoption="_FOC_NULL" top="10" left="10" width="150" height="130">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0" top="21" left="1" width="60" height="20" inbinding="0">
<link linktype="default" persistentuniqueid="compUid_1">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="" linktype="none" sourcetype="typeMaster">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targettype="iframe" targetname="report1" sourcetype="typeFex" ibif_ex="fexc.fex" ibiapp_app="webpag" activereport="0"></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
| |||
|
| 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 |