20 Jan 2025
12:41 PM
- last edited on
21 Jan 2025
06:59 AM
by
MaciejNeumann
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
Solved! Go to Solution.
20 Jan 2025 01:21 PM
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"
21 Jan 2025 04:11 AM - edited 21 Jan 2025 04:12 AM
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