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.
I want to use an external text file - the entire file - in a where clause in Report Painter. I've tried several things but with no success. I did search the forums and found one that indicated I should use the Import Values option. However, that requires that I select each value. I want to use the entire list not just certain values.
I also tried creating an APP FI but have had no luck with that either.
Any ideas?
Thanks, KittyThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.9 Windows all output (Excel, HTML, PDF)
While that would be nice, we are running this in a different environment. We actually have our clients running the application. We do not allow them to write to the reporting server so unless I can put a APP FILEDEF on my desktop or another server, this method won't work in our situation.
Any other ideas?
Kitty
WebFOCUS 7.6.9 Windows all output (Excel, HTML, PDF)
If you make the file accessible in your application then you can table off the results which would then make the file available to test against. Here is an example using the car file:
TABLE FILE CAR
PRINT CAR
IF COUNTRY EQ 'ENGLAND'
ON TABLE HOLD AS KITTY FORMAT ALPHA
END
-RUN
TABLE FILE CAR
PRINT CAR COUNTRY
IF CAR IS (KITTY)
END
-RUN
WF 8.2.01M 8.2.01M Reporting Server Windows 2012 Srvr R2 PDF,Excel, HTML Graphs - a lot of graphs
Posts: 60 | Location: Atlanta, GA | Registered: October 30, 2003
Hi Kitty, Another approach is to create a Master File that defines the Values File. Then, Join the Base File to the Values File. For example, Join Field in Values to Field in Base as J1.
A second alternate approach is to define the Values File with a Master File, Table that file Holding as a Focus file and Index the Value field. Then Join the Focus Values file to the Base File. For example, Join Field in Base to Field in Values as J1. You will have to test for a non-blank Value in order to insure the test condition is true. Hope this helps. Nick
WebFOCUS 7.7.03 & 8.0.7 Windows HTML, Excel, PDF, etc. Also, using Maintain, etc.
We have a unique situation. We are marketing the product to our clients and not allowing them to create master files.
As far as the size and source, the files can be small or large, depending on the client. These are lists of say order numbers that they want to use throughout their organization to run reports against. They are text files with a single column that are stored on their servers or desktops. They can change these at will. Some may contain 10K+ rows.
Thoughts?
Kitty
WebFOCUS 7.6.9 Windows all output (Excel, HTML, PDF)
The safest way to use these files, is to have them in a location accessible to the WF server. Then as Nick says, create a master so you can join or match to it.
Just be aware, that if these files are updated from time to time, then there is a possibility that an update may happen while processing, and this may cause problems.