|
|
New/Edit query |
|
|
|
|
|
New/Edit query |
|
|
|
|
|
|
New/Edit query |
|
|
|
|
|
New/Edit query |
|
|
|
|
|
|
||
On this page, you are either editing a new document type 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 document types and transformations can be found in Developer's Guide -> Development -> Document types.