|
|
New/Edit query |
|
|
|
|
|
New/Edit query |
|
|
|
|
|
|
New/Edit query |
|
|
|
|
|
New/Edit query |
|
|
|
|
|
|
||
On this page, you are either editing a new custom table query or editing an existing one. The following parameters can be entered:
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. |
There are several examples of helper macros for queries accessible by clicking the Helper macros for queries link at the bottom of the page.
Detailed information about the Custom tables module can be found in Developer's Guide -> Modules -> Custom tables.