Skip to main content
Version: 20 R7 BETA

QUERY SELECTION BY ATTRIBUTE

QUERY SELECTION BY ATTRIBUTE ( {aTable}{;}{conjOp ;} objectField ; attributePath ; queryOp ; value {; *} )

ParameterTypeDescription
aTableTableTable for which to return a selection of records, or Default table if omitted
conjOp*Conjunction operator to use to join multiple queries (if any)
objectFieldFieldObject field to query attributes
attributePathTextName or path of attribute
queryOp*, TextQuery operator (comparator)
valueText, Number, Date, TimeValue to compare
*OperatorContinue query flag

Description

QUERY SELECTION BY ATTRIBUTE works and performs the same actions as QUERY BY ATTRIBUTE. The difference between these two commands is the scope of the query:

  • QUERY BY ATTRIBUTE looks for records among all the records in the table.
  • QUERY SELECTION BY ATTRIBUTE looks for records among the records currently selected in the table.

QUERY SELECTION BY ATTRIBUTE looks for records in aTable. The QUERY SELECTION BY ATTRIBUTE command changes the current selection of aTable for the current process and makes the first record of the new selection the current record.

For more information, see the description of the QUERY BY ATTRIBUTE command.

The QUERY SELECTION BY ATTRIBUTE command is useful when a query cannot be defined using a combination of QUERY BY ATTRIBUTE (and even QUERY) calls joined with the * parameter. Typically, this is the case when you want to query a current selection that does not result from a previous query, but from a command such as USE SET.

Example

You want to find people with an age between 20 and 30, among the records that were previously highlighted by the user:

 USE SET("UserSet") //creates a new current selection
 QUERY SELECTION BY ATTRIBUTE([People];[People]OB_Info;"age";>;20;*)
 QUERY SELECTION BY ATTRIBUTE([People];&;[People]OB_Info;"age";<;30) //triggers the query

See also

QUERY BY ATTRIBUTE

Properties

Command number1424
Thread safe
Modifies variablesOK
Changes current record
Changes current selection