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] dynamic parameter selection

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] dynamic parameter selection
 Login/Join
 
cfish
Member
posted
I can get this to work (getting a list of product status for the selection)
WHERE IM_STATUS EQ &STATUS.(OR(FIND IM_STATUS IN IM_INVENTORY)).Select a Status.;

instead of that...can i get the list to pull from a small flat file instead of the table? i set up a small flat file and created the mas (ran a test report to make sure it worked) but it won't populate the list. or is there a way to have a set list to select from instead of having a find?

thanks

This message has been edited. Last edited by: Kerry,
 
Posts: 20 | Location: Nashville, TN | Registered: September 19, 2005Report This Post
Waz
Expert
posted Hide Post
You can, as long as the flat file is FILEDEFed in the profile.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
cfish
Member
posted Hide Post
i included

SET PCOMMA=ON
APP FI STATUS DISK BASEAPP/status.txt
-RUN
SET ALL=ON

but will check out the FILEDEF
 
Posts: 20 | Location: Nashville, TN | Registered: September 19, 2005Report This Post
Waz
Expert
posted Hide Post
APP FI is the same as FILEDEF.

FILEDEF has OS pathing, where APP FI uses appdirectories.

I assume you also have a MASTER file for the flat file ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
cfish
Member
posted Hide Post
yes, i have a master file. i can run a separate report from it..but when i try to use it to populate the list, the list is empty. i'll try again today.

thanks
 
Posts: 20 | Location: Nashville, TN | Registered: September 19, 2005Report This Post
cfish
Member
posted Hide Post
an update....i haven't had a chance to finish this..so consider this closed and will open a new discussion soon if needed

thanks for your help.
 
Posts: 20 | Location: Nashville, TN | Registered: September 19, 2005Report 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] dynamic parameter selection

Copyright © 1996-2020 Information Builders