Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
2500_config_apps:1100_add_edit_queries:0400_text_view [2022/08/21 22:48] – removed - external edit (Unknown date) 127.0.0.12500_config_apps:1100_add_edit_queries:0400_text_view [2026/08/13 00:55] (current) – ↷ Links adapted because of a move operation localdev
Line 1: Line 1:
 +[<10>]
 +===== Specifying Query Using Query Text View =====
 +
 +The Query Text tab of the query editor allows specifying a query using the syntax of the ''[[ref:a_f:a:find|FIND]]'', ''[[ref:a_f:a:pick_from|PICK FROM]]'', ''[[ref:a_f:a:exec_sp|EXEC SP]]'' or ''[[ref:a_f:a:exec_sql|EXEC_SQL]]'' actions of the Rule Language. This may be necessary if a query cannot be specified using the Query Builder. Some users may also find it quicker to specify queries using this form. Using the ''[[ref:a_f:a:exec_sp|EXEC SP]]'' or ''[[ref: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 Query Text tab enter the name of the query and optionally its description as specified in [[2500_config_apps:1100_add_edit_queries|Adding/Editing Queries]] and enter the text of the ''[[ref:a_f:a:find|FIND]]'', ''[[ref:a_f:a:pick_from|PICK FROM]]'', ''[[ref:a_f:a:exec_sp|EXEC SP]]'' or ''[[ref: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 [[2500_config_apps:1100_add_edit_queries|Adding/Editing Queries]].