OQL Examples

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

status = failed AND last_run >= -7d
ORDER BY last_run DESC

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

last_run IS NULL AND status = active
ORDER BY created_at ASC

updated_at >= -14d
ORDER BY updated_at DESC
LIMIT 50

tags CONTAINS "deprecated" AND
last_run < -90d AND
status != archived

(title ~ "login" OR title ~ "auth" OR title ~ "signup") AND
tags CONTAINS ANY (smoke, regression) AND
status = active
ORDER BY priority ASC

tags CONTAINS "api" AND
title ~ "/users" AND
test_type = automated

tags CONTAINS ANY (ios, android, mobile) AND
status = active
ORDER BY platform, priority

(title ~ "payment" OR title ~ "checkout" OR tags CONTAINS "payment") AND
priority IN (p0, p1, p2)
ORDER BY priority ASC, title ASC

pass_rate < 0.8 AND
pass_rate > 0 AND
execution_count >= 5 AND
status = active
ORDER BY pass_rate ASC

avg_duration > 300 AND
status = active
ORDER BY avg_duration DESC
LIMIT 20

environment = production AND
status = failed AND
last_run >= -24h
ORDER BY priority ASC

status = failed AND
defect_links IS NULL AND
last_run >= -7d

tags CONTAINS "sprint-24" AND
status IN (active, approved)
ORDER BY priority ASC

priority = p0 AND
(status = failed OR status = blocked) AND
tags CONTAINS "release"

tags CONTAINS "regression" AND
status = active AND
automated = true
ORDER BY folder_path, priority

created_at >= startOfMonth() AND
created_by = "current_user"
ORDER BY created_at DESC

created_by = "current_user"
ORDER BY updated_at DESC

assigned_to = "current_user" AND
status IN (active, in_review)

status = in_review AND
reviewer = "current_user"
ORDER BY created_at ASC

team = "qa" AND
created_at >= startOfWeek()
ORDER BY created_at DESC

tags IS NULL OR tags = []
ORDER BY created_at DESC
LIMIT 100

folder_id IS NULL AND
status = active

title ~ "copy" OR title ~ "duplicate"
ORDER BY title ASC

status = draft AND
created_at < -30d
ORDER BY created_at ASC

(tags CONTAINS "smoke" OR priority = p0) AND
status = active AND
(last_run IS NULL OR last_run < -7d) AND
automated = false
ORDER BY priority ASC, created_at DESC

status = failed AND
environment = staging AND
(environment != production OR
 last_run_production = passed) AND
last_run >= -24h

automated = false AND
execution_count >= 10 AND
pass_rate > 0.9 AND
avg_duration < 600 AND
tags CONTAINS ANY (smoke, regression)
ORDER BY execution_count DESC

status = active AND
last_run >= -30d AND
(
  (pass_rate < 0.7 AND pass_rate_previous_month > 0.9) OR
  (avg_duration > avg_duration_previous_month * 1.5)
)
ORDER BY pass_rate ASC