ELEMENTS_AT_KEY
All functions > ARRAY OF ROWS > ELEMENTS_AT_KEY
Returns multiple elements at the given key from the given index, array or array of rows.
Signatures
Returns: Multiple elements at the positions indicated by index[key]
ELEMENTS_AT_KEY(index: INDEX, key: T, base: ARRAY<ROW<T>>) → ARRAY<ROW<T>>sql
| Parameter | Type | Required | Description |
|---|---|---|---|
index | INDEX | Yes | Index to look up positions from |
key | T | Yes | Key to look up in the index |
base | ARRAY<ROW<T>> | Yes | Array or array of rows to extract elements from |
Notes
- Uses index to map key to multiple array positions
- Looks up key in index to find array of positions
- Returns elements at those positions from base array
- Returns empty array if key not found in index
- Useful for one-to-many lookups with multi-valued indexes
On this page