OR Condition in searchCriteria (REST API) dosn't work

[cappecar]

Magento 2.4-develop

Preconditions

I need to find all product in categories so I user a "searchCriteria" with a unique "filterGroups" and one "filter" foreach categories wanted call /V1/products resource (rest api).
In the old server with Magento 2.0 it works great, now we upgrade server and Magento if i search by more categories (or conditions) doesn't work.

Steps to reproduce

1. Create some categories (two or tre)
2. Create come products foreach category
3. Enable a REST API token
4. Make a call to resource "/V1/products" with a search parameter like this:

["searchCriteria"]=>
  array(1) {
    ["filterGroups"]=>
    array(1) {
      [1]=>
      array(1) {
        ["filters"]=>
        array(2) {
          [0]=>
          array(3) {
            ["field"]=>
            string(11) "category_id"
            ["value"]=>
            string(3) "{id category 1}"
          }
          [1]=>
          array(3) {
            ["field"]=>
            string(11) "category_id"
            ["value"]=>
            string(3) "{id category 2}"
          }
        }
      }
    }
  }

Expected result

This condition should be return all products in category {id category 1} OR {id category 2}

Actual result

Generally empty list of products, some time only products in the last category in query.

Thanks

[magento-engcom-team]

Hi @cappecar. Thank you for your report.
To help us process this issue please make sure that you provided the following information:

• Summary of the issue
• Information on your environment
• Steps to reproduce
• Expected and actual results

Please make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, please, add a comment to the issue:

@magento-engcom-team give me {$VERSION} instance

where {$VERSION} is version tags (starting from 2.2.0+) or develop branches (2.2-develop +).
For more details, please, review the Magento Contributor Assistant documentation.

@cappecar do you confirm that you was able to reproduce the issue on vanilla Magento instance following steps to reproduce?

• yes
• no

[cappecar]

@magento-engcom-team give me 2.2.4 instance

[magento-engcom-team]

Hi @cappecar. Thank you for your request. I'm working on Magento 2.2.4 instance for you

[magento-engcom-team]

Hi @cappecar, here is your Magento instance.
Admin access: https://i-16425-2-2-4.engcom.dev.magento.com/admin
Login: admin Password: 123123q
Instance will be terminated in up to 3 hours.

[cappecar]

The problem is the same on the Magento 2.2.4 istance created.

[orlangur]

@cappecar if you do it exactly as https://devdocs.magento.com/guides/v2.2/rest/performing-searches.html#logical-or-search (I mean zero indexes) it still does not work?