Query name |
Name of the query which will be displayed to users. |
Query type |
Type of the SQL query. |
Requires transaction |
Indicates if the query requires transactional processing. |
Avoid automatic updates |
Indicates if the automatic updates should be applied, e.g. when creating a new field for the current document type. |
Query text |
Code of the SQL query. |
At the bottom of the page are few examples of helper macros for queries.