Write HQL

Write, validate, and run HQL queries against Harness data, primarily for dashboard widget creation. This skill teaches the query language, the type discovery workflow, and the validation loop. For non-dashboard multi-query analysis (overview, drill-down, synthesis), also follow analysis-workflow.md.

Instructions

Step 0: Learn HQL syntax

Read the companion files in this skill directory before writing any queries:

• reference.md — practical examples, type casting rules, JOIN syntax, anti-patterns.
• references/patterns/*.md — worked query patterns per question shape (failure-diagnosis, build-time-analysis, bottleneck-analysis, flakiness, retry-signals, intermittent-vs-consistent, lint-first, batch).
• references/entity-reference/ci.md — CI-native field discipline (stage_build_time vs duration, start_timestamp vs start_ts).

Fetch the live grammar via harness_get(resource_type='kg_grammar') only when the reference files do not cover the syntax you need.

Step 1: Discover queryable types (summaries only)