Filter Definition

Property

Description

Condition

Filter condition (WHERE clause):

•Fields must be configured case sensitive,

•If you use string conditions then enclose string values in single quote, e.g. ‘my condition’,

•Each of the Layers configured in the Filter definition must contain this field.

E.g.:

Simple standard SQL operators may be used:

•STREET = 'My condition'

•STREET LIKE 'My condition%'

•STREET IN ('My condition', 'my 2nd condition')

•NUMBER = 1

•NUMBER > 1 AND < 10

•NUMBER IN (1,2,3,4,5,6,7,8)

•STREET = 'My condition' OR STREET = 'My 2nd condition'

•IS NULL / IS NOT NULL

Note: It is possible to specify a parameter instead of a field value. Valid parameters are <param1>, <param2>, <param3>, <param4>. For details on how to specify these parameters see chapter Filter parameter.

Filter name

Filter name

Visible?

Used to define the visibility of the parameterized (only) filter.

-'show': The filter will be shown (visible) in the GUI.

-'hide': The filter will be hidden, and the user could manipulate the filter using the scriptAPI only.

Filter identifier

Filter identifier used for external calls or in the scriptAPI.