Create a New Query
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 New Item... button in the toolbar. The Query Properties dialog appears. Enter some values and click OK to save new query.
Edit an Existing Query
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.
Delete a Query
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 delete icon and confirm deletion.
Query Properties
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.