DQL parse command - help with correct syntax

[AlanFoley]

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

[Etienne1 · Accepted solution]

Hello, 

maybe i am incorrect but you should remove the first LD

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

[AlanFoley]

Hi Etienne

A case of me not being able to see the wood for the trees 😂

Works - appreciate you taking the time to test

Regards

Alan