Products | Versions |
---|---|
ibi WebFOCUS | All versions |
- Steps to make a Global Filter :
(Will be taking reference of 2 master files , i.e. "employee.mas" and "empdata.mas" . Common field which we will be using is "First Name").
1.) Locate "employee.mas" and "empdata.mas" in ibisamp Application Directory.
2.) Right click on both the master files one by one and select "Open"
(Since as stated before, we will be using "First name" as filter, make sure both the tables have a field which represents the first name)
3.) Right click on "First name" field of both the master files and make make their "TITLE " name same .
(For example empdata has first name's TITLE name as "FIRST_NAME" , then make the "employee.mas" First name's TITLE name as "FIRST_NAME " too).
** You can change the TITLE name of respective field by right clicking on field and selecting properties.
4.) Apply and do not forget to save it.
5.) Now come back to the WF-client homepage .
6.) Click on "Create Visualization" , select "employee.mas" , select grid report, drag and drop a couple of fields including "FIRST_NAME", now add "FIRST_NAME" in the filter panel as well and save it with name "test1.fex"
7.) Follow the 6th step with "empdata.mas" as well and save it with name "test2.fex"
8.) Now again come back to WF-client homepage and select "Assemble Visualization"
9.) Add both "test1.fex" and "test2.fex" in that page and add the filter.
10.) Now selecting any changes from the filter drop down will reflect the changes on both the fex files added to the page.
NOTE** : If both the fex files containing the common field as "First Name" would have different TITLE name, then , In Assemble Visualization while adding both the fex files, they would have separate filter fields ( total 2 filters, one for each) instead of having a common one.