How to search for records containing item(s) in a list property?

[Natim]

Let's say I have the following records:

{
    "data": {
        "title": "My title",
        "tags": ["astronomie", "science", "burundi"]
    }
}

What would be the request to look for all science in burundi?

http://localhost:8000/v1/buckets/wiki/collections/articles/records?tags_contains=science,burundi ?
http://localhost:8000/v1/buckets/wiki/collections/articles/records?tags=science,burundi ?

[almet]

+1 for contains.

[Natim]

Let's go for it then 👍

• tags_contains=science,burundi

[Natim]

For the postgresql backend we should use jsonb_array_elements(data->'arrayAttribute') as array_element

Refs: https://stackoverflow.com/a/32360952/186202