Advanced Filtering

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:

1. 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.
2. 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.
3. 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".
4. When you are satisfied with your settings in the Filter Builder, click OK to apply the filter to your grid and see the results.