Database Reference
In-Depth Information
The Filter action offers a full set of filter operations for selection, as shown in Fig-
ure 7-27 .
Figure 7-27. Applying a filter to an interactive report
The Filter action supports both column filters and row filters. Column filters are ap-
plied to a single column. The column filter options change interactively, depending on
the type of the filter column and the selected operator. For example, if you select a date
column, such as Created On, and then select the Between operation, the Expression
element now contains two fields, for the From and To of the between clause. In this
case, the fields each have a date picker for ease in entering the Date From and To val-
ues. The end user can also construct a custom filter using the declarative Filter.
Row filters allow the user to build filter conditions that are based on multiple
columns in the same row. A simple row filter for your Analysis report might be a filter
for all tickets that were closed on the same day they were opened. The Filter expression
may be built declaratively using selections in the Columns and Functions/Operators re-
gions, shown in Figure 7-28 , or entered manually. Within the Filter Expression, selec-
ted columns are represented by their letter alias.
 
 
 
Search WWH ::




Custom Search