cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

DQL parse command - help with correct syntax

AlanFoley
Participant

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 REPLIES 2

Etienne1
Helper

Hello, 

maybe i am incorrect but you should remove the first LD

Etienne1_1-1737379273940.png

 

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"

 

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

Featured Posts