Is it possible to use JSONPath with "?()" syntax to filter objects (not array) in Redis?

Question

I'm using node-redis library. I have redis key: test1 with value:

{
    "requests": [
        {
            "requestId": "123",
            "requestType": "TYPE_1",
            "foo": "bar",
            "timestampS": 1230011000
        },
        {
            "requestId": "124",
            "requestType": "TYPE_1",
            "foo": "bar2",
            "timestampS": 1230011050
        }
    ]
}

To get all requests with timestampS < 1230011040, I need to run:

const value = await this.client.json.get('test1', { path: `$.*[?(@.timestampS<1230011040)]` });

It works. The value is an array with one element (request object with "requestId": "123").

However, I don't know how to get an array with all request objects with timestampS < 1230011040 from redis key test2 with value:

{
  "123": {
        "requestId": "123",
        "requestType": "TYPE_1",
        "foo": "bar",
        "timestampS": 1230011000
    },
    "124": {
        "requestId": "124",
        "requestType": "TYPE_1",
        "foo": "bar2",
        "timestampS": 1230011050
    }
}

Is it possible?

gregsdennis · Accepted Answer · 2024-07-08 07:58:03Z

0

In terms of JSON Path, yes, the filter selector operates on both stays and objects. For objects, it ignores the keys and iterates through the values.

I don't know whether redis supports that, but it's a pretty basic feature, so it should.

Also, when in doubt, just try it.

answered Jul 8, 2024 at 7:58

gregsdennis

8,5206 gold badges43 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Konrad Over a year ago

gregsdennis thank you for your answer. Indeed, as I understand from the documentation: redis.io/docs/latest/develop/data-types/json/path, the path: $.*[?(@.timestampS<1230011040)] should work also for objects. However, I tried it and for some reason it doesn't work.

gregsdennis Over a year ago

Then I think you're down to consulting any docs they have. At worst, raise an issue and get support.

Konrad · Accepted Answer · 2024-07-08 12:16:45Z

0

It took me a some time, but the solution was easy. I just had to remove the unnecessary star (*) in the JSONPath. This path: $.[?(@.timestampS<1230011040)] works.

edited Jul 8, 2024 at 12:16

answered Jul 8, 2024 at 11:03

Konrad

771 silver badge9 bronze badges

Collectives™ on Stack Overflow

Is it possible to use JSONPath with "?()" syntax to filter objects (not array) in Redis?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related