Focal Point
parameter stem

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8971097291

October 24, 2006, 03:36 PM
jbmuir
parameter 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


WF 7.1.6 moving to WF 7.7, Solaris 10, HTML,PDF,XL
October 24, 2006, 04:48 PM
Francis Mariani
Though the functionality you're looking for doesn't seem to exist, this may be of some help: http://documentation.informationbuilders.com/masterinde.../wf713sec/10sec4.htm

QUERY_STRING can be passed in site.wfs

and/or take a look at this: http://documentation.informationbuilders.com/masterinde.../wf713sec/10sec2.htm
you 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 Mariani
A 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
jbmuir
This 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.


WF 7.1.6 moving to WF 7.7, Solaris 10, HTML,PDF,XL