| Both sides previous revision Previous revision Next revision | Previous revision |
| a_f:a:pick_from [2022/09/01 01:23] – ↷ Page moved from a_f:3100_actions:pick_from to a_f:a:pick_from administrator | a_f:a:pick_from [2024/07/03 05:23] (current) – [PICK FROM] aware_admin |
|---|
| {{tag>Actions Action_List Process Query UI}} | {{tag>Index Action Action_List Process Query UI}} |
| ====== PICK FROM ====== | ====== PICK FROM ====== |
| |
| This action is similar to the [[find|FIND]] action in that it finds particular instances of a business object, but unlike the ''FIND'' action, it displays the instances found on the screen and waits for the user to pick a particular instance. The syntax of the action is almost exactly the same as that of the ''FIND'' action except that the ''PICK FROM'' keyword is used instead of ''FIND''. For example, | This action is similar to the [[find|FIND]] action in that it finds particular instances of a business object, but unlike the ''FIND'' action, it displays the instances found on the screen and waits for the user to pick a particular instance. The syntax of the action is almost exactly the same as that of the ''FIND'' action except that the ''PICK FROM'' keyword is used instead of ''FIND''. For example, |
| <code aim> | <code aim>PICK FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance </code> |
| PICK FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance | |
| </code> | |
| |
| <callout type="primary" icon="true" title="note"> | <callout type="primary" icon="true" title="note"> |
| |
| - ''IN BATCHES OF'' keyword that can be used in the keyword that can be used in the ''FIND'' action is not applicable to the ''PICK FROM'' action. action is not applicable to the ''PICK FROM'' action. | - ''IN BATCHES OF'' keyword that can be used in the keyword that can be used in the ''FIND'' action is not applicable to the ''PICK FROM'' action. action is not applicable to the ''PICK FROM'' action. |
| - By default the action will display a screen that allows selecting only one object. If multiple selection is required use the By default the action will display a screen that allows selecting only one object. If multiple selection is required use the ''PICK ONE OR MORE FROM'' keyword instead of keyword instead of ''PICK FROM'', for example ,<code aim> | - By default the action will display a screen that allows selecting only one object. If multiple selection is required use the By default the action will display a screen that allows selecting only one object. If multiple selection is required use the ''PICK ONE OR MORE FROM'' keyword instead of keyword instead of ''PICK FROM'', for example, <code aim>PICK ONE OR MORE FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance </code> |
| PICK ONE OR MORE FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance | - By default if a query finds just one instance of the object this instance will be displayed on the screen and the user will have to select it as usual. If you do not want the action to prompt for the single found instance, but use this instance straight away add ''NO CONFIRMATION FOR ONE'' keyword at the end of the action. For example, By default if a query finds just one instance of the object this instance will be displayed on the screen and the user will have to select it as usual. If you do not want the action to prompt for the single found instance, but use this instance straight away add ''NO CONFIRMATION FOR ONE'' keyword at the end of the action. For example, <code aim>PICK FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance NO CONFIRMATION FOR ONE </code> |
| </code> | - The ''USING'' keyword can be used when query condition is specified explicitly but display settings of an existing query can be used. For examle, <code aim>PICK FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance USING 'Some existing query'</code>Here 'Some existing query' is the name of the query which display settings will be used to display query results. |
| - By default if a query finds just one instance of the object this instance will be displayed on the screen and the user will have to select it as usual. If you do not want the action to prompt for the single found instance, but use this instance straight away add ''NO CONFIRMATION FOR ONE'' keyword at the end of the action. For example, By default if a query finds just one instance of the object this instance will be displayed on the screen and the user will have to select it as usual. If you do not want the action to prompt for the single found instance, but use this instance straight away add ''NO CONFIRMATION FOR ONE'' keyword at the end of the action. For example,<code aim> | |
| PICK FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance NO CONFIRMATION FOR ONE | |
| </code> | |
| </callout> | </callout> |
| |