query_dci_remotecis
Query DCI remotecis (labs) using a flexible DSL with filters like name, tags, dates, and boolean logic. List all, count, or search with pagination.
Instructions
Lookup DCI remotecis with an advanced query language.
Listing all remotecis: To list all remotecis, use ilike(name,%) as the query.
The query language is based on this DSL:
eq(<field>,<value>) to lookup resources with a <field> having the value <value>.
IMPORTANT: Values must NOT be quoted. Use eq(name,dallas) not eq(name,'dallas').
You can use the comparison functions gt (greater than), ge (greater or equal),
lt (less than) or le (less or equal) using the same syntax as eq: <op>(<field>,<value>).
like(<field>,<value with percent>) and ilike(<field>,<value with percent>)
to lookup a field with a SQL glob like way. For example, to get the remotecis
with a specific name pattern, use like(name,dallas-%).
contains(<field>,<value1>,...) and not_contains(<field>,<value1>,...)
to lookup elements in an array. This is useful mainly for tags.
and(<op1>(...),<op2>(...)), or(<op1>(...),<op2>(...)) and not(<op>) allow
to build nested boolean queries.
null(<field>) to lookup resources with a field having a NULL value.Here are all the fields of a DCI remoteci that can be used in the query:
- id: unique identifier
- name: name of the remoteci (lab)
- created_at: The creation timestamp. Use `today` tool to compute relative dates.
- updated_at: The last update timestamp. Use `today` tool to compute relative dates.
- tags: list of tags associated with the remoteci.Listing all remotecis: To list all remotecis, use ilike(name,%) as the query.
Counting Remotecis: To get the total count of remotecis matching a query, set limit=1 and read the count field in the _meta section of the response.
Example for counting remotecis by name:
{
"query": "eq(name,dallas)",
"limit": 1,
"offset": 0,
"fields": []
}This will return a response like:
{
"remotecis": [],
"_meta": {"count": 2},
...
}The total count is 2 remotecis.
Returns: JSON string with list of remotecis and pagination info
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | search criteria (e.g., and(ilike(name,dallas),contains(tags,ga))). To list all, use ilike(name,%) | |
| sort | No | Sort criteria | -created_at |
| limit | No | Maximum number of results to return for pagination (default 20, max 200). Use limit=1 to get count from metadata. | |
| offset | No | Offset for pagination | |
| fields | No | List of fields to return. Fields are the one listed in the query description and responses. Must be specified as a list of strings. If empty, no fields are returned. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |