topic DQL parse command - help with correct syntax in DQL

DQL parse command - help with correct syntax

AlanFoley — Tue, 21 Jan 2025 06:59:02 GMT

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

Re: DQL parse command - help with correct syntax

Etienne1 — Mon, 20 Jan 2025 13:21:29 GMT

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"

Re: DQL parse command - help with correct syntax

AlanFoley — Tue, 21 Jan 2025 04:12:24 GMT

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