FlexNet Manager Suite
2020 R2
(On-Premises)
The Filter Builder enables you to create complex filter conditions for grids.
Use the Filter Builder if you want to filter multiple columns and combine these
filters with an option other than a logical-AND. For example, you may want items
that match either the value in the first column or the value in the second column,
but not necessarily both (this is a logical-OR relationship). There are other ways
to make a more advanced filter as well (such as a filter that matches a choice of
values in a single column). You have all these options and more available in the
advanced Filter Builder.
To create an advanced filter:
-
Do one of the following:
- Start a new filter (click Advanced and select
Show Filter).
- Continue to extend an existing simple filter (see Simple Filtering).
When a filter is in operation, a summary statement of the filter appears
at the bottom of the page. The summary translates your filter settings into
terms suitable for the SQL database, with the percent sign acting as a wildcard
that substitutes for any other characters. If you have not yet set any filter
values, this hyperlinked statement says Create
Filter.
-
Click Create Filter.
The Filter Builder dialog appears. The current
filter is described, with each color-coded part of the text also acting as a
control that you can click and change.
-
Click any area of the Filter Builder to see a context menu of available options
for that position.
You can create complex filters using groups to collect some matches
together. One key point to realize is that each logic rule groups together, and
applies to, the items immediately below it (until interrupted by another logic
rule). This means that you read the logic rule rather backwards. Instead of the
spoken language ordering "A or B or C", the layout reads "Or A,B,C".
-
When you are satisfied with your settings in the Filter Builder, click
OK to apply the filter to your grid and see the
results.
FlexNet Manager Suite (On-Premises)
2020 R2