Custom filters can be created that interact directly with the database, other sources. The filters can apply custom application logic.
Add one or more files in the configuration/sql folder with suffix .sql.xml or .sql.
Register a SqlStatementProvider that returns SqlStatement items.
The sytem supplies abstract classes for registering additional file and resource based .sql.xml files.
select id from customers where lastName like '%manchu%';
The filename is used as the query name, and the contents are used a the SQL query.
The sql.xml file format allows specifying multiple filters in one file. A caption and description can be associated with each filter. See sql format for query rules
<sql-items> <sql-item> <caption>The Manchus</caption> <description>All customers with Manchu in their last name.</description> <sql>select id from customers where lastName like '%manchu%';</sql> </sql-item> </sql-items>
The recipients activity has a QuickSQL menu item. Selecting it will display a list of registered queries.
The QuickSQL is not a savable filter. Reapplying filters will remove any items added by QuickSQL.