This action is similar to the 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,
PICK FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance
IN BATCHES OF keyword that can be used in the FIND action is not applicable to the PICK FROM action.PICK ONE OR MORE FROM keyword instead of PICK FROM, for example, PICK ONE OR MORE FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance
NO CONFIRMATION FOR ONE keyword at the end of the action. For example, PICK FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance NO CONFIRMATION FOR ONE
USING keyword can be used when query condition is specified explicitly but display settings of an existing query can be used. For example, PICK FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance USING 'Some existing query'
Here 'Some existing query' is the name of the query which display settings will be used to display query results.
PICK [ ONE | ONE OR MORE ] FROM ( ALL Id() | Id() WHERE RuleCondition() | StringLiteral() | Id() ) [ ORDER BY AttributeIdentifier() [ ASC | DESC ] ( , AttributeIdentifier() [ ASC | DESC ] )* ] [ TAKE BEST ( INTEGER_LITERAL | AttributeIdentifier() ) ] [ LIMIT ArithmeticExpression() , ArithmeticExpression() ] [ NO CONFIRMATION FOR ONE ] [ USING StringLiteral() ]
PICK FROM Account WHERE Account.State = 'OPEN' ORDER BY Account.Balance