Question 188630 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Enterprise Redis JSON.GET Syntax for JSONARRAY contains

I’am looking what functionalities that Redis Enterprise can offer, and came up with following questions.
Content in JSON using JSON.Set

JSON.SET warehouse:1 $ '{
    "city": "Boston",
    "location": "42.361145, -71.057083",
    "inventory": [
        {   
            "id": 15970,
            "gender": "Men",
            "season":["Fall", "Winter"],
            "description": "Turtle Check Men Navy Blue Shirt",
            "price": 34.95
        },
        {
            "id": 59263,
            "gender": "Women",
            "season": ["Fall", "Winter", "Spring", "Summer"],
            "description": "Titan Women Silver Watch",
            "price": 129.99
        },
        {
            "id": 46885,
            "gender": "Boys",
            "season": ["Fall"],
            "description": "Ben 10 Boys Navy Blue Slippers",
            "price": 45.99
        }
    ]
}'

How to write JSON.GET warehouse:1 for "season" contains "Winter"

Tags:

2

Answers


  1. 0

    What you are looking for is a "contains" operation for JSONPath. At the moment, I don’t believe this is possible. This isn’t a limitation with Redis Enterprise or Redis Stack, this is a limitation of JSONPath itself.

    I did some googling and found some bits and bobs with proposed syntax for JSONPath to do this. However, nothing implemented yet.

    There might be a clever hack to get around this but I couldn’t think of one. I would suggest that you check out the JSONPath docs for Redis, looking specifically at the filtering examples, and that you play around with what you can do with JSONPath with an online evaluator.

    Login or Signup to reply.
  2. 0

    • If you know which JSON document to look into, JSONPath filters can be used, as suggested by Guy Royse,
      For example, to get the id of items with Winter in season:

      JSON.GET warehouse:1 '$.inventory[?(@.season[?(@=="Winter")])].id'

    • If you do not know which JSON document to look into, RediSearch can be used, as suggested by Simon Prickett,
      For example:

      FT.CREATE idx:inventory ON JSON SCHEMA '$.inventory[*].season[*]' AS season TAG

      And then search for documents

      FT.SEARCH idx:inventory @season:{Winter}

      Or also retrieve the relevant id

      FT.SEARCH idx:inventory @season:{Winter} RETURN 1 '$.inventory[?(@.season[?(@=="Winter")])].id'
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search