# DQL parse command - help with correct syntax

**URL:** <https://community.dynatrace.com/t/dql-parse-command-help-with-correct-syntax/49821>\
**Category:** DQL\
**Tags:** dql, dpl\
**Created:** [January 20, 2025, 12:41pm UTC](https://community.dynatrace.com/t/dql-parse-command-help-with-correct-syntax/49821 "2025-01-20T12:41:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AlanFoley](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@AlanFoley](https://community.dynatrace.com/u/AlanFoley)\
**Post date:** [January 20, 2025, 12:41pm UTC](https://community.dynatrace.com/t/dql-parse-command-help-with-correct-syntax/49821/1 "2025-01-20T12:41:37Z")

</div>

Hi all

I have this DQL using the parse command (LD) - in my view it should work- PGI data is returned but not split into columns as per the parse command  
I am just parsing the column “softwareTechnologies” which contains a string/value similar to this “type:SPRING,edition:Spring Boot,version:2.7.5”

fetch dt.entity.process\_group\_instance  
| fieldsAdd softwareTechnologies  
| filter matchesPhrase(entity.name, “SpringBoot”)  
| expand softwareTechnologies  
| filter matchesPhrase(softwareTechnologies, “type:SPRING”)  
| parse softwareTechnologies, “LD ‘type:’ LD:softwareTechnologies.type ‘,edition:’ LD:softwareTechnologies.edition ‘,version:’ LD:softwareTechnologies.version”

I have used a similar DQL parse command succesfully  
Am i missing something?

Appreciate any help

Thanks Alan

---

<div class="post-metadata">

**Author:** ![Etienne1](https://avatars.discourse-cdn.com/v4/letter/e/278dde/32.png) [@Etienne1](https://community.dynatrace.com/u/Etienne1)\
**Post date:** [January 20, 2025, 1:21pm UTC](https://community.dynatrace.com/t/dql-parse-command-help-with-correct-syntax/49821/2 "2025-01-20T13:21:29Z")

</div>

Hello,

maybe i am incorrect but you should remove the first LD

 ![Etienne1_1-1737379273940.png](https://global.discourse-cdn.com/dynatrace/original/3X/9/4/943d86fb4522dc992502f178e18b968c027fe691.png)

```auto
fetch dt.entity.process_group_instance<br>| fieldsAdd softwareTechnologies<br>| filter matchesPhrase(entity.name, "SpringBoot")<br>| expand softwareTechnologies<br>| filter matchesPhrase(softwareTechnologies, "type:SPRING")<br>| parse softwareTechnologies, "'type:' LD:softwareTechnologies.type ',edition:' LD:softwareTechnologies.edition ',version:' LD:softwareTechnologies.version"

```

---

<div class="post-metadata">

**Author:** ![AlanFoley](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@AlanFoley](https://community.dynatrace.com/u/AlanFoley)\
**Post date:** [January 21, 2025, 4:11am UTC](https://community.dynatrace.com/t/dql-parse-command-help-with-correct-syntax/49821/3 "2025-01-21T04:11:54Z")

</div>

Hi&nbsp;Etienne

A case of me not being able to see the wood for the trees&nbsp;:joy:

Works - appreciate you taking the time to test

Regards

Alan