topic Re: "No Records" - update with string "pending execution" in DQL

"No Records" - update with string "pending execution"

O11y_Noob — Tue, 23 Sep 2025 14:13:29 GMT

our DQL returns the metric which is end time of a job and updated only once a day, if the job is not completed - DQL is returning no records as result , is it possible to show static value like "pending execution" instead of no records.

Re: "No Records" - update with string "pending execution"

t_pawlak — Tue, 23 Sep 2025 20:11:08 GMT

I couldn’t find a way to achieve this directly in DQL

But i think is possible workaround is to emit a daily status as a metric or business event. For example:

Emit a daily status

In the morning send an event/metric like job.status = pending.

When the job finishes send job.status = completed
This way the dashboard query always has at least one record, so you won’t see “No records”.
Example using metric ingestion v2 (0 = pending, 1 = completed):

curl -X POST "$DT_URL/api/v2/metrics/ingest" \ -H "Authorization: Api-Token $DT_TOKEN" \ -H "Content-Type: text/plain" \ --data-binary "custom.job.status,job=myJob gauge,0"

and after completion:

--data-binary "custom.job.status,job=myJob gauge,1"

Then
Handle it at the dashboard/UI layer

If the visualization type supports it, configure the “No data” behavior to display a custom message (e.g. pending execution).

If that’s not available, you can place a Markdown tile with a static message next to it, or use thresholds/colors on a 0/1 metric to display pending vs. completed.

Re: "No Records" - update with string "pending execution"

Akhil-Jayendran — Tue, 23 Sep 2025 22:21:38 GMT

Hi @O11y_Noob ,

If your DQL query returns a job name but the end time is null, you can use an if-else statement to add your string as shown below.