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 SELECTION WITH ARRAY
| QUERY SELECTION WITH ARRAY ( targetField ; array ) | ||||||||
| Parameter | Type | Description | ||||||
| targetField | Field |
|
Field used to compare the values | |||||
| array | Array |
|
Array of searched values | |||||
The QUERY SELECTION WITH ARRAY command searches the table of the field passed as first parameter for the records where the value of targetField is equal to at least one of the values of the elements in the array. The records found will become the new current selection.
QUERY SELECTION WITH ARRAY functions in the same way as QUERY WITH ARRAY. The difference between these two commands is the scope of the search:
- QUERY WITH ARRAY searches all the records of the table containing targetField.
- QUERY SELECTION WITH ARRAY only searches the records of the current selection of the table containing targetField.
For more information, please refer to the description of the QUERY WITH ARRAY command.
Product: 4D
Theme: Queries
Number:
1050
Created: 4D v11 SQL Release 2
4D Language Reference ( 4D v20 R7)
