Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Chaining 2 links to one control using OR
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Chaining 2 links to one control using OR
 Login/Join
 
Gold member
posted
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
 
Posts: 80 | Location: New York | Registered: February 04, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 80 | Location: New York | Registered: February 04, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
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, 2003Reply With QuoteReport This Post
Guru
posted Hide Post
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, 2012Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 80 | Location: New York | Registered: February 04, 2010Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 312 | Registered: April 13, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Chaining 2 links to one control using OR

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.