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 Designer Forum on Focal Point     [CLOSED]Chained controls in Designer
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]Chained controls in Designer
 Login/Join
 
Guru
posted
Does anyone know / Tested if it's possible to chain controls in a Designer page?

This message has been edited. Last edited by: Frans,


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 388 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Ditto,

We will be getting into this very soon, seen demos as well.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
My experience has been if the master file has a hierarchy defined and those fields are used in where clauses they are automatically chained but the designer tool itself does not provide the ability to chain...


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1560 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
And therein lies the rub for many of us. The new tools are really great, but they require a redesign of our metadata layers that can be overwhelming for legacy systems.

If you are starting with a clean slate it is much simpler than with MFDs designed only a few years ago. Joins in your focexecs are considered poor form, although for most of the last forty years that's how you did it.

I wish the metadata layer design transition had been stressed at Summit years ago when IBI started heading that way.

Rant over Roll Eyes


WebFOCUS 8.2.03 - Production
WebFOCUS 8.2.04 - Sand Box
Windows 2012 R2 Server
HTML, PDF, Excel
In FOCUS since 1980
 
Posts: 116 | Location: Seattle, WA | Registered: April 07, 2015Reply With QuoteReport This Post
Member
posted Hide Post
The following thread is related to this question. Please let me know if it doesn't answer your question.

http://forums.informationbuild...7041196/m/6297071196


Director, Technical Content Support Services
 
Posts: 26 | Registered: August 03, 2018Reply With QuoteReport This Post
Expert
posted Hide Post
So. is this saying that Chaining the controls in WebFOCUS Designer can only be done if the metadata has Hierarchy setup? I sure hope that is NOT what this is saying.

What about chaining data from 'flat' tables created from DataMigrator?
What about chaining done in HTML Composer Controls... Chaining one dropdown list to another where they are populated from fexes... The way it's been done for years?

I'll be at every Designer session that Summit has to offer, maybe even attending the same one more than once... See you there...


   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Most recent: 8204 Gen 48 in Test and Production.
   Currently Available. Please contact me.
 
Posts: 2976 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Thanks for all the input. This means also that the chaining will only work if you use the same master for all the containers on a page?

Would be nice to have an option to have a separate masterfile for the filters.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 388 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
So, What about chaining done in HTML Composer Controls... Chaining one dropdown list to another where they are populated from fexes... The way it's been done for years?
 
Posts: 2976 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Summit will definately be the best place to get answers about how designer currently behaves and how it will be enhanced. You can create the chaining with composer and then use that html form in the designer for now.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1560 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
You can accomplish the chaining in Designer entirely within the fex:

-DEFAULT &aregion = '_FOC_NULL';
-DEFAULT &ast     = '_FOC_NULL';
-DEFAULT &acity   = '_FOC_NULL';
 TABLE FILE ibisamp/ggsales
 SUM UNITS
  BY REGION
  BY ST
  BY CITY
  BY DATE
  ACROSS PCD
  WHERE ( REGION EQ &aregion.(FIND REGION IN GGSALES|FORMAT=A11).Region.QUOTEDSTRING )
    AND ( ST EQ &ast.(FIND ST IN GGSALES|FORMAT=A02,WITHIN=aregion).State code.QUOTEDSTRING )
    AND ( CITY EQ &acity.(FIND CITY IN GGSALES|FORMAT=A20,WITHIN=ast).City.QUOTEDSTRING );
 ON TABLE SET STYLE *
 INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty, $
 ENDSTYLE
 END

This message has been edited. Last edited by: dbeagan,


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 136 | Registered: October 19, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Very interesting


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
Thanks dbeagan, that sheds some light on the possibilities we have.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 388 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Good One That is a great technique! I love it when I learn something new!


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1560 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS Designer Forum on Focal Point     [CLOSED]Chained controls in Designer

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