Edit an Existing Query

  1. Choose the Development section in the main menu a locate your document template in the tree.
     

  2. Unfold the document template and click Queries. You will see a list of all queries of the selected template.
     

  3. Click the edit icon. The Query Properties dialog appears.

 

 

 

Query Properties Fields

 

Field Name

Compulsory

Description

Query Name

Yes

Name of the query. It must be unique within all queries of the given template.

Query Type

Yes

Choose if the query is a query text or if it's a name of the stored procedure. If you choose to call a stored procedure, put only the procedure name in the Query Text field.

Requires Transaction

No

Indicates if the query should be run inside a new transaction. You don't need to use this option if you run only one query or if you create the transaction inside your stored procedure.

Query Text

Yes

Enter either full query text or name of the stored procedure.

 

Please find more information about writing custom queries in the Developer's Guide, in Appendix C - Queries.config file structure.