DQL parse command - help with correct syntax

Platform DQL
,
1

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

2

Hello,

maybe i am incorrect but you should remove the first LD

Etienne1_1-1737379273940.png
Etienne1_1-1737379273940.png1454×731 128 KB

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"
3

Hi Etienne

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

Works - appreciate you taking the time to test

Regards

Alan