> For the complete documentation index, see [llms.txt](https://docs.skyone.cloud/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.skyone.cloud/english/skyone-studio/how-to/using-filters-in-skyone-studio.md).

# Using filters in Skyone Studio

To perform advanced queries in the **Skyone Studio** API, use the query parameter. The value of this parameter must be a valid JSON object sent in the *underline query* pattern.

### Base JSON Structure

Below is the complete structure that includes sorting, date range filtering, and pagination:

```json
{
  "sort": {
    "startTimeUTC": -1
  },
  "filter": {
    "startTimeUTC": {
      "_period_greater_equal": "2026-01-01T00:00:00Z",
      "_period_smaller_equal": "2026-01-06T23:59:59Z"
    }
  },
  "pagination": {
    "limit": 10,
    "skip": 0
  }
}
```

Read below for a better understanding of the items:

### Pagination

Controls the amount of data returned per request to optimize performance.

* **limit:** Defines the maximum number of items per page.
* **skip:** Defines how many items should be skipped (offset) to access the next pages.

Example:

```json
"pagination": {
  "limit":10
  "skip": 0
}

```

### Filter

The *filter* object allows you to refine your search using specific keys and comparison operators.

<table data-header-hidden><thead><tr><th width="145.78515625"></th><th width="193.35546875"></th><th></th></tr></thead><tbody><tr><td><strong>Operator</strong></td><td><strong>Description</strong></td><td><strong>Use Example</strong></td></tr><tr><td><code>_equal</code></td><td>Filters records where the column value exactly matches the specified value, respecting characters and case sensitivity (uppercase/lowercase).</td><td><code>"status": {"_equal": "active"}</code></td></tr><tr><td><code>_diff</code></td><td>Filters records where the column value does not match the specified value.</td><td><code>"id": {"_diff": 0}</code></td></tr><tr><td><code>_like</code></td><td>Filters records in which the column value contains the searched term, allowing for partial searches.</td><td><code>"name": {"_like": "Sky"}</code></td></tr><tr><td><code>_greater</code></td><td>Filters records where the column value is greater than the specified value.</td><td><code>"price": {"_greater": 50}</code></td></tr><tr><td><code>_smaller</code></td><td>Filters records where the value is less than the specified limit.</td><td><code>"stock": {"_smaller": 10}</code></td></tr><tr><td><code>_greater_equal</code></td><td>Filters records where the value is greater than or equal to the specified limit.</td><td><code>"age": {"_greater_equal": 18}</code></td></tr><tr><td><code>_smaller_equal</code></td><td>Filters records where the value is less than or equal to the specified limit.</td><td><code>"limit": {"_smaller_equal": 100}</code></td></tr><tr><td><code>_exists</code></td><td>Filters records based on the existence of the field/column in the document, returning those where the field is present (<code>true</code>) or absent (<code>false</code>), regardless of its value.</td><td><code>"tag": {"_exists": true}</code></td></tr><tr><td><code>_not_exists</code></td><td>Filters records where the field/column does not exist in the document, regardless of the value.</td><td><code>"deletedAt": {"_not_exists": true}</code></td></tr><tr><td><code>_in</code></td><td>Filters records where the column value is contained within a provided list (array) of values.</td><td><code>"role": {"_in": ["admin", "editor"]}</code></td></tr></tbody></table>

#### Date Range Filters (Date/Time)

For date fields such as ***startTimeUTC***, use the following period prefixes:

* **\_period\_greater:** Date after.
* **\_period\_smaller:** Date before.
* **\_period\_greater\_equal:** Start date (inclusive).
* **\_period\_smaller\_equal:** End date (inclusive).

In the scenario below, the filter acts as an && (and) operator:

```json
"startTimeUTC": {
      "_period_greater_equal": "2026-01-01T00:00:00Z",
      "_period_smaller_equal": "2026-01-06T23:59:59Z"
    }
```

### Sort

Defines the direction in which results are returned based on a key:

* -1: Descending Order (default).
* 1: Ascending Order.

\
Example:

```json
{
  "sort":{
    "startTimeUTC":-1
  }
```


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.skyone.cloud/english/skyone-studio/how-to/using-filters-in-skyone-studio.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
