topic Re: Iterate through an log record in DQL

Iterate through an log record

olgatimbur — Mon, 04 Nov 2024 17:40:20 GMT

I am trying to determine a status of a scenario as passed/failed
| fieldsAdd status = event[steps]
Each step record can have a list of element and results:
example:
[ { "result": "passed", "error": "" },{ "name": "I login to profile", "result": "passed", "error": "" }, ]
i need to iterate through it, if any of the result is failed, the scenario will get a failed status
else passed

Thank you

Re: Iterate through an log record

Fin_Ubels — Tue, 05 Nov 2024 01:57:31 GMT

Hey @olgatimbur

If all you need is whether or not there is a fail could you use the contains function as below?

fetch logs | fieldsAdd status = if(contains(content, "\"result\": \"failed\""), "failed", else:"passed")

Re: Iterate through an log record

olgatimbur — Tue, 05 Nov 2024 04:20:10 GMT

Thank you