Differences

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

--- 2500_config_apps:1100_add_edit_queries:0400_text_view [2022/08/22 01:46] – administrator
+++ 2500_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 Textual View =====
+===== Specifying Query Using Query Text View =====
-The Textual View tab of the query editor allows specifying a query using the syntax of the [[documentation:2500_config_apps:1100_add_edit_queries:helprulelanguagefindaction|FIND]] ,  [[documentation:2500_config_apps:1100_add_edit_queries:helprulelanguageexecspaction|EXEC_SP]] or [[documentation:2500_config_apps:1100_add_edit_queries:helprulelanguageexecsql|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 [[documentation:2500_config_apps:1100_add_edit_queries:helprulelanguageexecsql|EXEC_SQL]] actions allows advanced users to execute SQL queries of any complexity from either native or external database.
+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 Textual View tab enter the name of the query and optionally its description as specified in [[documentation:2500_config_apps:1100_add_edit_queries:helpqueries|Adding/Editing Queries]] and enter the text of the FIND, [[documentation:2500_config_apps:1100_add_edit_queries:helprulelanguageexecsql|EXEC_SQL]] or [[documentation:2500_config_apps:1100_add_edit_queries:helprulelanguageexecspaction|EXEC_SP]] actions in the main pane of the tab. Note that you cannot use any other action or Rule Language construct when defining a query.
+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 [[documentation:2500_config_apps:1100_add_edit_queries:helpqueries|Adding/Editing Queries]].
+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]].