Layer and Table Filters

Two types of filters allow displaying only certain features in a layer or certain records in a table, based on attribute values:

• Basic filter: restricts the features or records from the data source to display only those meeting certain criteria in the layer or table. This type of filter allows you to create multiple layers or tables based on the same data source, each presenting a specific subset of features or records.

• Dynamic filters: defined by users to restrict layer features or table records to display only those meeting certain criteria.

The basic filter is not visible to members with the User role (who access only JMap NG applications).

The filter is composed of conditions that are combined. Only features or records that meet all conditions will appear in the layer or table.

The Filters section, accessible by clicking the filter icon , has two tabs. The Basic tab allows you to configure the conditions that make up the filter.

Basic Filter

The filter is composed of cumulative conditions. Only features or records that satisfy all conditions will appear in the layer or table.

1	Click the + icon to add a condition to the filter.
2	Condition components: Attribute Select the attribute from the dropdown list. All data source attributes are available. Operator Select the operator from the dropdown menu. Operators vary depending on the selected attribute type (text, integer, double, date). See the Filter Operators section for descriptions. Value Enter the attribute value to use for filtering features or records. Special characters can be used in this field.
3	The filter is a unit composed of conditions. You can add a condition, update it by modifying its components, or delete it. Then update the filter. The layer/table contains the features/records that satisfy all conditions of the filter. Note:There is an implicit logical AND between conditions. A feature/record must meet all conditions to pass the filter.

Dynamic Filters

A layer or table can have dynamic filters that display data meeting their conditions.

Members of the organization with the User role can see the filters in JMap NG.

Each filter has one or more conditions.

The Filters section, in the Dynamic tab, allows you to configure filters. Each filter has a name that you can edit by clicking .

1	Click the + icon to add a filter.
2	Click the + icon to add a condition to the filter.
3	Condition components: Attribute Select the attribute from the dropdown list. All data source attributes are available. Operator Select the operator from the dropdown menu. Operators vary depending on the selected attribute type (text, integer, double, date). Value Enter the attribute value to use for filtering features. Special characters cannot be used in this field. Note: There is an implicit logical AND between conditions. A feature must meet all conditions to pass the filter.
4	Default visibility parameter of the filter in JMap NG applications. Click or to show or hide the filter in applications. Click to apply the filter or to remove it. The map displays the result.

Filter Operators

The operator filters the features of a data source to keep in the layer only those for which:

Equal to	The attribute value (any type) equals the specified value.
Not equal to	The attribute value (any type) differs from the selected value.
In (IN)	The attribute value (text type) is among the selected values.
Not in (NOT IN)	The attribute value (text type) is not among the selected values.
Greater than	The attribute value (numeric or date type) is greater than the selected value.
Greater than or equal to	The attribute value (numeric or date type) is greater than or equal to the selected value.
Less than	The attribute value (numeric or date type) is less than the selected value.
Less than or equal to	The attribute value (numeric or date type) is less than or equal to the selected value.
Contains	The attribute value (text type) contains the selected value.
Does not contain	The attribute value (text type) does not contain the selected value. Equivalent to a WHERE attribute_name NOT LIKE '%value%' query.
Starts with	The attribute value (text type) starts with the selected value.
Does not start with	The attribute value (text type) does not start with the selected value.
Ends with	The attribute value (text type) ends with the selected value.
Does not end with	The attribute value (text type) does not end with the selected value.
Is null	The attribute value (any type) is null.
Is not null	The attribute value (any type) is not null.
Between	The attribute value (numeric or date type) is within the interval defined by the two entered values.
Not between	The attribute value (numeric or date type) is outside the interval defined by the two entered values.