Specifying Query Using Textual View AwareIM Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

[<10>]
===== Specifying Query Using Textual View =====

The Textual View tab of the query editor allows specifying a query using the syntax of the ''[[a_f:a:find|FIND]]'', ''[[a_f:a:pick_from|PICK FROM]]'', ''[[a_f:a:exec_sp|EXEC SP]]'' or ''[[a_f:a:exec_sql|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 ''[[a_f:a:exec_sp|EXEC SP]]'' or ''[[a_f:a:exec_sql|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 [[docs:2500_config_apps:1100_add_edit_queries|Adding/Editing Queries]] and enter the text of the ''[[a_f:a:find|FIND]]'', ''[[a_f:a:pick_from|PICK FROM]]'', ''[[a_f:a:exec_sp|EXEC SP]]'' or ''[[a_f:a:exec_sql|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 [[docs:2500_config_apps:1100_add_edit_queries|Adding/Editing Queries]].