FETCH_RECORDS_BY_RANGE
Fetch rows from a table using a range of values
Example Usage
FETCH_RECORDS_BY_RANGE(MyTable, TransactionDate, startdate, enddate) // TransactionDate being the column name to search, start/enddate being workflow params
Overview
Function signature
FETCH_RECORDS_BY_RANGE(tablename, field, valuestart, valueend, columns)
Category
DB
Return data type
list
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
tablename | string | The table to search | |
field | string | The field to search on | |
valuestart | None | The starting value to match | |
valueend | None | The end value to match | |
columns | string | The column or columns to return; if blank the entire record is returned |