API Rest - Advanced filtering with OR expression

Development
1

Hello,

I would like to retrieve form submissions depending on two fields, using an OR expression.

First, I can filter on one field value with the following request:

{{base_uri}}/api/forms/{{form_id}}/submissions?where[0][col]=r.field&where[0][expr]=like&where[0][val]=%value%

This works well. Now I want to search on an other field value if the first one does not match (OR expression). I cannot find how to do this.

I tried this:

{{base_uri}}/api/forms/{{form_id}}/submissions?where[0][col]=r.field&where[0][expr]=like&where[0][val]=%value%&where[1][col]=r.field2&where[1][expr]=like&where[1][val]=%value2%

But it obviously does not work because it uses an AND operator I guess.

And this:

{{base_uri}}/api/forms/{{form_id}}/submissions?where[0][col]=r.field&where[0][expr]=like&where[0][val]=%value%&orWhere[0][col]=r.field2&orWhere[0][expr]=like&orWhere[0][val]=%value2%

But it seems that my query parameter orWhere is not taken into account.

Do you know how can I achieve this ?

Thank you for your time.

2

I haven’t tested it, but it seems that the API Library has an “orX” option:

It’s an alias for the Doctrine’s orX method:

Let us know if it works, please.