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     [CLOSED] !IBI.AMP with Multi-Select

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] !IBI.AMP with Multi-Select
 Login/Join
 
Leo Sanchez
Member
posted
I need to pass Multiple Values for each &VARIABLE passed from a Drop Down that is set to MULTIPLE. My goal is to display a Wait Window Message with an Animated Gif. I've done this in the past with several &VARIABLES, however, they were NOT multi-select.

I have my MainCalling.htm which calls and passes the &VARIABLES to a "Driver.fex". The "Driver.fex" then calls a "WaitMessage.htm" which receives the &VARIABLES and has an "auto-run" script which in turn launches the "Report.Fex" which will be displayed in an IFrame. The problem I'm facing is the "WaitMessage.htm" only passes the 1st of the multiple values for each &VARIABLE.

I know in Drill-Downs from one FEX to another I pass the &VARIABLE as such:
RPT_WEEK_YR_PASSED = &RPT_WEEK_YR.QUOTEDSTRING
and it works fine.

Please advise...

This message has been edited. Last edited by: <Kathryn Henning>,


Developer Studio 7.6.11
Reporting Server = Unix 7.6.8
Client = Unix
 
Posts: 29 | Location: Houston | Registered: June 19, 2012Report This Post
Leo Sanchez
Member
posted Hide Post
By they way, I'm using Developer Studio 7.6.4


Developer Studio 7.6.11
Reporting Server = Unix 7.6.8
Client = Unix
 
Posts: 29 | Location: Houston | Registered: June 19, 2012Report This Post
jgelona
Master
posted Hide Post
With a multi-select here's what you get.

Say you have a variable called &COUNTY:

If one county is chosen, the value will be in &COUNTY.

If multiple values are chosen, you get this:
&COUNTY0 has the number of values selected;
&COUNTY has the first value selected;
&COUNTY1 has the first value selected;
&COUNTY2 has the second value selected;
....
&COUNTY.&COUNTY0 has the last value.

I usually code it like this. This builds the piece of the WHERE clause for &COUNTY

-*
-*  If multiple counties are selected then goto CHK_CNTY;
-*
-IF &COUNTY0.EXISTS GT 0 THEN GOTO CHK_CNTY;
-*
-*  One county is selected
-*
-SET &CNTYLINE='AND COUNTY EQ ' | &COUNTY;
-GOTO FINCNTY
-*
-CHK_CNTY
-SET &CNTYLINE='AND COUNTY IN (';
-SET &PASS=1;
-*
-*  Append counties selected
-*
-REPEAT LOOP1 &WRSRCTYP0 TIMES
-SET &CNTYLINE=IF &PASS EQ 1
-  THEN &CNTYLINE || &COUNTY.&PASS
-  ELSE &CNTYLINE || (',' | &COUNTY.&PASS);
-SET &PASS=&PASS+1;
-LOOP1
-*
-SET &CNTYLINE=&CNTYLINE || ')';
-*
-FINCNTY
....

WHERE .....
&CNTYLINE.EVAL


In this case, the &COUNTY is returning numbers. It is a little more complicated for alpha fields because you have to mess with the quotes or use the .QUOTEDSTRING. For example, if I was passing county name instead of the county FIPS code, I might use &CNTYNM.&PASS.QUOTEDSTRING.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report 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     [CLOSED] !IBI.AMP with Multi-Select

Copyright © 1996-2020 Information Builders