The Textual View tab of the query editor allows specifying a query using the syntax of the FIND, PICK FROM, EXEC SP or EXEC_SQL actions of the Rule Language. This may be necessary if a query cannot be specified using the Standard View. Some users may also find it quicker to specify queries using this form. Using the EXEC SP or EXEC_SQL actions allows advanced users to execute SQL queries of any complexity from either native or external database.

To specify a query using the Textual View tab enter the name of the query and optionally its description as specified in Adding/Editing Queries and enter the text of the FIND, PICK FROM, EXEC SP or EXEC_SQL actions in the main pane of the tab. Note that you cannot use any other action or Rule Language construct when defining a query.

You can specify how instances of the business object will be displayed in the Operation Mode by clicking on the Display As property and specifying the display options on the Display Query Results dialog – see Adding/Editing Queries.

  • Last modified: 2022/09/13 18:15