Matching Filter Values

👤 This documentation is intended for SQL Users.

Filters already allow matching exact values. They can also be set up to match ranges and compare strings.

Setting up The Filter

To create a filter for changing a threshold, enter the values for the desired threshold levels. We'll call it "UserMinimumLevel."

Matching an Expression

Next, select "More Options" and in the text box under "Match an expression for this filter" specify how to match a column value to the selected filter value:

[column] >= [value]

Now the filter is all set, and ready to be integrated into queries.

Integration

Filters with a specific expression to match should still be referenced in the same trusty syntax:

[level=UserMinimumLevel]

When '100' is selected as the filter value, this is what it looks like in action:

Now, there is a quick and easy way to filter by ranges or strings!