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.