entitySelection.query( )

Home

4D v19.8


entitySelection.query ( queryString \| formula {; value}{; value2 ; ... ; valueN}{; querySettings}) -> Result

Parameter	Type	Description
queryString \| formula	Text, Object	Search criteria as string or formula object
value	Mixed	Value(s) to compare when using placeholder(s)
querySettings	Object	Query options: parameters, attributes, args, allowFormulas, context, queryPath, queryPlan
Result	EntitySelection	New entitySelection made up of entities from entity selection meeting the search criteria specified in queryString

Description

The entitySelection.query( ) method searches for entities that meet the search criteria specified in queryString or formula and (optionally) value among all the entities in the entity selection, and returns a new object of type EntitySelection containing all the entities that are found. Lazy loading is applied.

Note: This method does not modify the original entity selection.

If no matching entities are found, an empty EntitySelection is returned.

For detailed information on how to build a query using queryString, value, and querySettings parameters, please refer to the dataClass.query( ) method description.

Note: By default if you omit the order by statement in the queryString, the returned entity selection is not ordered (for more information, please refer to Ordered vs Unordered entity selections). Note however that, in Client/Server mode, it behaves like an ordered entity selection (entities are added at the end of the selection).

Example 1

 C_OBJECT($entitySelectionTemp)

 $entitySelectionTemp:=dataClass.query("lastName = :1";"M@")

 Form.emps:=$entitySelectionTemp.query("manager.lastName = :1";"S@")

Example 2

More examples of queries can be found in the dataClass.query( ) page.