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
docs:2500_config_apps:1100_add_edit_queries [2022/08/31 00:59] – ↷ Links adapted because of a move operation administratordocs:2500_config_apps:1100_add_edit_queries [2022/09/13 18:15] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ====== Adding/Editing Queries ====== ====== Adding/Editing Queries ======
  
-The following section describes how to work with the editor of queries when adding a new query or editing an existing one. Queries are used in the Operation Mode to search the system’s data for instances of some business object or business object group that match some condition(s). Queries can be run by the user or used by ''[[actions_functionslists:3100_actions:find|FIND]]'', ''[[actions_functionslists:3100_actions:pick_from|PICK FROM]]'', ''[[actions_functionslists:3100_actions:exec_sp|EXEC SP]]'', ''[[actions_functionslists:3100_actions:0490_exec_sql|EXEC_SQL]]'' or ''[[actions_functionslists:3100_actions:0490_exec_sql|DISPLAY]]'' actions of the Rule Language. See also [[docs:2000_concepts:0600_data_retrieval:0100_config_queries|Configuring Queries]].+The following section describes how to work with the editor of queries when adding a new query or editing an existing one. Queries are used in the Operation Mode to search the system’s data for instances of some business object or business object group that match some condition(s). Queries can be run by the user or used by ''[[a_f:a:find|FIND]]'', ''[[a_f:a:pick_from|PICK FROM]]'', ''[[a_f:a:exec_sp|EXEC SP]]'', ''[[a_f:a:exec_sql|EXEC_SQL]]'' or ''[[a_f:a:exec_sql|DISPLAY]]'' actions of the Rule Language. See also [[docs:2000_concepts:0600_data_retrieval:0100_config_queries|Configuring Queries]].
  
 The editor of queries can be started as described in the [[docs:2500_config_apps:0300_work_config_elements|Working with Configuration Elements]] section. It contains 2 tabs – the Standard View and the Textual View. The tabs represent different ways of specifying a query.  The editor of queries can be started as described in the [[docs:2500_config_apps:0300_work_config_elements|Working with Configuration Elements]] section. It contains 2 tabs – the Standard View and the Textual View. The tabs represent different ways of specifying a query. 
  
   - The Standard View tab provides a convenient user interface for specifying query conditions. However, not all queries can be specified using the Standard View. See also [[docs:2500_config_apps:1100_add_edit_queries:0300_standard_view|Specifying Query Using Standard View]].   - The Standard View tab provides a convenient user interface for specifying query conditions. However, not all queries can be specified using the Standard View. See also [[docs:2500_config_apps:1100_add_edit_queries:0300_standard_view|Specifying Query Using Standard View]].
-  - Where it is not possible to specify a query using the Standard View it is possible to specify a query using the Textual View. The Textual View tab allows entering the ''[[actions_functionslists:3100_actions:find|FIND]]'',  ''[[actions_functionslists:3100_actions:exec_sp|EXEC SP]]'' or ''[[actions_functionslists:3100_actions:0490_exec_sql|EXEC_SQL]]'' actions of the Rule Language. See [[docs:2500_config_apps:1100_add_edit_queries:0400_text_view|Specifying Query Using Textual View]].+  - Where it is not possible to specify a query using the Standard View it is possible to specify a query using the Textual View. The Textual View tab allows entering the ''[[a_f:a:find|FIND]]'',  ''[[a_f:a:exec_sp|EXEC SP]]'' or ''[[a_f:a:exec_sql|EXEC_SQL]]'' actions of the Rule Language. See [[docs:2500_config_apps:1100_add_edit_queries:0400_text_view|Specifying Query Using Textual View]].
 The preview of how the query will look like in the browser is displayed underneath the query editor. Any changes you make to the query are immediately reflected in the preview. You can turn embedded preview on or off by clicking on the {{docs:icons:icon_form_browser_embedded.png?nolink&20|}} icon in the toolbar above the query editor. The settings of the preview (such as the theme used and font size) can be specified by clicking on the {{docs:icons:icon_preview_settings.png?nolink&20|}} icon. To see query preview in the standalone browser click on the {{docs:icons:icon_form_browser_external_launch.png?nolink&20|}} icon. The preview of how the query will look like in the browser is displayed underneath the query editor. Any changes you make to the query are immediately reflected in the preview. You can turn embedded preview on or off by clicking on the {{docs:icons:icon_form_browser_embedded.png?nolink&20|}} icon in the toolbar above the query editor. The settings of the preview (such as the theme used and font size) can be specified by clicking on the {{docs:icons:icon_preview_settings.png?nolink&20|}} icon. To see query preview in the standalone browser click on the {{docs:icons:icon_form_browser_external_launch.png?nolink&20|}} icon.
  
  • Last modified: 2022/09/13 18:06