FIND
Lookup fields in related datasources (e.g. lookup an employee's attributes when processing a timecard)
Example Usage
FIND('Employee', 'Exempt') -> 'true'|'false' or 1|0
FIND('Employee', 'HireDate') -> '2022-02-08'
FIND('Location', 'Code') -> the code corresponding to the employees home location
FIND('test', 'test') -> 'TestResult' // used to test when there is no data
FIND('Employee', ) -> {"Number":"1234", "Lastname":"Mouse", "Firstname":"Mick", ... }
Overview
Function signature
FIND(source, column)
Category
Database
Return data type
None
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
source | string | Name of the related datasource to return | |
column | string | Column/field to return in the related table; if omitted the entire object is returned |