OQL Overview - OneTest

OQL (OneTest Query Language) is a simple, powerful way to search and filter tests. It’s inspired by JQL (Jira Query Language) and designed to feel natural while giving you precise control.

Why Use OQL?

Precise Control

Filter by exact criteria, not fuzzy matches

Save Queries

Save complex searches for reuse

Combine Conditions

Use AND, OR, NOT for complex filters

Fast & Efficient

Optimized queries execute instantly

Quick Examples

status = active

status = active AND priority IN (p1, p2)

title ~ "login" AND scope ^ "auth"

created_at >= -7d ORDER BY created_at DESC

tags CONTAINS "smoke" AND tags NOT CONTAINS "deprecated"

Basic Syntax

Comparisons
Pattern Matching
Arrays
Logic

Compare fields to values:

Operator	Meaning	Example
`=`	Equals	`status = active`
`!=`	Not equals	`priority != p4`
`>`	Greater than	`created_at > 2024-01-01`
`>=`	Greater or equal	`version >= 2.0`
`<`	Less than	`priority < p2`
`<=`	Less or equal	`updated_at <= -7d`

Match text patterns:

Operator	Meaning	Example
`~`	Contains	`title ~ "login"`
`^`	Starts with	`identifier ^ "TC-10"`
`$`	Ends with	`title $ "test"`
`!~`	Not contains	`description !~ "deprecated"`

Work with lists:

Operator	Meaning	Example
`IN`	Value in list	`priority IN (p1, p2)`
`NOT IN`	Value not in list	`status NOT IN (archived, deleted)`
`CONTAINS`	Array contains value	`tags CONTAINS "smoke"`
`CONTAINS ANY`	Array contains any value	`tags CONTAINS ANY (smoke, regression)`
`CONTAINS ALL`	Array contains all values	`tags CONTAINS ALL (smoke, critical)`

Combine conditions:

Operator	Meaning	Example
`AND`	Both conditions	`status = active AND priority = p1`
`OR`	Either condition	`priority = p1 OR priority = p2`
`NOT`	Negate condition	`NOT status = archived`
`( )`	Group conditions	`(status = active OR status = approved) AND priority = p1`

Common Queries

Find Failed Tests

status = failed AND last_run >= -7d

Find tests that failed in the last 7 days.

Smoke Tests

tags CONTAINS "smoke" AND status = active
ORDER BY priority

All active smoke tests, ordered by priority.

High Priority Tests

priority IN (p0, p1) AND status != archived
ORDER BY created_at DESC

All P0 and P1 tests that aren’t archived.

Date & Time Queries

OQL supports flexible date queries:

Relative Dates
Specific Dates
Date Functions
Time Comparisons

created_at >= -7d        # Last 7 days
created_at >= -2w        # Last 2 weeks
created_at >= -3M        # Last 3 months
created_at >= -1y        # Last year

created_at >= 2024-01-01
created_at BETWEEN 2024-01-01 AND 2024-12-31
updated_at = 2024-06-15

created_at >= startOfWeek()
created_at >= startOfMonth()
created_at >= startOfYear()
created_at <= endOfMonth()

updated_at > created_at
last_run >= updated_at

Sorting & Pagination

Control result order and size:

# Sort by single field
ORDER BY created_at DESC

# Sort by multiple fields
ORDER BY priority ASC, created_at DESC

# Limit results
LIMIT 50

# Pagination
LIMIT 50 OFFSET 100

Saved Queries

Save frequently-used queries:

Write Your Query

priority IN (p0, p1) AND status = active AND tags CONTAINS "smoke"

Save with Name

Click “Save Query” and give it a name:

Critical Smoke Tests

Reuse Anytime

Access from the “Saved Queries” dropdown

Using with AI

You don’t need to write OQL manually! Just ask the AI:

Show me high priority tests that failed recently

The AI translates to:

priority IN (p0, p1) AND status = failed AND last_run >= -7d

What’s Next?

Full Syntax Reference

Complete OQL syntax documentation

Query Examples

More real-world query examples

Field Reference

All searchable fields

AI Search

Let AI write queries for you

​Why Use OQL?

Precise Control

Save Queries

Combine Conditions

Fast & Efficient

​Quick Examples

​Basic Syntax

​Common Queries

​Date & Time Queries

​Sorting & Pagination

​Saved Queries

​Using with AI

​What’s Next?

Full Syntax Reference

Query Examples

Field Reference

AI Search

Why Use OQL?

Quick Examples

Basic Syntax

Common Queries

Date & Time Queries

Sorting & Pagination

Saved Queries

Using with AI

What’s Next?