| Both sides previous revision Previous revision Next revision | Previous revision |
| docs:2500_config_apps:1100_add_edit_queries [2022/09/13 18:15] – external edit 127.0.0.1 | docs:2500_config_apps:1100_add_edit_queries [2026/07/08 05:06] (current) – aware_admin |
|---|
| ====== 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 ''[[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 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 processes or business rules. Make sure that you read the [[docs:2000_concepts:0600_data_retrieval:0100_config_queries|Configuring Queries]] section to understand what an AwareIM query is and which types of queries are available. |
| |
| 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 Query Builder View and the Query Text 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 Query Builder tab provides a convenient user interface for specifying query conditions. However, not all queries can be specified using the Query Builder. See also [[docs:2500_config_apps:1100_add_edit_queries:0300_standard_view|Specifying Query Using Query Builder 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]]. | - Where it is not possible to specify a query using the Query Builder, it is possible to specify a query using the Query Text tab. This 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 Query Text 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 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. |
| |
| To apply a particular presentation style to a query, select the {{docs:icons:icon_form_style_apply.png?nolink&20|}}I con in the toolbar. For more details about styles see [[docs:2500_config_apps:1700_styles|Form and Grid Styles]] section. | To apply a particular presentation style to a query, select the {{docs:icons:icon_form_style_apply.png?nolink&20|}}I con in the toolbar. For more details about styles see [[docs:2500_config_apps:1700_styles|Form and Grid Styles]] section. |
| |
| {{simplenavi>docs:2500_config_apps/1100_add_edit_queries}} | {{simplenavi>docs:2500_config_apps/1100_add_edit_queries}} |