4D v14.3QUERY WITH ARRAY |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v14.3
QUERY WITH ARRAY
|
QUERY WITH ARRAY ( targetField ; array ) | ||||||||
Parameter | Type | Description | ||||||
targetField | Field |
![]() |
Field used to compare the values | |||||
array | Array |
![]() |
Array of the searched values | |||||
The QUERY WITH ARRAY command searches all the records for which the value of targetField is equal, at least, to one of the values of the elements in array. The records found will become the new current selection.
This command allows you to quickly and simply build a search on multiple values.
Notes:
The following example allows you to retrieve the records of both French and American clients:
ARRAY STRING(2;SearchArray;2)
SearchArray{1}:="FR"
SearchArray{2}:="US"
QUERY WITH ARRAY([Clients]Country;SearchArray)
Product: 4D
Theme: Queries
Number:
644
Modified: 4D v11 SQL
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)
Parent of : QUERY WITH ARRAY ( 4D v12.4)