Kentico CMS 7.0 Context Help

New/Edit query

New/Edit query

Previous topic Next topic Mail us feedback on this topic!  

New/Edit query

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

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.