FIND_IN_ITEMS
Find the parent record which owns a child value; can return a specified field from the owning parent or the entire record
Example Usage
FIND_IN_ITEMS(Locations, IPAddresses, IPAddress, 127.0.0.1 ) // search Locations.IPWhiteList to find a match on Address (returns entire location record)
Overview
Function signature
FIND_IN_ITEMS(table, items, field, value, returncolumn)
Category
Database
Return data type
None
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
table | string | The table to search | |
items | string | The items list within each record in table to scan | |
field | string | The field in each item to inspect | |
value | string | The data value to search for (compared to items.field) | |
returncolumn | string | The field in the owning parent record to return; or blank to return the entire parent record |