Returns dataset from table/view query
Action #
Select
Arguments #
dbs*: Local database name or remote connection string (string)
tbl*: Table or view name (string)
col: Table/view column names (object, value TRUE = queryable)
page_index: Page number (integer, default=0, minimum=0)
page_size: Rows per page (0=all) (interger, default=10, minimum=1)
search: Global search filter (string)
search_columns: Column search filters (object)
search_column_fns: Column search filter modes (object)
sorting: Order by (array of { id and desc })
row_count: Row count (integer, minimum=0)
row_count_estimate: Calculate row count estimate (boolean)
media: For internal use only (object)
client_side: For internal use only (boolean)
Column Filters #
Column filters can be added using the search_column and search_column_fns parameters. You must provide both parameters! This feature requires a premium license.
Parameter search_columns format #
[
{
"id": "book_id",
"value": "8"
}
]Parameter search_column_fns format #
{
"book_id": "contains",
"book_title": "contains",
"book_author": "equals",
"book_genre": "equals",
"book_subgenre": "equals",
"date_added": "contains"
}