This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 4D Language Reference
-
- Queries
-
-
DESCRIBE QUERY EXECUTION
-
Find in field
-
Get last query path
-
Get last query plan
-
GET QUERY DESTINATION
-
Get query limit
-
ORDER BY
-
ORDER BY ATTRIBUTE
-
ORDER BY FORMULA
-
QUERY
-
QUERY BY ATTRIBUTE
-
QUERY BY EXAMPLE
-
QUERY BY FORMULA
-
QUERY SELECTION
-
QUERY SELECTION BY ATTRIBUTE
-
QUERY SELECTION BY FORMULA
-
QUERY SELECTION WITH ARRAY
-
QUERY WITH ARRAY
-
SET QUERY AND LOCK
-
SET QUERY DESTINATION
-
SET QUERY LIMIT
-
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:
- This command cannot be used with fields of the Picture or BLOB type.
- targetField and array must be of the same data type. Exception: you can use a Longint array with a field of the Time type.
The following example allows you to retrieve the records of both French and American clients:
ARRAY TEXT(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 v20 R7)
