Cirqll Core
HomeCirqll
HomeCirqll
  1. Query Parameters
  • Getting Started
  • Documentation
    • Zapier
    • Query Parameters
      • Eager Loading
      • Partial Data
      • Count Relations
      • Filter
      • Order By
      • Pagination
    • Authentication
      • OAuth2
        • Authorize
          • Authorize
        • User
          • Me
        • Client
          • Index
          • Create
          • Update
          • Delete
        • Token
          • Create
          • Refresh
          • Index
        • Scopes
  • User
    • Index
      GET
    • Show
      GET
    • Create
      POST
    • Update
      PATCH
    • Delete
      DELETE
  • Role
    • Index
      GET
    • Show
      GET
    • Create
      POST
    • Update
      PATCH
    • Delete
      DELETE
  • Customer
    • Index
      GET
    • Show
      GET
    • Delete
      DELETE
    • Update
      PATCH
    • Create
      POST
  • Contact
    • Index
    • Show
    • Create
    • Update
    • Delete
  • Task
    • Index
    • Show
    • Create
    • Update
    • Delete
  • Appointment
    • Index
    • Show
    • Create
    • Update
    • Delete
  • Financial
    • Chance
      • Index
      • Show
      • Create
      • Update
      • Delete
    • Assignment
      • Index
      • Show
      • Create
      • Update
      • Delete
    • Contract
      • Index
      • Show
      • Create
      • Update
      • Delete
  • Email
    • Index
    • Show
    • Create
    • Update
    • Delete
  • Field
    • Index
    • Show
    • Create
    • Update
    • Delete
  • Note
    • Index
    • Show
    • Create
    • Update
    • Delete
  • To-do
    • Index
    • Show
    • Create
    • Update
    • Delete
  • Template
    • Index
    • Show
    • Update
    • Create
    • Delete
  • Setting
    • Index
    • Update
  • Webhook
    • Index
    • Show
    • Create
    • Update
    • Delete
  1. Query Parameters

Filter

The API supports an advanced filtering system using the filter query parameter, which allows clients to specify complex filtering logic. This feature enables precise and efficient querying of resources based on multiple conditions and nested relationships.

Filter Syntax#

Filters are defined using the filter parameter in the query string. The format supports logical operators (AND, OR), nested conditions, and a variety of comparison operators.

Basic Filter#

To apply a simple filter:
Example:
Response:
{
    "data": [
        {
            "id": 1,
            "name": "Example Name"
        }
    ],
    ...pagination data
}

Multiple Filters#

Combine filters using logical operators (AND, OR) and parentheses for grouping:
Example:
Response:
{
    "data": [
        {
            "id": 1,
            "price": 150,
            "category": "Electronics"
        }
    ],
    ...pagination data
}

Nested Filters#

Use dot notation to filter based on related resources:
Example:
Response:
{
    "data": [
        {
            "id": 1,
            "name": "Example",
        }
    ],
    ...pagination data
}

Supported Operators#

The following operators are supported for filtering:
OperatorExample QueryDescription
eqname:eq:ExampleField is equal to the given value
gtprice:gt:100Field is greater than the given value
ltprice:lt:100Field is less than the given value
gteprice:gte:500Field is greater than or equal to the given value
lteprice:lte:500Field is less than or equal to the given value
likename:like:johnField contains the value (case-insensitive)
containsname:contains:johnActs the same as the like operator
starts_withemail:starts_with:infoField starts with the given value
ends_withemail:ends_with:@example.comField ends with the given value
instatus:in:active;pending;suspendedField matches any of the given values
notstatus:not:eq:activeNegates the filter condition

Behavior Notes#

Logical operators (AND, OR) are case-insensitive.
Fields used in the filter do not require to be in show or with.
If an invalid operator is provided, the API will return a 400 Bad Request response with details of the error.
Modified at 2025-08-27 07:38:36
Previous
Count Relations
Next
Order By
Built with