Create a new Attributive Filter or edit existing ones. An attributive filter can be used if you want to exclude certain objects depending on a where-condition.

 

Create attributive filter - step 1

Create attributive filter - step 1

 

Property

Description

Name

Specify a name for the attributive filter.

Where-Condition

It is recommended to use language independent filter values in the filter where clauses, i.e. either numeric values or strings that contain no special characters. The where clause defines features which are accessible. All features excluded by the filter are restricted.

If you use lookup tables for providing language specific data content in the WebOffice client, then the Filter conditions get specified based on the ID values instead of language specific description values.

 

A common use case for attributive filters is the implementation of group-based editing and user-based editing.

To implement group-based editing define e.g.:

CLIENT_ID = 'Client ID'

where CLIENT_ID is the fieldname of the field for storing client specific value and "Client ID" is the Client ID value defined for the group.

icon_cross-reference

See chapter Groups for details.

 

If you want to create an attributive filter on the Client ID for group-based editing for several groups, you may use the parameter <%client%> which will be replaced with the Client ID of the group this filter is assigned to:

CLIENT_ID = '<%client%>'

icon_comment

If the field CLIENT_ID is defined as integer, the variable <%client%> must be specified without quotation marks

 

User-based editing can be defined in a similar way, e.g.:

CREATE_BY = '<%user%>'

where CREATE_BY is the field name of the field for storing user id of creating user.

 

The keywords ALLOW_NOTHING and ALLOW_ALL can be defined as attributive filters:

ALLOW_NOTHING causes that the group is not allowed to see, edit, delete etc. anything

ALLOW_ALL causes that the group may see, edit, delete etc. everything

Create attributive filter  - step 1 properties

 

Afterwards, you will see the summary of the attributive filter that has been defined. Click Finish to create it. The attributive filter can then be referenced in, e.g. Restrictions for Layers.

 

Create attributive filter - step 2

Create attributive filter - step 2

 

icon_cross-reference

See chapter Groups for details about the Client ID.

See chapter Editing Configuration for UserManagement for details about the creating user id.