Queries

When you’re in the Explore tab, you'll see a query search bar above your items. This bar takes JSON queries that'll allow you to search for items in your project that match any given criteria. To see information about queries regarding Multimodal projects, read here.

Here are some example queries you can try out:

Operators

You'll need to use operators to define your queries and values.

📘

When the attribute has a numeric type, the following operators will be supported for attributes.name: > < =< !=

Instance

These parameters can be found under the instance field.

🚧

About class names

If the class name contains an operator (and, or, in, not in, contains), the query will handle them as operators, not as words in class names. For example, if the class name is Cars and pedestrians, the query will handle the word cars and the word pedestrians separately. Instead, you can use symbols, such as underscores, to separate the words. So Cars and pedestrians would be changed to cars_and_pedestrians.

Metadata

These parameters can be found under the metadata field.

Other fields

Sort items by query

With the use of the query bar, you can manually specify the data you want to order your item by. You can do so by using orderBy. After typing it in the bar, you must then select one of the following parameters to specify the ordering.

You can read about the functionality of the orderBy query for the Multimodal project type here.

Query example

Say you want to sort the items that haven't been worked on by name, in ascending order. You can use the following query: metadata(status = NotStarted) orderBy metadata.name ASC

Another example is to sort the items that have been marked for Quality Check based on the date of the last action taken, in descending order: metadata(status = QualityCheck) orderBy metadata.lastAction.date DESC

🚧

You can't use orderBy as a sole query

Please note that you can't use the orderBy query on its own (e.g. orderBy metadata.status ASC). Think of it as a secondary attachment to the overall query; it must follow a general query, such as metadata or commentCount, so that you can add an additional parameter to sort your items with.

Generate query

First, make sure that your dataset is synced. You can do so by pressing the Sync data button.

To generate a query:

1. In the Explore tab, click the query input bar.
2. Choose the suggested fields and operators or type the query yourself.
3. To run the query, press Enter on the keyboard.

Save query

To save a query:

1. Type a query in the query bar.
2. Click on the star on the right side of the query bar.
3. In the popup, type a query name.
4. Check the Save as shared query box to make the query public to users with roles of Project Admin or higher.
5. Click Save.

📘

The maximum number of characters for a query is 60.
You can save up to 50 queries.

🚧

Only the creator of a shared query can make it private again.

Rename query

To rename a query:

1. Click on the star in the query bar.
2. Click the three dots ⋮ next to the query you want to rename.
3. Select Rename.
4. Type a new query name.
5. Click Rename.

Delete query

To delete a query:

1. Click on the star in the query bar.
2. Click the three dots ⋮ next to the query you want to delete.
3. Select Delete.

🚧

Team Owners and Team Admins can delete shared queries regardless of who created them.