DEPRECATION WARNING

This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.

Additional SQL in Data Filter

Data Query adds an “additional SQL” field to the Data Filters. This makes it possible to directly add some SQL which will be added to the WHERE part of the query. This field can be used for SQL-specific conditions which cannot be expressed with standard Data Filter syntax.

The additional SQL field

The “Additional SQL” in the datafilter record

Expressions can be used in the “additional SQL” field too.