Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     handling form vars in fex

Read-Only Read-Only Topic
Go
Search
Notify
Tools
handling form vars in fex
 Login/Join
 
MacLonghorn
Platinum Member
posted
I have a FEX that dynamically generates a form with unknown number of form elements. These form elements are used for inputting data to a database. However, all the elements are named such that they are passed with the form submission to another page. For example, the elements are named "MeasureDate1", "MeasureDate2", etc. Since I don't know all the vars I'll be capturing, how can I pass these to another FEX and have that other FEX read them? In server side scripting, you'd do something like:

array a = url.request();

then parse "a" for all the name/value pairs. is there a similar capability in WF?


Thanks.

Mark
WF 7.6 Windows
 
Posts: 150 | Registered: July 26, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
Add the following line to the site.wfs profile file:

<SET> QUERY_STRING = &QUERY_STRING (pass)


You can do this via the Admin Console > Configuration > Custom Settings.

Add the above mentioned line at the end of whatever is already there.

Read this thread for more information:

Pass the URL of the current WF request in a DM variable


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
MacLonghorn
Platinum Member
posted Hide Post
Excellent Francis. That works well. Is there an easy way to parse the name/value pairs? I have the FEX and other IBI vars in the query string. (my form is sending the request to /ibi_apps/Controller via the POST method)


Thanks.

Mark
WF 7.6 Windows
 
Posts: 150 | Registered: July 26, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
This should work: Create a hidden form text object called IBIF_parms and give it the value of &QUERY_STRING. 
<input type="text" name="IBIF_parms" value="!IBI.AMP.QUERY_STRING;">


Or, if you use JavaScript to create the submit URL instead of a form, you wouldn't have to parse the name/value pairs. Build the URL and append &QUERY_STRING.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
Sorry, it looks like you would have to strip the '&' from the &QUERY_STRING string of name/value pairs for IBIF_parms to work.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
MacLonghorn
Platinum Member
posted Hide Post
No, let me clarify...in the TARGET fex, I am reading the &QUERY_STRING as a whole, just fine. Now that I have that, is there an easy way to parse the incoming &QUERY_STRING? I'm aware of GETTOK, but that seems to require you to know how many parms you've got.


Thanks.

Mark
WF 7.6 Windows
 
Posts: 150 | Registered: July 26, 2007Report This Post
MacLonghorn
Platinum Member
posted Hide Post
I think I found one of your posts that will probably do it for me:
https://forums.informationbuilders.com/eve/forums/a/tpc/...201021391#9201021391


Thanks.

Mark
WF 7.6 Windows
 
Posts: 150 | Registered: July 26, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
Glad you found that post, Foghorn.

Cheers.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gizmo
Gold member
posted Hide Post
As long as you know what the base name of the variable is, you could build an additional variable to pass the total count. This would work much in the same way as a combo box would work with webfocus.

MeasureDate0 would contain the number of instances that would exist, then you could create a loop.

-REPEAT MYLOOP FOR &COUNTER FROM 1 TO &MeasureDate0;
...code that you want to use getting the variable as &MeasureDate.&COUNTER
-MYLOOP


Windows: WF 7.6.2: SQL Server 2008 R2
 
Posts: 86 | Location: Chicago | Registered: August 03, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     handling form vars in fex

Copyright © 1996-2020 Information Builders