Data Model objects: Filters

Filters are required for limiting access to data for different classes of users.

A filter provided by the Sterling™ Order Management System Software is used to narrow down the selected data.

A filter includes the data that is ‘filtered' (filtered in, not filtered out). For the condition level detail of a filter, see the filter properties in the model. The SQL that is formed in cases where a filter is applied contains the condition of the filter. The filter that is provided:

• Sales Order – limits data to the Document_Type of 0001. Filters are also used in conjunction with Parameter Maps to select the schema in a sharded environment. For more about Parameter Maps, see Data Model objects: Parameter Maps.