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     [SOLVED] Populating A Drop Down Box Dynamically Using WebFOCUS 7.1.1

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Populating A Drop Down Box Dynamically Using WebFOCUS 7.1.1
 Login/Join
 
Ron Woods
Member
posted
I have a page with a drop down list that is linked to a data source (another fex which creates a focus hold file of data). But I want to be able have the data in this list to be dynamic each time the page is loaded (reloaded).

The Parameters tool in Developer Studio indicates the control values can come from either a Data source or Procedure. I am using a Data source, but the values are not dynamic. I've have tried a procedure but the list does not contain any entries.

How do you code a procedure to be used in a drop down list?

WebFOCUS/Developer Studio 7.1.1

This message has been edited. Last edited by: Kerry,


Ron Woods
San Antonio Express-News
Release: WebFOCUS 7.1.1
OS/Platform: Windows XP SP2 x86 32bit
O/P Formats: Primarily pdf and xls
 
Posts: 22 | Location: San Antonio, Tx | Registered: October 20, 2005Report This Post
GinnyJakes
Expert
posted Hide Post
Search for "Filtering Dynamic Parameter Values" in the wf713appsgt.pdf manual, Developing Reporting Applications With
Graphical Tools, or the one closest to your release.

You will need to create a program that generates output in XML format. The reference above will tell you how to do that.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Ron Woods
Member
posted Hide Post
quote:
Filtering Dynamic Parameter Values

Sorry, filtering dynamic parameter values is not what I am attempting to do.

On my web page I have a drop down list that is attached to a data source. The problem is that the fex for this data source needs to be updated to refresh the data.

What I am looking for is how to code the drop down list or it's associated procedure so that the list is refreshed (the data source is refreshed) each time the web page is reloaded.

I have two dynamic choices for a drop down list. Data source and procedure. I'm hoping that the procedure is the option that will actually run and populate my drop down list with the latest values from the database. I just do not know how to make the connection between the procedure and web page element.


Ron Woods
San Antonio Express-News
Release: WebFOCUS 7.1.1
OS/Platform: Windows XP SP2 x86 32bit
O/P Formats: Primarily pdf and xls
 
Posts: 22 | Location: San Antonio, Tx | Registered: October 20, 2005Report This Post
GinnyJakes
Expert
posted Hide Post
Ron,

If you would take the time to check out my reference, I am pretty sure that this is what you want. You write a procedure that reads your data source and produces an XML file. You reference that procedure instead of the master when setting up the properties for the dropdown control.

Please don't discount what I posted out of hand without checkit it out first. It only takes a moment.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Ron,

We do that very easily with our WrapApp product.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
TexasStingray
Master
posted Hide Post
Ron, When you call a procedure to a dynamic drill down you just have the output returned in XML "ON TABLE PCHOLD FORMAT XML" it must return 2 columns one for the display value and one for the actual value to pass to WebFOCUS.

TABLE FILE CAR
PRINT COUNTRY
BY COUNTRY
ON TABLE PCHOLD FORMAT XML
END


Hope this helps




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
RSquared
Guru
posted Hide Post
Ron,

You can also add a line similar to the one below in your fex.
'WHERE UTILITYSTATUS CONTAINS &UTILITYSTATUS.(OR(FIND UTILITYSTATUS IN ce_R0utilitystatus)).UTILITYSTATUS.''
Use your field name and table name in this statement. This will cause the system to fetch the list of values from the actual data.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
Ron Woods
Member
posted Hide Post
Thanks everyone for their help. I was finally able to extract the key element of creating XML output for the drop down lists.


Ron Woods
San Antonio Express-News
Release: WebFOCUS 7.1.1
OS/Platform: Windows XP SP2 x86 32bit
O/P Formats: Primarily pdf and xls
 
Posts: 22 | Location: San Antonio, Tx | Registered: October 20, 2005Report This Post
Noveta
Member
posted Hide Post
quote:
On my web page I have a drop down list that is attached to a data source. The problem is that the fex for this data source needs to be updated to refresh the data.

I am very new to WebFocus, I have created a report and the drop down list is populated from the datasource, but it is very slow. Creating the drop box using this method , is the performance better?


7.6.2
 
Posts: 20 | Location: 7.6.2 | Registered: November 04, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
Performance can be better using a procedure rather than going directly against the data source as you have more control over the SQL that is generated. You can put in WHERE clauses for example.

Another thing that can hurt performance is to use the data source option against a very large table and only expecting a few distinct values. If this is the case, you could use a Report Caster job to build a smaller table that you could use to get the values.

Please let us know how many rows there are in the source tables and how many values you are expecting to get out of it.

Also, I noticed that you did update your signature with your release. However, it would be helpful if we knew what platform you are running on and what kind of data sources you are using.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Noveta
Member
posted Hide Post
The drop box list all the sections in a particular term. Eventually I want to create a chain and list only the courses in a particular term, but right now there approx 1500 rows in the table.
Do you have a white paper on how to generate a fex and use it for the drop down in another report?

I am using ORacle /UNIX. The data source is a view on ORACLE. I did have one view, but I broke view into two views, because it was taking so long to populate the drop down boxes.

I hope I gave you enough information.


7.6.2
 
Posts: 20 | Location: 7.6.2 | Registered: November 04, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
quote:
Search for "Filtering Dynamic Parameter Values" in the wf713appsgt.pdf manual, Developing Reporting Applications With
Graphical Tools, or the one closest to your release.


Please check out this manual reference. It is on page 260 of the 7.6 version of the manual. It even tells you how to do chaining.

1500 rows doesn't seem like a lot.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 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     [SOLVED] Populating A Drop Down Box Dynamically Using WebFOCUS 7.1.1

Copyright © 1996-2020 Information Builders