See How Aurora Search Finds Proof, Answers Questions, and Powers Automation
Aurora search helps teams surface the right evidence fast, answer reviewer questions with confidence, and give builders a clean path into automation when a simple lookup is not enough.
Updated 2026-02-15
What This Reference Helps You Evaluate
Choose the Search Path That Fits the Work
Verify search coverage
Plan AQL-powered workflows
Choose the right endpoint
Key Endpoints for Search, Retrieval, and Automation
/search.phpQuery category-based global search with per-type limits, recent mode, and optional category targeting.
Use when you need quick navigation results, search overlays, or a lightweight search API for support tooling.
/advanced-search.php?action=enqueueSubmit heavier AQL queries asynchronously when the job is bigger than a standard lookup.
Best for reporting, automation, and admin workflows that need durable results without slowing the user experience.
/advanced-search.php?action=statusTrack queued AQL jobs until results are ready, then return cached output and execution details.
Best for progress states, retries, exports, and background workflows that need a predictable handoff.
/advanced-search.php?action=sources|catalog|executeInspect permitted sources, read catalog metadata, or run controlled direct queries for shorter operational tasks.
Best for query builders, admin tooling, and tightly scoped integrations that need source metadata on demand.
Detailed Search, AQL, Dataset, and Troubleshooting Reference
Aurora search includes a global, category-based search and an advanced query language (AQL) for deep, dataset-specific queries.
Where search lives
See which Aurora surfaces use shared search and where teams encounter quick lookup versus deeper retrieval workflows.
Where search lives
See which Aurora surfaces use shared search and where teams encounter quick lookup versus deeper retrieval workflows.
- Sidebar 'Find pages...' input filters the navigation only.
- Global search overlay (Cmd/Ctrl+K) for quick navigation and lookup.
- Global search page:
/dashboard/search. - Help Center search:
/dashboard/help. - Command knowledge base search:
/dashboard/command/knowledge-base. - Most list pages include their own filter/search rows (scoped to that page).
Quick search overlay (Cmd/Ctrl+K)
- Toggle with Cmd+K (macOS) or Ctrl+K (Windows/Linux).
- Uses the same search backend for core categories (KB results appear on the full Search page), capped at 10 results per type.
- Shows quick links when the query is empty.
Global search (basic)
Review category coverage, result ordering, query limits, and access behavior for the fast lookup experience buyers will test first.
Global search (basic)
Review category coverage, result ordering, query limits, and access behavior for the fast lookup experience buyers will test first.
Global search groups results by category and lets you toggle categories on/off. Searches are substring matches over the fields shown below (wildcards are escaped; % and _ are treated as literals).
Query rules and limits
- Minimum query length: 2 characters (ignored when
recent=true). - Maximum query length: 128 characters (longer queries return a validation error).
- Default limit: 10 per type (max 20).
- Results are capped per category (max 20 per category).
- Queries shorter than the minimum return empty results plus
min_query_lengthmetadata. - The Search page starts at 60 per type and "Load more" adds 40 up to 240.
- The API still clamps the per-type limit to 20.
recent=truereturns the most recent items for a singletypeand requirestype.recentaccepts true/false, 1/0, or yes/no (common truthy values:1,true,yes).- If a type is explicitly requested and you lack module/permission access, the API returns 403 instead of a silent empty list.
Result ordering
- Most categories sort by updated_at descending with created_at/id fallbacks (see per-category sort in the table below).
- Knowledge base results sort by relevance for queries and by last_updated for recent mode.
Categories, filters, and defaults
| Category | Matches on | Default filter | Sort order | Result fields | Access | Notes |
|---|---|---|---|---|---|---|
Risks (risks) | title | status NOT IN ('closed','accepted','deleted') | updated_at desc (fallback created_at, id) | id, title, score | module: risk_registerany of: view_risks, manage_risks, edit_risks | - |
Remediations (remediations) | title | status NOT IN ('completed','verified','closed','deleted') | updated_at desc (fallback created_at, id) | id, title, status | module: continuous_complianceany of: view_remediation, manage_remediation | - |
Evidence (evidence) | title | status != 'archived' | updated_at desc (fallback created_at, id) | id, title, category, status | module: continuous_complianceany of: view_evidence, upload_evidence, export_evidence, view_evidence_raw | - |
Evidence requests (evidence_requests) | title | status IN ('open','in_progress') | due_date asc (fallback created_at, id) | id, title, status, due_date | module: continuous_complianceany of: view_evidence, upload_evidence, export_evidence, view_evidence_raw | - |
Vendors (vendors) | name | status != 'deleted' | updated_at desc (fallback created_at, id) | id, name, criticality | module: continuous_complianceany of: view_vendors, view_compliance, manage_compliance | Returns risk_rating or criticality depending on schema. |
Policies (policies) | name | (none) | updated_at desc (fallback created_at, id) | id, name, status | module: continuous_complianceany of: view_policies, acknowledge_policies, approve_policies | - |
Incidents (incidents) | title | status != 'closed' | updated_at desc (fallback created_at, id) | id, title, status, incident_number | module: incident_responseany of: view_incidents, manage_incidents | - |
Assessments (assessments) | type, id, name, title | status NOT IN ('deleted','completed','archived') | updated_at desc (fallback created_at, id) | id, type, status, created_at, name, title | module: continuous_complianceany of: view_assessments, manage_assessments, edit_assessments, edit_assigned_assessments | - |
Support requests (tickets) | subject | status NOT IN ('closed','deleted') | updated_at desc (fallback created_at, id) | id, subject, status, priority | module: ticketsany of: view_tickets, manage_tickets | If you do not have manage_tickets, results are limited to requests you created or are assigned to. |
Command knowledge base (knowledge_base) | id, title, tags, body | (none) | relevance (id > title > tags > body); recent mode sorts by last_updated desc | id, title, slug, excerpt, tags, last_updated | module: commandany of: command.read.kb | Results are scored by matches in id (highest), title, tags, then body text. |
Compliance controls (compliance_controls) | framework_code, control_code, title | is_active = 1 | framework_code asc, sort_order asc, control_code asc (AURORA appended) | framework_code, code, title, category | module: continuous_complianceany of: view_compliance, manage_compliance, view_frameworks, view_tests, view_standards | Also surfaces canonical AURORA controls (id prefixed with AURORA:). |
Aurora controls (aurora_controls) | control_key, title, description, domain, family, tags | (none) | control_key asc | control_key, title, domain, family, severity_default, tags | module: continuous_complianceany of: view_compliance, manage_compliance, view_frameworks, view_tests, view_standards | Searches the Aurora control library (AURORA.*). |
Command knowledge base coverage
Command knowledge base results appear in global search when the Command module is licensed and you have the permission command.read.kb.
Knowledge base search scores matches as follows (highest to lowest): id, title, tags, then body text.
Help Center and Command KB search
- Help Center search filters both built-in help articles and Command KB articles.
- Help Center matches on title, description, and tags; topic filters are exposed via the
tagquery param. - Command KB search matches on title, id, slug, tags, and excerpt.
- Command KB supports category chips (based on the slug prefix) plus sorting by Updated or Title.
Access requirements
Global search requires the view_search or view_dashboard permission. Each category also enforces module licensing plus the permissions listed above.
Advanced search (AQL)
Validate the query syntax, operators, pipelines, and admin controls behind deeper reporting and automation use cases.
Advanced search (AQL)
Validate the query syntax, operators, pipelines, and admin controls behind deeper reporting and automation use cases.
Advanced search runs AQL against a single dataset at a time and is available in the Search page (Advanced toggle) and the Report Builder.
Access and availability
- Permission required:
advanced_search. - Admins can enable/disable and set limits in Settings -> Aurora -> Integrations -> Advanced Search.
- If
allowed_sourcesis set, only sources explicitly markedtrueare available. - AQL queries are queued by default; the UI shows queued/processing/completed status.
Filter syntax
Use explicit boolean operators (AND, OR, NOT) and parentheses for grouping.
| Operator | Behavior |
|---|---|
: | Substring match (SQL LIKE). Use comparison operators for numeric/date fields. |
= | Exact match. |
!= | Not equal. |
> | Greater than (numbers/dates). |
>= | Greater than or equal (numbers/dates). |
< | Less than (numbers/dates). |
<= | Less than or equal (numbers/dates). |
Additional filter notes:
- Fieldless terms search across the dataset's searchable fields.
- Use quotes for values with spaces (e.g., owner:"Jane Doe").
field:nullmatches null values.field:*matches any non-null value.- Boolean fields accept
true/falseor1/0.
Pipeline commands
Pipeline commands are appended with | and run in order after the base filters.
| Command | Purpose |
|---|---|
search <expr> | Apply an additional filter expression after the base query. |
where <expr> | Filter rows after eval is applied (same syntax as base filters). |
fields a,b,c | Select output fields (alias: table). |
sort field | Sort ascending by field. Use -field or 'desc' for descending. |
limit N | Limit rows (alias: head). |
stats count | Aggregate results (count, sum(field), avg(field), min(field), max(field)). |
stats count by field | Breakdown by a single group-by field (only one field supported). |
eval field=if(cond,then,else) | Compute a field using if() (only if() is supported). |
Pipeline notes:
searchandwhereapply aftereval(post-filtering the returned rows).statsswitches the output to KPI/breakdown mode and ignoresfields,eval, andwhere.
Result modes
table: default mode. Returns rows and columns metadata.kpi:stats countor aggregate withoutby. Returnsmetrics.value.breakdown:stats ... by <field>. Returnsrowsof{ label, value }plusmeta.group_by.- All modes include
metawithsource,mode,query,limit, andexecution_ms.
Examples
status:open AND severity:high | sort -updated_at | limit 25
owner:"Jane Doe" AND score>=7 | fields id,title,status,score,updated_at
framework_code:ISO27001 | stats count by category
title:"Access Review" | eval priority=if(score>=8,"High","Medium") | where priority:High
Settings and limits (defaults)
| Setting | Default | Range | Notes |
|---|---|---|---|
| enabled | true | true/false | Master toggle for AQL (admin setting). |
| allow_pipes | true | true/false | Enables pipeline commands (| sort, | stats, etc). |
| allow_eval | true | true/false | Allows eval with if(). |
| require_filter | true | true/false | Base query must include at least one filter. |
| max_query_length | 512 | 64-4096 | Maximum query length (characters). |
| max_pipes | 6 | 1-25 | Maximum pipeline commands per query. |
| max_rows | 200 | 25-2000 | Maximum rows returned per query. |
| max_group_by | 50 | 5-500 | Maximum rows returned for stats breakdowns. |
| max_fields | 12 | 3-50 | Maximum fields returned in table mode. |
| max_execution_ms | 1500 | 200-10000 | Execution time budget (ms). |
| max_queue_depth | 4 | 1-50 | Maximum queued AQL jobs per org. |
| allowed_sources | all | source keys | Optional allow-list. If set, only sources marked true are available. |
Advanced search datasets and fields
Inspect the available sources, searchable fields, and default metadata before building queries or integrations.
Advanced search datasets and fields
Inspect the available sources, searchable fields, and default metadata before building queries or integrations.
Each AQL source exposes the fields listed below. Fieldless terms use the dataset's searchable fields.
Risks (risks)
Module: risk_register
Any of: view_risks, manage_risks, edit_risks
Mode: sql
Table: risks
Org column: organization_id
Default filter: status NOT IN ('closed','accepted','deleted')
Default sort: updated_at desc
Searchable fields: title, description, category, owner
Default fields: id, title, status, score, owner, due_date, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
title | Title | string | yes |
status | Status | string | - |
category | Category | string | yes |
owner | Owner | string | yes |
likelihood | Likelihood | string | - |
impact | Impact | string | - |
score | Score | number | - |
due_date | Due date | date | - |
created_at | Created at | date | - |
updated_at | Updated at | date | - |
Vendors (vendors)
Module: continuous_compliance
Any of: view_vendors, view_compliance, manage_compliance
Mode: sql
Table: vendors
Org column: organization_id
Default filter: status != 'deleted'
Default sort: updated_at desc
Searchable fields: name, category, subcategory, description, risk_rating
Default fields: id, name, status, risk_rating, category, next_review_date, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
name | Name | string | yes |
status | Status | string | - |
category | Category | string | yes |
subcategory | Subcategory | string | yes |
risk_rating | Risk rating | string | yes |
is_critical_system | Critical | boolean | - |
contract_value | Contract value | number | - |
next_review_date | Next review | date | - |
updated_at | Updated at | date | - |
Evidence (evidence)
Module: continuous_compliance
Any of: view_evidence, upload_evidence, export_evidence, view_evidence_raw
Mode: sql
Table: evidence_items
Org column: organization_id
Default filter: status != 'archived'
Default sort: updated_at desc
Searchable fields: title, category, description, filename
Default fields: id, title, category, status, valid_until, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
title | Title | string | yes |
category | Category | string | yes |
status | Status | string | - |
filename | Filename | string | yes |
valid_from | Valid from | date | - |
valid_until | Valid until | date | - |
updated_at | Updated at | date | - |
Evidence requests (evidence_requests)
Module: continuous_compliance
Any of: view_evidence, upload_evidence, export_evidence, view_evidence_raw
Mode: sql
Table: evidence_requests
Org column: organization_id
Default filter: status IN ('open','in_progress')
Default sort: due_date asc
Searchable fields: title, category, framework_code, control_code
Default fields: id, title, status, due_date, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
title | Title | string | yes |
status | Status | string | - |
category | Category | string | yes |
framework_code | Framework | string | yes |
control_code | Control | string | yes |
due_date | Due date | date | - |
updated_at | Updated at | date | - |
Policies (policies)
Module: continuous_compliance
Any of: view_policies, acknowledge_policies, approve_policies
Mode: sql
Table: organization_policies
Org column: organization_id
Default filter: -
Default sort: updated_at desc
Searchable fields: name, status
Default fields: id, name, status, review_date, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
name | Name | string | yes |
status | Status | string | yes |
version | Version | number | - |
effective_date | Effective date | date | - |
review_date | Review date | date | - |
updated_at | Updated at | date | - |
Remediation items (remediations)
Module: continuous_compliance
Any of: view_remediation, manage_remediation
Mode: sql
Table: remediation_items
Org column: organization_id
Default filter: status NOT IN ('completed','verified','closed','deleted')
Default sort: updated_at desc
Searchable fields: title, description, severity, priority, status
Default fields: id, title, status, priority, assigned_to, due_date, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
title | Title | string | yes |
status | Status | string | yes |
severity | Severity | string | yes |
priority | Priority | string | yes |
assigned_to | Assigned to | number | - |
due_date | Due date | date | - |
updated_at | Updated at | date | - |
Incidents (incidents)
Module: incident_response
Any of: view_incidents, manage_incidents
Mode: sql
Table: incidents
Org column: organization_id
Default filter: status != 'closed'
Default sort: updated_at desc
Searchable fields: title, incident_number, severity, status, event_type
Default fields: id, incident_number, title, status, severity, reported_at, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
incident_number | Incident # | string | yes |
title | Title | string | yes |
status | Status | string | yes |
severity | Severity | string | yes |
event_type | Event type | string | yes |
reported_at | Reported at | date | - |
updated_at | Updated at | date | - |
Assessments (assessments)
Module: continuous_compliance
Any of: view_assessments, manage_assessments, edit_assessments, edit_assigned_assessments
Mode: sql
Table: assessments
Org column: organization_id
Default filter: status NOT IN ('deleted','completed','archived')
Default sort: updated_at desc
Searchable fields: type, assessment_type, status
Default fields: id, type, status, assessment_type, created_at, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
type | Type | string | yes |
assessment_type | Assessment type | string | yes |
status | Status | string | yes |
score | Score | number | - |
created_at | Created at | date | - |
updated_at | Updated at | date | - |
Support tickets (tickets)
Module: tickets
Any of: view_tickets, manage_tickets
Mode: sql
Table: tickets
Org column: organization_id
Default filter: status NOT IN ('closed','deleted')
Default sort: updated_at desc
Searchable fields: subject, status, priority, category
Default fields: id, ticket_number, subject, status, priority, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
ticket_number | Ticket # | string | - |
subject | Subject | string | yes |
status | Status | string | yes |
priority | Priority | string | yes |
category | Category | string | yes |
assigned_to | Assigned to | number | - |
created_at | Created at | date | - |
updated_at | Updated at | date | - |
Compliance controls (compliance_controls)
Module: continuous_compliance
Any of: view_compliance, manage_compliance, view_frameworks, view_tests, view_standards
Mode: sql
Table: compliance_controls
Default filter: -
Default sort: framework_code asc
Searchable fields: framework_code, control_code, title, category
Default fields: framework_code, control_code, title, category
| Field | Label | Type | Searchable |
|---|---|---|---|
framework_code | Framework | string | yes |
control_code | Control code | string | yes |
title | Title | string | yes |
category | Category | string | yes |
Aurora controls (aurora_controls)
Module: continuous_compliance
Any of: view_compliance, manage_compliance, view_frameworks, view_tests, view_standards
Mode: memory
Default filter: -
Default sort: -
Searchable fields: control_key, title, description, domain, family, tags
Default fields: control_key, title, domain, family, severity_default
| Field | Label | Type | Searchable |
|---|---|---|---|
control_key | Control key | string | yes |
title | Title | string | yes |
description | Description | string | yes |
domain | Domain | string | yes |
family | Family | string | yes |
severity_default | Severity | string | - |
tags | Tags | string | yes |
Compliance frameworks (frameworks)
Module: continuous_compliance
Any of: view_frameworks, view_tests, view_standards, view_compliance, manage_compliance
Mode: memory
Default filter: -
Default sort: -
Searchable fields: framework_key, code, name, publisher, type, status, tags, industries, jurisdictions
Default fields: framework_key, code, name, version, publisher, status, requirements_count
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
framework_key | Framework key | string | yes |
code | Code | string | yes |
name | Name | string | yes |
version | Version | string | - |
publisher | Publisher | string | yes |
type | Type | string | yes |
status | Status | string | yes |
requirements_count | Requirements | number | - |
tags | Tags | string | yes |
industries | Industries | string | yes |
jurisdictions | Jurisdictions | string | yes |
source_url | Source URL | string | - |
mapping_template_last_modified | Template updated | date | - |
Compliance tests (tests)
Module: continuous_compliance
Any of: view_tests, view_frameworks, view_standards, view_compliance, manage_compliance
Mode: memory
Default filter: -
Default sort: -
Searchable fields: id, title, description, severity, category, category_label, resource_type, assertion_types, event_triggers
Default fields: id, title, severity, category_label, resource_type, schedule_interval
| Field | Label | Type | Searchable |
|---|---|---|---|
id | Test ID | string | yes |
title | Title | string | yes |
description | Description | string | yes |
severity | Severity | string | yes |
category | Category | string | yes |
category_label | Category label | string | yes |
resource_type | Resource type | string | yes |
mode | Mode | string | - |
schedule_interval | Schedule interval | string | - |
assertion_types | Assertion types | string | yes |
event_triggers | Event triggers | string | yes |
evidence_artifact_types | Evidence artifacts | string | - |
Training modules (training_modules)
Module: practice
Any of: view_training, manage_training, assign_training
Mode: sql
Table: training_modules
Default filter: is_active = 1
Default sort: updated_at desc
Searchable fields: title, category, description
Default fields: id, title, category, duration_minutes, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
title | Title | string | yes |
category | Category | string | yes |
duration_minutes | Duration (min) | number | - |
is_required | Required | boolean | - |
updated_at | Updated at | date | - |
User training (user_training)
Module: practice
Any of: view_training, manage_training, assign_training
Mode: sql
Table: user_training
Org column: organization_id
Default filter: -
Default sort: updated_at desc
Searchable fields: status
Default fields: id, user_id, module_id, status, completed_at, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
user_id | User ID | number | - |
module_id | Module ID | string | - |
status | Status | string | yes |
completed_at | Completed at | date | - |
updated_at | Updated at | date | - |
Command devices (command_devices)
Module: command
Any of: command.read.devices, command.read.overview, command.read.coverage, command.read.telemetry
Mode: sql
Table: command_devices
Org column: organization_id
Default filter: -
Default sort: updated_at desc
Searchable fields: name, vendor, product, telemetry_status, data_quality_verdict
Default fields: id, name, telemetry_status, data_quality_verdict, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
name | Name | string | yes |
vendor | Vendor | string | yes |
product | Product | string | yes |
telemetry_status | Telemetry | string | yes |
data_quality_verdict | Data quality | string | yes |
discovery_status | Discovery | string | - |
updated_at | Updated at | date | - |
Command collectors (command_collectors)
Module: command
Any of: command.read.collectors, command.read.overview, command.read.integrations
Mode: sql
Table: command_collectors
Org column: organization_id
Default filter: -
Default sort: updated_at desc
Searchable fields: name, status, collector_type
Default fields: id, name, collector_type, status, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
name | Name | string | yes |
collector_type | Type | string | yes |
status | Status | string | yes |
updated_at | Updated at | date | - |
Command integrations (command_integrations)
Module: command
Any of: command.read.integrations, command.read.overview
Mode: sql
Table: command_integrations
Org column: organization_id
Default filter: -
Default sort: updated_at desc
Searchable fields: display_name, integration_type, status
Default fields: id, display_name, integration_type, status, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
display_name | Name | string | yes |
integration_type | Type | string | yes |
status | Status | string | yes |
updated_at | Updated at | date | - |
Command knowledge base (knowledge_base)
Module: command
Any of: command.read.kb
Mode: memory
Default filter: -
Default sort: -
Searchable fields: id, title, slug, excerpt, tags, applicable_vendors, related_pages
Default fields: title, excerpt, tags, last_updated, slug
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | yes |
title | Title | string | yes |
slug | Slug | string | yes |
excerpt | Excerpt | string | yes |
tags | Tags | string | yes |
last_updated | Last updated | date | - |
applicable_vendors | Applicable vendors | string | yes |
related_pages | Related pages | string | yes |
Message threads (message_threads)
Module: messages
Any of: view_messages, manage_messages
Mode: sql
Table: message_threads
Org column: organization_id
Default filter: -
Default sort: last_message_at desc
Searchable fields: subject, thread_type
Default fields: id, subject, thread_type, last_message_at, created_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
subject | Subject | string | yes |
thread_type | Thread type | string | yes |
created_by | Created by | number | - |
last_message_at | Last message | date | - |
created_at | Created at | date | - |
updated_at | Updated at | date | - |
Aurora sessions (chat_sessions)
Module: talk_to_aurora
Any of: aurora.use
Mode: sql
Table: chat_sessions
Org column: organization_id
Default filter: created_by_viewer_id IS NULL
Default sort: updated_at desc
Searchable fields: title, scope_type
Default fields: id, title, scope_type, status, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
title | Title | string | yes |
scope_type | Scope | string | yes |
scope_id | Scope ID | string | - |
status | Status | string | - |
created_by_user_id | Created by | number | - |
created_at | Created at | date | - |
updated_at | Updated at | date | - |
Practice scenarios (practice_scenarios)
Module: practice
Any of: view_practice, manage_practice, facilitate_practice
Mode: sql
Table: practice_scenarios
Org column: organization_id
Default filter: -
Default sort: updated_at desc
Searchable fields: title, description, difficulty
Default fields: id, title, difficulty, status, updated_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
title | Title | string | yes |
description | Description | string | yes |
difficulty | Difficulty | string | yes |
status | Status | string | - |
created_at | Created at | date | - |
updated_at | Updated at | date | - |
Practice sessions (practice_sessions)
Module: practice
Any of: view_practice, manage_practice, facilitate_practice
Mode: sql
Table: practice_sessions
Org column: organization_id
Default filter: -
Default sort: scheduled_start_at desc
Searchable fields: status, scenario_id
Default fields: id, scenario_id, status, scheduled_start_at, scheduled_end_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
scenario_id | Scenario ID | string | yes |
status | Status | string | yes |
facilitator_user_id | Facilitator | number | - |
scheduled_start_at | Scheduled start | date | - |
scheduled_end_at | Scheduled end | date | - |
started_at | Started at | date | - |
ended_at | Ended at | date | - |
created_at | Created at | date | - |
updated_at | Updated at | date | - |
Phishing campaigns (phish_campaigns)
Module: phishing
Any of: view_phishing, manage_phishing, launch_phishing
Mode: sql
Table: phish_campaigns
Org column: organization_id
Default filter: -
Default sort: created_at desc
Searchable fields: name, description, status
Default fields: id, name, status, start_at, end_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
name | Name | string | yes |
description | Description | string | yes |
status | Status | string | yes |
start_at | Start | date | - |
end_at | End | date | - |
created_at | Created at | date | - |
updated_at | Updated at | date | - |
Leaderboard stats (gamification_user_stats)
Module: leaderboard
Any of: view_gamification, manage_gamification
Mode: sql
Table: gamification_user_stats
Org column: organization_id
Default filter: -
Default sort: total_points desc
Searchable fields: -
Default fields: user_id, total_points, current_level, current_streak_days, longest_streak_days
| Field | Label | Type | Searchable |
|---|---|---|---|
user_id | User ID | number | - |
total_points | Total points | number | - |
current_level | Level | number | - |
current_streak_days | Current streak | number | - |
longest_streak_days | Longest streak | number | - |
last_activity_date | Last activity | date | - |
updated_at | Updated at | date | - |
Trust Center access requests (tc_access_requests)
Module: trust_center
Any of: trust_center:admin, trust_center:approve, trust_center:messages, trust_center:analytics_read, trust_center:legal_admin
Mode: sql
Table: tc_access_requests
Org column: organization_id
Default filter: -
Default sort: requested_at desc
Searchable fields: requester_email, requester_name, company, status
Default fields: id, requester_email, company, status, requested_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
trust_center_id | Trust Center ID | string | - |
requester_email | Requester email | string | yes |
requester_name | Requester name | string | yes |
company | Company | string | yes |
status | Status | string | yes |
approval_source | Approval source | string | - |
requested_at | Requested at | date | - |
decided_at | Decided at | date | - |
expires_at | Expires at | date | - |
updated_at | Updated at | date | - |
Trust Center message threads (tc_message_threads)
Module: trust_center
Any of: trust_center:admin, trust_center:approve, trust_center:messages, trust_center:analytics_read, trust_center:legal_admin
Mode: sql
Table: tc_message_threads
Org column: organization_id
Default filter: -
Default sort: last_message_at desc
Searchable fields: subject, category, status, priority
Default fields: id, trust_center_id, subject, status, priority, last_message_at
| Field | Label | Type | Searchable |
|---|---|---|---|
id | ID | string | - |
trust_center_id | Trust Center ID | string | - |
viewer_id | Viewer ID | string | - |
subject | Subject | string | yes |
category | Category | string | yes |
status | Status | string | yes |
priority | Priority | string | yes |
assigned_to_user_id | Assigned to | number | - |
last_message_at | Last message | date | - |
updated_at | Updated at | date | - |
API reference
Review the exact endpoints behind search lookup, queued AQL, job status polling, and source discovery.
API reference
Review the exact endpoints behind search lookup, queued AQL, job status polling, and source discovery.
These endpoints power the search UI:
GET /search.php?q=<query>&limit=<1-20>&type=<optional>&recent=<optional>
POST /advanced-search.php?action=enqueue { source, query, limit?, delay_seconds? }
GET /advanced-search.php?action=status&job_id=<id>
GET /advanced-search.php?action=sources
GET /advanced-search.php?action=catalog (admin only)
POST /advanced-search.php?action=execute { source, query, limit? }
Notes:
recent=truereturns the most recent items for a singletypeand requirestype.- Advanced search is rate-limited (30 requests per minute per user/org, when rate limiting is enabled).
- Queued AQL jobs respect max queue depth and may return QUEUE_BUSY when saturated.
sourcesreturns only licensed and permitted sources (and respectsallowed_sources).catalogincludes policy/licensing metadata and requiresmanage_settings.statusreturns cached results when available; completed jobs without cache return an expiry error.
Troubleshooting
Use the common failure modes to understand how search behaves under licensing, permissions, and query-validation constraints.
Troubleshooting
Use the common failure modes to understand how search behaves under licensing, permissions, and query-validation constraints.
- If you see 'Setup required' in Search, complete the Setup Guide and retry.
- If a category is missing, check module licensing and permissions.
- For compliance controls, search by control code (e.g., AURORA.AC.MFA) or framework code.
- If AQL returns 'Query requires at least one filter', add a base filter or disable the requirement in settings.