I’m using JSON:API module (in core since v8.7), and works well for a simple query like:
Retrieve all articles with title that contains “MyKeyValue” or subtitle that contains “MyKeyValue”
That, translated in jsonapi query, is:
fields(node--article)=title,field_subtitle
filter(or-group)(group)(conjunction)=OR
filter(status)(value)=1
filter(title-filter)(condition)(path)=title
filter(title-filter)(condition)(operator)=CONTAINS
filter(title-filter)(condition)(value)=MyKeyValue
filter(title-filter)(condition)(memberOf)=or-group
filter(subtitle-filter)(condition)(path)=field_subtitle
filter(subtitle-filter)(condition)(operator)=CONTAINS
filter(subtitle-filter)(condition)(value)=MyKeyValue
filter(subtitle-filter)(condition)(memberOf)=or-group
But HOW to manage multivalues within the CONTAINS condition? I mean: how to accomplish a query like:
Retrieve all articles with title that contains (“MyKeyValue” AND “AnotherKeyValue”) or subtitle that contains (“MyKeyValue” AND “AnotherKeyValue”)
I tried to pass multiple values in this way:
...
filter(title-filter)(condition)(operator)=CONTAINS
filter(title-filter)(condition)(value)()=MyKeyValue
filter(title-filter)(condition)(value)()=AnotherKeyValue
...
filter(subtitle-filter)(condition)(operator)=CONTAINS
filter(subtitle-filter)(condition)(value)()=MyKeyValue
filter(subtitle-filter)(condition)(value)()=AnotherKeyValue
...
But does not work.