topic Issue getting records from events attribute in DQL

Issue getting records from events attribute

nisah — Wed, 11 Jun 2025 03:13:57 GMT

suites:{"name":"tests > GetByVINTest","count":13,"passed":10,"failed":3,"skipped":0}, {"name":"tests > SearchEngineTest","count":70,"passed":70,"failed":0,"skipped":0}, {"name":"tests > VinCheckTest","count":11,"passed":11,"failed":0,"skipped":0}

Have this event attribute (suites).

Trying to get the values as a table using the below dql. But I'm only getting the first record in the suites string. Attached screenshot in the post. How could I retrieve all the 3 records?

screenshot below.

Re: Issue getting records from events attribute

marco_irmer — Thu, 12 Jun 2025 22:29:31 GMT

The issue here is that the JSON parser on its own will not handle multiple JSON objects. There's a JSON_ARRAY parser, but your data doesn't appear to be structured as a JSON array. But not to worry, we can combine the JSON parser with the ARRAY parser to extract all three. We also need to move the expand command down in the query so that it executes AFTER we have a valid array that can be expanded.

The revised DQL would look like this:

fetch events filter event.kind == "SDLC_EVENT" AND event.category == "test" | fields suites, timestamp, suiteCount, environment, group | filter isNotNull(suiteCount) | filter isNotNull(suites) | parse suites, "ARRAY{JSON:json ', '?}{1,}:suite" | expand suite

Output in Playground:

Re: Issue getting records from events attribute

nisah — Wed, 25 Jun 2025 18:54:35 GMT

@marco_irmer Thanks for this solution. I had it worked with some splits. But this is much simpler and cleaner code that worked for me. Going to change my code.