Need a help to fetch log based on the condition from json

JanJanu — Fri, 14 Feb 2025 11:21:32 GMT

this is the sample json format need DQL to fetch logs if imported is 11 based on the ID

{
"ID": {
"ID": "ghghgghgh",
"Type": "jj"
},
"Fruits": {
"Character": {
"color":"red"
"taste": bitter,

},
"Types": {
"imported": [
11
],
"isavailable": "False",

}
}
}

Re: Need a help to fetch log based on the condition from json

JeanBlanc — Mon, 17 Feb 2025 15:16:34 GMT

Hi,

I'm not sure I fully understand, but you can automatically parse JSON and then filter it like this:

data json:"""{ "ID": { "ID": "ghghgghgh", "Type": "jj" }, "Fruits": { "Character": { "color": "red", "taste": "bitter" }, "Types": { "imported": ["11"], "isavailable": "False" } } },""" | parse Fruits[Types][imported][0], "INT:event" | filter Fruits[Types][imported][0] == "11"

topic Re: Need a help to fetch log based on the condition from json in DQL

Need a help to fetch log based on the condition from json

Re: Need a help to fetch log based on the condition from json