[4.x]: graphql filtering on related category return unespected elements

[vettndr]

What happened?

Description

I'm filtering records based on a category using graphql and I'm not able to understand why I'm receiving items that not match the id of that category.

Steps to reproduce

Expected behavior

I'm expecting to receive only records that have category with id: 20

Actual behavior

Other elements are retrieved.

Craft CMS version

4.7.1

PHP version

8.1.27

Operating system and version

No response

Database type and version

MariaDB 10.6.16

Image driver and version

No response

Installed plugins and versions

[i-just]

Hi, thanks for getting in touch!

It sounds like a duplicate of: #12740

For now, you can get the results you’re after if you use relatedToCategories instead of offerCategories, like so:

query getOffers {
  OfferEntries(siteId: "1", relatedToCategories: {id: "20"}) {
    ... on Offer_Entry_Entry {
      title
      offerCategories {
        ... on Offer_Category {
          id
        }
      }
    }
  }
}

[vettndr]

Hi, thanks for getting in touch!

It sounds like a duplicate of: #12740

For now, you can get the results you’re after if you use relatedToCategories instead of offerCategories, like so:

query getOffers {
  OfferEntries(siteId: "1", relatedToCategories: {id: "20"}) {
    ... on Offer_Entry_Entry {
      title
      offerCategories {
        ... on Offer_Category {
          id
        }
      }
    }
  }
}

Hi @i-just ,
thank you for your reply.

I tried also as you suggested me before to create this issue.
It's still not working.

[i-just]

Thanks for the info. I’m not able to reproduce this issue when using relatedToCategories. Would you be able to send your composer.json, composer.lock and database export to [email protected] so we can try to replicate it?

[i-just]

The initial issue (querying by related category in a multi-site setup) was fixed in 4.7.3, so I’ll close this now.

@vettndr, if you’re still getting unexpected results when using relatedToCategories, please send the requested files to support, and we’ll have a look into it.

[brandonkelly]

Craft 4.8.0 was just released with a fix for this. Thanks for your help!