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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
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>,
Posts: 79 | Location: New York | Registered: February 04, 2010
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
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
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
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012
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 email@example.com
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?
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005