October 24, 2006, 03:36 PM
jbmuirparameter stem
Hi All,
Just wondering if recent releases of WebFOCUS have a stem (array) that contains the names of the parameters passed into the report. This stem would be read in the standard way using the dialog manager -REPEAT.
Right now we fake it out with a tomcat filter, that builds a multi-valued parameter that we call "DHPARAMS" but it would be really really handy to have this feature in the language if it's not there already.
-James
October 24, 2006, 04:48 PM
Francis MarianiThough the functionality you're looking for doesn't seem to exist, this may be of some help:
http://documentation.informationbuilders.com/masterinde.../wf713sec/10sec4.htmQUERY_STRING can be passed in site.wfs
and/or take a look at this:
http://documentation.informationbuilders.com/masterinde.../wf713sec/10sec2.htmyou may be able to parse QUESRY_STRING and build what you're looking for.
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
October 24, 2006, 06:04 PM
Francis MarianiA quick snippet of WebFOCUS Dialog Manager code to parse QUERY STRING and create a list of parameter names passed to the program:
-DEFAULT &QUERY_STRING = '';
-TYPE &QUERY_STRING
-SET &COUNTER2 = 0;
-REPEAT END_REPEAT1 FOR &COUNTER1 FROM 1 TO &QUERY_STRING.LENGTH
-SET &POSSIBLE_PARM = GETTOK(&QUERY_STRING, &QUERY_STRING.LENGTH, &COUNTER1, '&', 64, 'A64');
-IF &POSSIBLE_PARM EQ ' ' GOTO SKIP_PARM;
-IF &POSSIBLE_PARM CONTAINS 'IBIF_ex' GOTO SKIP_PARM;
-SET &COUNTER2 = &COUNTER2 + 1;
-SET &PARM_NAME = GETTOK(&POSSIBLE_PARM, &POSSIBLE_PARM.LENGTH, 1, '=', 64, 'A64');
-SET &XPARM.&COUNTER2 = '&' || &PARM_NAME;
-SKIP_PARM
-END_REPEAT1
-SET &XPARM_COUNT = &COUNTER2;
-? &
I can provide an explanation if required.
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
October 26, 2006, 11:06 AM
jbmuirThis makes sense. I just have to pass the QUERY_STRING in the site.wfs and then parse &QUERY_STRING to build my own DHPARAMS stem, without the aid of the tomcat filter.
Thanks, Francis.