Choose the Development
section in the main menu a locate your document template in the tree.
Unfold the document template and click Queries.
You will see a list of all queries of the selected template.
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.