Focal Point
[SOLVED] Chaining 2 links to one control using OR

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7067018966

March 25, 2014, 03:00 PM
nsk110483
[SOLVED] Chaining 2 links to one control using OR
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.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,


In Focus since 2008
WebFOCUS 8.2.0.1
Windows 7 - IE,Chrome,Firefox
Excel, PDF, HTML, AHTML, XML
JavaScript, jQuery, D3.js, Highcharts
March 25, 2014, 03:38 PM
Francis Mariani
As far as I can tell, you cannot do this with HTML Composer. You can, however, have three chained controls: COUNTY > CITY > STORELOC.


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
March 25, 2014, 03:50 PM
nsk110483
Thanks for reply Francis,
I have given those names as an example. I definitely need to use OR condition to populate the third dropdown. Maybe I could use javascript to handle the chaining for me.


In Focus since 2008
WebFOCUS 8.2.0.1
Windows 7 - IE,Chrome,Firefox
Excel, PDF, HTML, AHTML, XML
JavaScript, jQuery, D3.js, Highcharts
March 25, 2014, 04:49 PM
susannah
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
J
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
nsk110483
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.


In Focus since 2008
WebFOCUS 8.2.0.1
Windows 7 - IE,Chrome,Firefox
Excel, PDF, HTML, AHTML, XML
JavaScript, jQuery, D3.js, Highcharts
March 26, 2014, 07:23 AM
David Glick
Nsk,

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 david_glick@ibi.com
March 26, 2014, 10:00 AM
j.gross
David --


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?

-Jack