query_dci_teams
Search DCI teams using a flexible query language with operators like eq, ilike, and contains. Filter by fields such as name, tags, and creation date.
Instructions
Lookup DCI teams with an advanced query language.
Listing all teams: To list all teams, 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,DCI) not eq(name,'DCI').
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 with at least one % character. For example, to get the teams
with a specific name pattern, use like(name,%Name%).
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 team that can be used in the query:
- id: unique identifier
- name: name of the team
- 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 team.Listing all teams: To list all teams, use ilike(name,%) as the query.
Counting Teams: To get the total count of teams matching a query, set limit=1 and read the count field in the _meta section of the response.
Example for counting teams by name:
{
"query": "eq(name,DCI)",
"limit": 1,
"offset": 0,
"fields": []
}This will return a response like:
{
"teams": [],
"_meta": {"count": 10},
...
}The total count is 10 teams.
Returns: JSON string with list of teams and pagination info
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | search criteria (e.g., and(ilike(name,qa),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
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |