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

**URL:** <https://community.dynatrace.com/t/no-records-update-with-string-pending-execution/53462>\
**Category:** DQL\
**Tags:** dql, dynatrace-managed\
**Created:** [September 23, 2025, 2:13pm UTC](https://community.dynatrace.com/t/no-records-update-with-string-pending-execution/53462 "2025-09-23T14:13:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![O11y\_Noob](https://avatars.discourse-cdn.com/v4/letter/o/9fc348/32.png) [@O11y\_Noob](https://community.dynatrace.com/u/O11y_Noob)\
**Post date:** [September 23, 2025, 2:13pm UTC](https://community.dynatrace.com/t/no-records-update-with-string-pending-execution/53462/1 "2025-09-23T14:13:29Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![t\_pawlak](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/t_pawlak/32/14991_2.png) [@t\_pawlak](https://community.dynatrace.com/u/t_pawlak)\
**Post date:** [September 23, 2025, 8:11pm UTC](https://community.dynatrace.com/t/no-records-update-with-string-pending-execution/53462/2 "2025-09-23T20:11:08Z")

</div>

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):

```markup
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:

```markup
--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.

---

<div class="post-metadata">

**Author:** ![Akhil-Jayendran](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/akhil-jayendran/32/153_2.png) [@Akhil-Jayendran](https://community.dynatrace.com/u/Akhil-Jayendran)\
**Post date:** [September 23, 2025, 10:21pm UTC](https://community.dynatrace.com/t/no-records-update-with-string-pending-execution/53462/3 "2025-09-23T22:21:38Z")

</div>

Hi&nbsp;[@O11y\_Noob](https://community.dynatrace.com/user/85826)&nbsp;,

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.

 ![Screenshot 2025-09-23 at 5.16.49 PM.png](https://global.discourse-cdn.com/dynatrace/original/3X/c/d/cd08cc2629b6d917be11429b6f5379ee7ee6f684.png)