LLMs and GenAI 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. The query language and examples on this page are unique to the LLMs and GenAI project type.

Metadata

These parameters can be found under the metadata field.

ParameterValue
nameThe value is the item's name.
statusNotStarted, InProgress, QualityCheck, Returned, Completed, and Skipped.
approvalStatustrue, false, and null.
annotatorEmailThe value is an email address. Use null for unassigned items.
qaEmailThe value is an email address. Use null for unassigned items.
lastAction.emailThe value is an email address.
lastAction.timestampThe value is a date with this format YYYY-MM-DD.
priorityNumeric value.
categoryThe value is the category name.

Other fields

FieldParameterValue
comment- resolved

- text
- true and false.

- Value is a manual input after an operator is selected.
commentCount-Numeric value.
folderName-The value is the folder's name.
folderStatus-The value is the folder's status.
subsetName-The value is the subset’s name.
random-Numeric value.

Component fields

ParameterValue
input- Value is a manual input after an operator is selected.

- Queries for this component are case-insensitive when used with the CONTAINS operator.
inputLengthNumeric value.
inputLength.IDThe value is the input length’s ID.
textarea- Value is a manual input after an operator is selected.

- Queries for this component are case-insensitive when used with the CONTAINS operator.
textareaLengthNumeric value.
numberValue is a manual input after an operator is selected.
slider- Value is a manual input after an operator is selected.

- If the slider is a Range slider, then the > and => operators will consider the higher value, and the < and <= operators will consider the lower value. In this case, the =, != IN, and NOT IN operators can't be used.
radio- All radio and single-select options will be autosuggested after entering this parameter.

- Value can either be a selected radio option, or a manual input.
checkbox- All checkbox and multi-select options will be auto-suggested after entering this parameter.

- Value can either be a selected radio option, or a manual input.
ratingValue is a manual input after an operator is selected.
votingtrue, false, and null.
select- All select options will be auto-suggested after entering this parameter.

- Radio and multi-select options may be included.
- Value can either be a selected radio option, or a manual input.
datetimeThe value is a date with this format YYYY-MM-DD.
code- Value is a manual input.

- Queries for this component are case-insensitive when used with the CONTAINS operator.
codeLengthNumeric value.
paragraph- Value is a manual input after an operator is selected.

- Queries for this component are case-insensitive when used with the CONTAINS operator.
paragraphLengthNumeric value.
markdown- Value is a manual input after an operator is selected.

- Queries for this component are case-insensitive when used with the CONTAINS operator.
markdownLengthNumeric value.
csv- Value is a manual input.

- Queries for this component are case-insensitive when used with the CONTAINS operator.

- When querying with the = or != operators, you must use the exact expression that’s used in the JSON file. For example: “cell1_text,cell2_text,,\r\n,,,\r\n,,,\r\n,,,”

If you want to query components that don’t have a value entered or selected, you can use the value of none.

Here are some example queries that you can try:

ExampleQuery
To search for items that have a rating of 3 stars or higher and are voted 'Approved'.rating >= 3 AND voting = true
To search for items that have a rating of 3 stars or higher and whose completion is voted true.
In this case, the rating component's ID is prompt, and the voting component's ID is completion.
rating.prompt >= 3 AND voting.completion = true
To search for items that are marked 'Complete' for model 1 and 'Incomplete' for model 2.
In this case, there are two radio components with the model1 and model2 IDs.
radio.model1 = Complete AND radio.model2 = Incomplete
To search for items whose completion contains the word 'software' and correction contains SaaS.
In this case, there are two textarea components with the completion and correction IDs.
textarea.completion CONTAINS software AND textarea.correction CONTAINS SaaS
To search for items that have a slider value of less than 10.slider < 10

Group field

The Group field filters all group components used in the project by their unique IDs. All components that are within a queried group will be visible as a result. You may also query that group’s components specifically.

To query your items by the number of group repetitions, you can use the groupCount query.

To search for items where the answer is repeated over 3 times (in this case, the answer component ID is answer): groupCount.answer > 3

To search for items where answers with a rating of 5 are repeated more than 3 times (in this case, the answer component ID is answer and it has a rating component in the same group): groupCount.answer(rating=5) > 3

Examples

Searching for items that have a rating of 5 for a prompt (Prompt and completion components are set in separate groups while the item template is created): group.prompt (rating.prmt = 5)

Searching for items that have a rating of 5 for prompts and a rating of 3 for completions (Prompt and completion components are set in separate groups while the item template is created): group.prompt (rating.prmt = 5) AND group.completion (rating.cmp = 5)