Jsonapi filters not returning results if same field from reference fields are passed as filters

This issue still existing. Was able to recreate it with Drupal 10.2

If we add a delta to one of the filter keys, the issue is not happening.
Eg:

https://d10dev.ddev.site/jsonapi/node/news?filter[field_news_type.field_tag]=type1&filter[field_news_position.0.field_tag]=position1

But this wont fix the problem if the node taxonomy field is a multi valued one and has multiple terms added.

Debugging I found that is a problem with \Drupal\Core\Entity\Query\Sql\Condition and/or \Drupal\Core\Entity\Query\Sql\addField.

A workaround is the creation of an and group for each repeated field.

The issue reported in https://www.drupal.org/project/drupal/issues/3303269 🐛 Entity query using OR group with the same field name on different relationships doesn't work Active is the underlying cause of this incidence.

Oh wow, good call. I think we should actually be able to do that.