Query OWS model data — resolves process prefix, discovers fields, builds and runs TQL. Use when asked about tickets, CMs, INCs, BOTs, or any process data.
Instalación
Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.
Query OWS model data — resolves process prefix, discovers fields, builds and runs TQL. Use when asked about tickets, CMs, INCs, BOTs, or any process data.
OWS Query Skill
Steps
Resolve the process — use resolve_process_by_prefix with the ticket prefix (CM, INC, BOT, TTS, etc.) to get tickets_uri.
Discover fields — if the query needs a field you're unsure about, use get_model_fields(asset_uri=tickets_uri) to find the exact field name. Field names are snake_case and may differ from their display labels (e.g. createtime not createTime).
Build TQL — use this syntax:
select * from "<tickets_uri>" as t where <conditions> order by t.<field> desc limit <N>
Always quote the asset URI with double quotes
Always alias the model (e.g. as t)
Use t.<fieldname> for ordering and filtering
Run the query — use query_model_data(tenant, tql). It validates before executing.
Present results — extract and show only the relevant fields in a table. Don't dump all 200+ fields.
Common Fields
Field
Meaning
createtime
When the ticket was created
lastupdatetime
Last update
ticketstatus
running / closed / aborted
task_status
dispatched / accepted / completed
orderidview
Human-readable ticket ID
title
Ticket title
region
Geographic region
site_id_name
Site ID
assign_to_fme_full
Assigned engineer name
fault_type
Wireless / Transmission / Power
Notes
Always use tenant: "prod" for real data unless the user says testbed
If TQL fails with "field not recognized", re-check field name via get_model_fields
For top-N newest, use order by t.createtime desc limit N
For filtering by date: t.createtime >= '2026-05-20 00:00:00'
