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
August 03, 2010, 09:31 AM
Francis Mariani
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
August 03, 2010, 09:34 AM
Francis Mariani
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
August 03, 2010, 12:35 PM
Arif
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
August 03, 2010, 12:36 PM
Arif
I meant to say you could user either of Highest or lowest BY SORTING
WebFOCUS 7.6.10 Windows HTML
August 03, 2010, 06:02 PM
trebor47
Thanks to all for the rapid response. I appreciate them.
