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:0300_standard_view [2022/08/24 07:06] – administrator2500_config_apps:1100_add_edit_queries:0300_standard_view [2026/08/13 00:55] (current) – ↷ Links adapted because of a move operation localdev
Line 1: Line 1:
 [<10>] [<10>]
-====== Specifying Query Using Standard View ======+====== Specifying Query Using Query Builder View ======
  
-The Standard View tab provides a convenient user interface for defining simple queries.+The Query Builder tab provides a convenient user interface for defining simple queries.
  
-To define a query using the Standard View, follow the steps below:+To define a query using the Query Builder, follow the steps below:
  
   - Specify the name of the business object or business object group that the query will be looking for in the "Business object or group" drop down of the editor. If you want the query to perform a search using business object form click on the "Use form" property in the Element Properties window and select the form of the business object – see [[2000_concepts:0600_data_retrieval:0400_form_driven_queries|Searching for Data Using Forms]].   - Specify the name of the business object or business object group that the query will be looking for in the "Business object or group" drop down of the editor. If you want the query to perform a search using business object form click on the "Use form" property in the Element Properties window and select the form of the business object – see [[2000_concepts:0600_data_retrieval:0400_form_driven_queries|Searching for Data Using Forms]].
Line 12: Line 12:
     - Click on the "Value/Expression" cell in the table and type in the value that the selected attribute will be compared with using the selected criterion. For example, if you selected Account.Balance in the "Attribute/Expression" cell, ">" in the "Criterion" cell and entered 1000 in the "Value/Epression" cell the query will look for all instances of the Account object with account balances greater than 1000.     - Click on the "Value/Expression" cell in the table and type in the value that the selected attribute will be compared with using the selected criterion. For example, if you selected Account.Balance in the "Attribute/Expression" cell, ">" in the "Criterion" cell and entered 1000 in the "Value/Epression" cell the query will look for all instances of the Account object with account balances greater than 1000.
     - If the query uses more than one condition specify other conditions in other rows of the table. By default the conditions will be linked with the AND keyword. If you want to link the conditions with the OR keyword click on the "Link" cell and select OR from the combo box displayed     - If the query uses more than one condition specify other conditions in other rows of the table. By default the conditions will be linked with the AND keyword. If you want to link the conditions with the OR keyword click on the "Link" cell and select OR from the combo box displayed
-    - If the query uses more conditions than the number of rows available in the table click on the {{:documentation:icons:icon_add.png?nolink&20|}} icon at the top of the table. If you want to delete a condition select the condition by clicking on any cell in the condition’s row and click on the {{:documentation:icons:icon_delete.png?nolink&20|}} icon.+    - If the query uses more conditions than the number of rows available in the table click on the {{docs:icons:icon_add.png?nolink&20|}} icon at the top of the table. If you want to delete a condition select the condition by clicking on any cell in the condition’s row and click on the {{docs:icons:icon_delete.png?nolink&20|}} icon.
   - You can optionally sort instances found by the query. You can sort by the value of the attribute(s) of the business object that the query is looking for. If you specify several attributes then the instances will be sorted by the value of the first attribute. If there are equal entries they will be sorted by the value of the second attribute and so on. You can also specify whether sorting will be performed in the ascending or descending order.    - You can optionally sort instances found by the query. You can sort by the value of the attribute(s) of the business object that the query is looking for. If you specify several attributes then the instances will be sorted by the value of the first attribute. If there are equal entries they will be sorted by the value of the second attribute and so on. You can also specify whether sorting will be performed in the ascending or descending order. 
     - To specify the attribute to sort by tick the checkbox next to the attribute name in the "Sorting of Results" table.      - To specify the attribute to sort by tick the checkbox next to the attribute name in the "Sorting of Results" table. 
Line 19: Line 19:
   - You can also specify that the query should return only a certain number of instances (the first ones). This option is usually used in conjunction with sorting – you can sort the instances found by the query and then return the first "n" instances. To specify the number of instances to return select the "Return first" radio button in the "Return Results" section and specify the number in the text box next to the radio button.   - You can also specify that the query should return only a certain number of instances (the first ones). This option is usually used in conjunction with sorting – you can sort the instances found by the query and then return the first "n" instances. To specify the number of instances to return select the "Return first" radio button in the "Return Results" section and specify the number in the text box next to the radio button.
  
-<note>You can use the [[7000_glossary:attribute|ID attribute]] in the query conditions and sorting. </note>+<callout type="primary" icon="true" title="note"> You can use the [[ref:glossary:attribute|ID attribute]] in the query conditions and sorting. </callout>
  
-<note>One of the expressions that you can select when defining query conditions is "Ask at run time". This expression indicates that the value of the attribute should be entered by the user when the query is run (see [[2000_concepts:0600_data_retrieval:0110_queries_user_input|Queries that Require User’s Input]]). Note that if you look at such a query in the Rule Form, the corresponding condition will be shown with the question mark, for example:<code aim>FIND Forum WHERE Forum.Title=?Title</code>+<callout type="primary" icon="true" title="note"> One of the expressions that you can select when defining query conditions is "Ask at run time". This expression indicates that the value of the attribute should be entered by the user when the query is run (see [[2000_concepts:0600_data_retrieval:0110_queries_user_input|Queries that Require User’s Input]]). Note that if you look at such a query in the Rule Form, the corresponding condition will be shown with the question mark, for example:<code aim>FIND Forum WHERE Forum.Title=?Title </code>
  
-When a user runs this query //**Aware IM**// will prompt the user to enter the value of the Forum Title and then display the result. The string after the question mark indicates the text that will be displayed when //**Aware IM**// prompts for the value of the attribute. By default this text is equal to the name of the attribute, but you can change it to anything you like on the [[2500_config_apps:1100_add_edit_queries:0400_text_view|Textual View]] tab (if a text has spaces enclose the text in apostrophe).</note>+When a user runs this query //**AwareIM**// will prompt the user to enter the value of the Forum Title and then display the result. The string after the question mark indicates the text that will be displayed when //**AwareIM**// prompts for the value of the attribute. By default this text is equal to the name of the attribute, but you can change it to anything you like on the [[2500_config_apps:1100_add_edit_queries:0400_text_view|Textual View]] tab (if a text has spaces enclose the text in apostrophe).</callout>