# DQL parse issue

**URL:** <https://community.dynatrace.com/t/dql-parse-issue/52507>\
**Category:** DQL\
**Tags:** dql, parse\
**Created:** [July 16, 2025, 2:22pm UTC](https://community.dynatrace.com/t/dql-parse-issue/52507 "2025-07-16T14:22:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ramchandgadde](https://avatars.discourse-cdn.com/v4/letter/r/9de0a6/32.png) [@ramchandgadde](https://community.dynatrace.com/u/ramchandgadde)\
**Post date:** [July 16, 2025, 2:22pm UTC](https://community.dynatrace.com/t/dql-parse-issue/52507/1 "2025-07-16T14:22:53Z")

</div>

Below are details that I tried for fetching and building dashboard in Dynatrace. For DQL I am using parse option. The problem with it is , the parse function somehow is not fetching all rows.

Do we have any other options, would you review below query suggest working option?

\*\*[u]

Data Log:[/u]\*\*

[INFO][EAP\_WORKDAY][DYNATRACE] 2025-07-16 12:45:23.999 Merged\_Response [{‘Integration\_Platform’: ‘DB\_BATCH’, ‘Integration\_Process’: ‘ATLAS\_16076\_9885bc5832094b06bfc2572009db68d9’, ‘Process\_Type’: None, ‘Status’: ‘ERROR’, ‘Start\_Date\_and\_Time’: None, ‘WorkdayID’: None, ‘End\_Date\_and\_Time’: ‘00:00:00’, ‘Acc\_Center\_Batch\_ID’: ‘16076’}, {‘Integration\_Platform’: ‘DB\_BATCH’, ‘Integration\_Process’: ‘ATLAS\_16027\_4c323fff6e354e76927f38dd8b9f97b9’, ‘Process\_Type’: ‘DB’, ‘Status’: ‘COMPLETED’, ‘Start\_Date\_and\_Time’: ‘2025-07-16T07:18:14.937240Z’, ‘WorkdayID’: None, ‘End\_Date\_and\_Time’: ‘00:00:06’, ‘Acc\_Center\_Batch\_ID’: ‘16027’}, {‘Integration\_Platform’: ‘DB\_NOTIFIER’, ‘Integration\_Process’: ‘ATLAS\_16027\_4c323fff6e354e76927f38dd8b9f97b9’, ‘Process\_Type’: ‘DB’, ‘Status’: ‘COMPLETED’, ‘Start\_Date\_and\_Time’: ‘2025-07-16T07:19:30.785763Z’, ‘WorkdayID’: None, ‘End\_Date\_and\_Time’: ‘00:00:06’, ‘Acc\_Center\_Batch\_ID’: ‘16027’}, {‘Integration\_Platform’: ‘DB\_BATCH’, ‘Integration\_Process’: ‘ATLAS\_16101\_7b97e61e32804f7f86c81cd926e7d989’, ‘Process\_Type’: ‘DB’, ‘Status’: ‘COMPLETED’, ‘Start\_Date\_and\_Time’: ‘2025-07-16T07:20:28.723717Z’, ‘WorkdayID’: None, ‘End\_Date\_and\_Time’: ‘00:00:02’, ‘Acc\_Center\_Batch\_ID’: ‘16101’}, {‘Integration\_Platform’: ‘DB\_NOTIFIER’, ‘Integration\_Process’: ‘ATLAS\_16101\_7b97e61e32804f7f86c81cd926e7d989’, ‘Process\_Type’: ‘DB’, ‘Status’: ‘COMPLETED’, ‘Start\_Date\_and\_Time’: ‘2025-07-16T07:21:03.272498Z’, ‘WorkdayID’: None, ‘End\_Date\_and\_Time’: ‘00:00:01’, ‘Acc\_Center\_Batch\_ID’: ‘16101’}, {‘Integration\_Platform’: ‘DB\_BATCH’, ‘Integration\_Process’: ‘ATLAS\_15972\_328a4276cca3494b9040054cac506b83’, ‘Process\_Type’: None, ‘Status’: ‘COMPLETED’, ‘Start\_Date\_and\_Time’: None, ‘WorkdayID’: None, ‘End\_Date\_and\_Time’: ‘00:00:00’, ‘Acc\_Center\_Batch\_ID’: ‘15972’}, {‘Integration\_Platform’: ‘DB\_BATCH’, ‘Integration\_Process’: ‘ATLAS\_15981\_d88dea264ae74fa6a4d0fb238d68d113’, ‘Process\_Type’: ‘DB’, ‘Status’: ‘COMPLETED’, ‘Start\_Date\_and\_Time’: ‘2025-07-16T07:18:23.535363Z’, ‘WorkdayID’: None, ‘End\_Date\_and\_Time’: ‘00:00:03’, ‘Acc\_Center\_Batch\_ID’: ‘15981’}, {‘Integration\_Platform’: ‘DB\_NOTIFIER’, ‘Integration\_Process’: ‘ATLAS\_15981\_d88dea264ae74fa6a4d0fb238d68d113’, ‘Process\_Type’: ‘DB’, ‘Status’: ‘COMPLETED’, ‘Start\_Date\_and\_Time’: ‘2025-07-16T07:19:33.355444Z’, ‘WorkdayID’: None, ‘End\_Date\_and\_Time’: ‘00:00:04’, ‘Acc\_Center\_Batch\_ID’: ‘15981’}]

**Dynatrace Query**

fetch logs, from:-4h

| filter contains(content, “Merged\_Response”)

| parse content, “”“LD ‘Status\’: \‘’ WORD:Status LD ‘Process\_Type\’: \‘’ WORD:Process\_Type LD ‘Integration\_Process\’: \‘’ WORD:Integration\_Process LD ‘Integration\_Platform\’: \‘’ WORD:Integration\_Platform LD ‘Start\_Date\_and\_Time\’: \‘’ TIMESTAMP(“yyyy-MM-dd’T’HH:mm:ss”):Start\_Date\_and\_Time LD ‘End\_Date\_and\_Time\’: \‘’ TIMESTAMP(“yyyy-MM-dd’T’HH:mm:ss”):End\_Date\_and\_Time”“”

| filter isnotnull(Status) and isnotnull(Process\_Type) and isnotnull(Integration\_Process) and isnotnull(Start\_Date\_and\_Time)

| fields Process\_Type, Integration\_Process, Integration\_Platform, Status,Start\_Date\_and\_Time,End\_Date\_and\_Time

---

<div class="post-metadata">

**Author:** ![GerardJ](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/gerardj/32/154_2.png) [@GerardJ](https://community.dynatrace.com/u/GerardJ)\
**Post date:** [July 17, 2025, 7:25am UTC](https://community.dynatrace.com/t/dql-parse-issue/52507/2 "2025-07-17T07:25:29Z")

</div>

Hi&nbsp;[@ramchandgadde](https://community.dynatrace.com/user/93291)&nbsp;  
Your data sample made me think of a JSON Array, so I tried this :

```markup
| parse content, """LD "Merged_Response " JSON_ARRAY(strict=false):array"""
| expand array

```

With that I get a record for each array member, like this :

 ![GerardJ_0-1752736921619.png](https://global.discourse-cdn.com/dynatrace/original/3X/b/e/be26833c1d182199d3d4d41408861aa13e6a0905.png)

depending on your use case, that can be helpful