Use Attribute Filters |
  
|
Use Attribute Filters |
|
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 on basis of ID values and not on 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 (see chapter Create a new User group 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%>'
To implement user-based editing define e.g.:
CREATE_BY = '<%user%>'
where CREATE_BY is the fieldname of the field for storing user id of creating user.