Layer Filters

This function allows you to filter the data source elements that are part of the layer. This allows you to create multiple different data layers using the same data source.

SQL conditions are used to filter the data source elements. Only elements that meet the SQL conditions will appear on the layer.

The Filters section, accessible by clicking on , allows you to configure the SQL conditions.

1	Click on + to add a SQL condition.
2	Condition components: Attribute : Select the attribute from the drop-down list. All attributes of the DS are available. Operator : Select the operator from the drop-down list. Operators vary depending on the type of attribute selected (text, integer, double, date). The Filter operators section describes each of them. Value : Enter the attribute value that will be used to filter the elements.
3	You can add a SQL condition, update it by changing its components, or delete it.

Filter operators

equals: This operator filters DS elements to conserve in the layer the elements whose attribute value (regardless of its type) is equal to one of the selected values.

does not equal: This operator filters DS elements to conserve in the layer the elements whose attribute value (regardless of its type) is different from the selected values.

greater than: This operator filters DS elements to conserve in the layer the elements whose attribute value (numeric or date) is greater than the selected value.

greater or equal to: This operator filters DS elements to conserve in the layer the elements whose attribute value (numeric or date) is greater than or equal to the selected value.

less than: This operator filters DS elements to conserve in the layer the elements whose attribute value (numeric or date) is less than the selected value.

less or equal to: This operator filters DS elements to conserve in the layer the elements whose attribute value (numeric or date) is less than or equal to the selected value.

contains: This operator filters DS elements to conserve in the layer the elements whose attribute value (text) contains the selected value.

does not contain: This operator filters DS elements to conserve in the layer the elements whose attribute value (text) does not contain the selected value. This is the same as making a query with the WHERE clause attribute_name NOT LIKE '%value%'.

is null: This operator filters DS elements to conserve in the layer the elements whose attribute value (regardless of its type) is null.

is not null: This operator filters DS elements to conserve in the layer the elements whose attribute value (regardless of its type) is not null.

is between: This operator filters DS elements to conserve in the layer the elements whose attribute value (numeric or date) is within the range defined by the two entered values.

is not between: This operator filters DS elements to conserve in the layer the elements whose attribute value (numeric or date) is not within the range defined by the two entered values.