I have browsed the forum to see if there are any discussions already on this topic. I did not find any. I am creating 3 dropdown lists CITY, COUNTY & STORELOC. User can either select CITY or COUNTY to get their list of STORELOC. How do I get this working. I have read the manual "Chaining Controls for Dependencies in the HTML Composer", but did not find what I need.
In the parameters tab, I did chain CITY to STORELOC and COUNTY to STORELOC. But, that is asking users to enter both CITY and COUNTY to populate STORELOC, I need an OR.
ThanksThis message has been edited. Last edited by: <Kathryn Henning>,
March 25, 2014, 03:38 PM
As far as I can tell, you cannot do this with HTML Composer. You can, however, have three chained controls: COUNTY > CITY > STORELOC.
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
March 25, 2014, 03:50 PM
March 25, 2014, 04:49 PM
if you're willing to write the code, i can tell you how. If you're wanting the gui to do it for you, i can't help sorry, i don't have 8. Tony A and I did a prez at summit one year, we called it 'the chain gang'...if you can find that prez on the Summit web, its all in there. otherwise, let me know if you're willing to write the code and we'll just do it.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
March 25, 2014, 05:00 PM
You could use the ignore filter _FOC_NULL to allow storeloc to still populate even if the other control is empty. Having said this, I am trying to convert something to WF8 that does this in WF7 and it isn't going well so far ... we will see.
WebFOCUS 7.7.03/8.0.08 Dev Studio 7.7.03/8.0.08 App Studio 8.0.08 Windows 7 ALL Outputs
March 25, 2014, 05:07 PM
Thanks Susannah and J.
I chose a different route. I am using a tabbed container "BY CITY" and "BY COUNTY". My user agreed and liked it.
March 26, 2014, 07:23 AM
No need to write any code. You populate based on a default condition - one of your chains. Then you add another condition that says based on some selected value to populate with alternate data. I did a Summit lab on this using COUNTRY, STATE, and CITY and STATE WAS INLY VALUD IF THE COUNTRY was USA, otherwise it did not display and the chain when from COUNTRY to CITY.
David Glick Director WebFOCUS App Studio and WebFOCUS Developer Studio WebFOCUS Division Information Builders, Inc. Direct (917) 339-5560 Voice Mail (212) 736-6250 x3560 Fax (212) 947-5168 Email firstname.lastname@example.org
March 26, 2014, 10:00 AM
I presume you mean to leave the three controls chained, but set up the state-list-filler logic to return just a "n/a" place-holder value if Country NE 'USA', and the City filler logic to similarly screen differently depending on whether Country EQ or NE USA.
Can you provide a link to the presentation materials?