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] HTML Layour Painter

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] HTML Layour Painter
 Login/Join
 
trebor47
Member
posted
For a rop down list we are referencing a mas file which conatins the last 10 calendar days, not counting today (08/02/2010 thru 07/24/2010. In this file the dates are list as yesterday's date first ), the remainder in descending order. The current list is populated 07/24/2010 thru 08/02/2010. Is there a way to force the HTML page not to re-sort file data?

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


WF 7.6.11 on AIX
 
Posts: 2 | Location: North Central Texas | Registered: August 22, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
Instead of selecting "Data source" for the source of the values of the drop-down list, select "Procedure", having previously created a FEX that returns the values in the order you require.

E.G.:

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


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
Documentation:

Developing Reporting Applications With Graphical Tools > Designing a User Interface for a Web Application With the HTML Composer > Using Form Controls to Supply Parameter Values > Creating a Dynamic List of Parameters > Customizing Dynamic Parameters:

quote:
The procedure must meet the following criteria:

The procedure must return a name and value pair for each parameter value that will populate the list. The first value is the submission value which is passed to the form control when you click the Submit button. The second value is the display value which is what you will see in the control. These two values can be the same or different.
The procedure must return the two data values on a single data line in XML format (PCHOLD FORMAT XML).


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
Arif
Guru
posted Hide Post
quote:
TABLE FILE CAR
PRINT
COUNTRY
BY HIGHEST COUNTRY
ON TABLE PCHOLD FORMAT XML
END 

  TABLE FILE CAR
PRINT
COUNTRY
BY HIGHEST/LOWEST DATEFIELD NOPRINT
ON TABLE PCHOLD FORMAT XML
END


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Arif
Guru
posted Hide Post
I meant to say you could user either of Highest or lowest BY SORTING


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
trebor47
Member
posted Hide Post
Thanks to all for the rapid response. I appreciate them.


WF 7.6.11 on AIX
 
Posts: 2 | Location: North Central Texas | Registered: August 22, 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] HTML Layour Painter

Copyright © 1996-2020 Information Builders