Previous Topic
Filter - Web Action Builder Dialog Box
You can use the Filter - Web Action Builder dialog box to build a Filter web action on an object so as to filter the data components in a report when the event bound with the action is triggered at runtime. This topic describes the options in the dialog box.
Designer displays the Filter - Web Action Builder dialog box when you select *Filter and select OK in the Web Action List dialog box, and displays it differently for a page report or web report/library component.
Designer displays the Filter - Web Action Builder dialog box as follows for a page report:
You see the following options in the dialog box:
Get Input From
Select where to get the input.
Apply Action To
This drop-down list contains all the data components in the page report. Select the data component to which to apply the filter action.
Add button
Select to add a new filter condition.
Remove button
Select to delete the specified filter condition.
Move Up button
Select to move the specified filter condition higher in the list.
Move Down button
Select to move the specified filter condition lower in the list.
Filter On
This column shows the fields of the selected data component that you select to perform the filter on.
Operator
This column shows the operators that you select to compose the filter expressions.
- =
Equal to - >=
Greater than or equal to - >
Greater than - <
Less than - <=
Less than or equal to - !=/<>
Not equal to - in
The operator causes an enumerated list of values to appear in the WHERE clause predicate, and is used for evaluating for a true condition. For the "in" operator, you can use multiple values separated by comma (,).
Value
This column shows the values using which you specify to filter the fields.
More
This column shows the relationship that you select for the conditions, which can be And, Or, or End.
OK
Select to apply your settings and close the dialog box.
Cancel
Select to close the dialog box without saving any changes.
Help
Select to view information about the dialog box.
Designer displays the Filter - Web Action Builder dialog box as follows for a web report/library component:
You see the following options in the dialog box:
Apply Action To
This box lists all the data components in the web report or library component. Select each data component that you want to filter and define the filter conditions for it in the right box.
Get Input From
Select where to get the input.
Add button
Select to add a new filter condition.
Remove button
Select to delete the specified filter condition.
Move Up button
Select to move the specified filter condition higher in the list.
Move Down button
Select to move the specified filter condition lower in the list.
Filter On
This column shows the fields of the selected data component that you select to perform the filter on.
Operator
This column shows the operators that you select to compose the filter expressions.
- =
Equal to - >=
Greater than or equal to - >
Greater than - <
Less than - <=
Less than or equal to - !=/<>
Not equal to - in
The operator causes an enumerated list of values to appear in the WHERE clause predicate, and is used for evaluating for a true condition. For the "in" operator, you can use multiple values separated by comma (,).
Value
This column shows the values using which you specify to filter the fields.
More
This column shows the relationship that you select for the conditions, which can be And, Or, or End.
OK
Select to apply your settings and close the dialog box.
Cancel
Select to close the dialog box without saving any changes.
Help
Select to view information about the dialog box.