How to add a Global Filter to a Page ?

How to add a Global Filter to a Page ?

book

Article ID: KB0071232

calendar_today

Updated On:

Products Versions
ibi WebFOCUS All versions

Description

- There can be a situation where some of the fex files have the same filter , but for each fex ,a separate filter is used. At such scenarios, if the field used in filter is same ,we can have the global filter , i.e. making changes in that one filter option, will reflect all the fex files having the same filter field.

Issue/Introduction

This article will cover instructions to add a global filter to page i.e. setting up only one filter option which will reflect all the fex files present in that page.

Environment

Windows and Linux.

Resolution

- 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.