Parameters

The fetchAllRecords() method object can contain the following properties:

Parameter	Type	Required	Description
table	string	Yes	Name of the table to query.
where	Record<string, any | FilterOperators>	No	An object containing conditions to filter the records.
search	SearchOptions	No	A configuration object for performing a keyword search.
fields	string[]	No	An array of specific fields to return in the response.
with	Record<string, RelationshipOptions>	No	An object specifying related tables to include with the returned records.
page	number	No	The page number for paginated results.
list or limit	number	No	The number of records to return per page.
orderBy	string	No	The field to sort the results by.
order	'asc' | 'desc'	No	The sort direction, either ascending (asc) or descending (desc).
distinct	boolean	No	A boolean value that returns only unique records when set to true.