Using the Advanced Filter Builder

The Advanced Feature Builder allows users to make more complex filter conditions where different fields can be grouped together. The and operator is supported as well as filtering timestamp fields using the date field only.

In the Upload panel, click Open Filter Builder. The Advanced Filter Builder window opens.
From the drop-down menu, select a field. The Operators drop-down menu populates with valid operators based on the field choice.
Enter the filter criteria.
Click Add. Another filter line appears below the first line.
From the drop-down menu in the second filter line, select a field. Logical operator options are available on the left side of the second filter line.
To add more filters, repeat steps 2-5.
To group these filters together:
1. Using the check boxes on the right of each filter line, select the filters you want to include in the group.
2. Click the Group button.
  The selected filters are grouped together.
3. Repeat steps a and b to group more filters together.
To use disable group filtering on an existing filter:
1. Click Ungroup to separate all selected filters.
2. Create a valid filter.
To edit an existing filter:
1. In the Upload panel, click Open Filter Builder. The Advanced Filter Builder window opens.
2. Edit the filter as desired.
To view the filter, click Preview.
To insert the filtered field or fields on the filter list box, click Insert. This will overwrite any existing filter.
To apply the filter to query results, click Refresh.

Filtering a Timestamp field using the date field

This feature is available starting with ISD 10.0.42.

This example specifies the date only and is automatically translated to the proper range.

The condition <TimeStampField> Equal to 2/7/2020 is automatically translated to the range <TimeStampField> >=2020020616000000 and <= 2020020715595999. These values are the timestamp values for the start and end of the date.

This filter returns all entries with timestamp values within the date 2/7/2020.