How to filter an item in JSON.array

[ashifa454]

Hi Team,
I would like to filter an item via "uid" from key "D" which is a JSON.array

{
  "MTYxNTkwMTY5Mzk2Nw-meet": {
    "A": [],
    "B": "discussion",
    "C": "created",
    "D": [
      {
        "uid": "5c0bd0471849cbf4ac34df49"
      }
    ]
  }
}

[gkorland]

what is expected result in this case?

[ashifa454]

{ uid:"5c0bd0471849cbf4ac34df49"} if i filter via 5c0bd0471849cbf4ac34df49

[gkorland]

JSON.GET doc:1 $.MTYxNTkwMTY5Mzk2Nw-meet.D[0]

Or

JSON.GET doc:1 $..D[0]

[ashifa454]

I think this will give me the first item from the array, what if I want to find the index on runtime? I was planning to use QGET but after the latest push, it says QGET is an unknown command.

[gkorland]

JSON.GET doc:1 '$..D[?(@.uid=="5c0bd0471849cbf4ac34df49")]'

[gkorland]

@ashifa454 regarding QGET, you're right it was never officially released and we decided the right place for this functionality is RediSearch.
In the upcoming version you will be able to create RediSearch index that follows RedisJSON.

[ashifa454]

JSON.GET doc:1 '$..D[?(@.uid=="5c0bd0471849cbf4ac34df49")]'

can you please explain this one or if there is any detailed documentation?

[gkorland]

You can read more about JSONPath here - https://github.com/json-path/JsonPath

[ashifa454]

thankyou so much for quick response it worked