Noloco icon

Noloco

Interact with Noloco records

Actions6

Record → Search

AI-generated

Summary

Search records in a Noloco app/table with optional filtering, sorting, and pagination controls.

Inputs

  • app (required) — The Noloco app to work with (resource locator).
  • dataType (required) — The table (data type) to work with (resource locator).
  • returnAll — Whether to return all results or only up to a given limit (default: false).
  • limit — Maximum number of results to return when Return All is disabled (default: 50, min: 1, max: 100). Shown only when Return All is false.
  • filterMode — How to specify filter conditions (default: 'builder'). Options: 'builder' for UI filter builder, 'query' for custom JSON query.
  • where — Filter conditions when Filter Mode is 'builder'. A collection of condition objects each with field, operator, and value. If omitted, all records are returned. Shown only when Filter Mode is 'builder'.
  • customQuery — Custom filter in JSON format when Filter Mode is 'query' (default: empty string). Example: {@@email: {contains: '@example.com'}@@}. Shown only when Filter Mode is 'query'.
  • sort — Sorting rules (collection). Each rule specifies a field and direction (ASC/DESC, default DESC). If omitted, defaults to sorting by createdAt descending.

Output shape

json[]

Each element is a record object as returned by the Noloco API, containing the record's fields. The number of output items equals the number of input items (paired by index).

Examples

Example 1: Return first 20 records from the 'users' table where the email contains '@example.com', sorted by email ascending.

Set App to your Noloco app, Table to 'users', Return All off, Limit 20, Filter Mode builder, add condition: Field 'email', Operator 'contains', Value '@example.com', add sort rule: Field 'email', Direction 'ASC'.

Links

Discussion