Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Chained controls in Designer
 Login/Join
 
Frans
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: 454 | Location: Europe | Registered: February 05, 2007Report This Post
Waz
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.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
FP Mod Chuck
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: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Michael L Meagher
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: 115 | Location: Seattle, WA | Registered: April 07, 2015Report This Post
Michele Brady
Silver 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: 11 | Registered: August 03, 2018Report This Post
Doug
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.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Frans
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: 454 | Location: Europe | Registered: February 05, 2007Report This Post
Doug
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: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
FP Mod Chuck
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: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
dbeagan
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,


WebFOCUS 8.2.06
 
Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010Report This Post
Waz
Expert
posted Hide Post
Very interesting


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Frans
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: 454 | Location: Europe | Registered: February 05, 2007Report This Post
FP Mod Chuck
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: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders