The SQL repository lets you filter database read operations. For example, you might want a database lookup always to return only items whose activeFlag property is true. You can filter the repository by defining a repository query that specifies the filter criteria you want and associating it with the appropriate item descriptor. The filter is automatically applied to all of the following operations:

You can define a repository filter in three ways:

In most cases, the first method, using the <rql-filter> tag, is easiest and preferable.