Category filtering not working in some specific queries.

[lbenevento]

Describe the bug
The category filter on products doesn't work in some use cases. Specifically when trying to retrieve products using the query related to a product attribute.

To Reproduce
Steps to reproduce the behavior:

1. Create a new product attribute.
2. Query the products using the subfield of your paYourProductAttribute query.
3. Try to filter by category.
4. See error (hopefully)

Expected behavior
The filter should work no matter where it's applied (unless I'm missing something).

Plugin Versions

• WooGraphQL Version: 0.12.1
• WPGraphQL Version: 1.14.1
• WordPress Version: 6.2
• WooCommerce Version: 7.6.0

Additional context
Those are some example queries ran on my end:

Operation:

query Categories {
  productCategories {
    nodes {
      slug
      databaseId
    }
  }
}

Results in:

{
  "data": {
    "productCategories": {
      "nodes": [
        { "slug": "fruits", "databaseId": 23 },
        { "slug": "uncategorized", "databaseId": 16 },
        { "slug": "vegetables", "databaseId": 22 }
      ]
    ...

Operation where category filters are working:

query CategoryFiltering_Working {
  products(where: {categoryId: 23}){
    nodes {
      productCategories {
        nodes {
          slug
          databaseId
        }
    ...

Results in (result cut but the complete version indeed contains just the products with the correct category):

{
  "data": {
    "products": {
      "nodes": [
        {
          "productCategories": {
            "nodes": [{ "slug": "fruits", "databaseId": 23 }]
          }
        },
        {
          "productCategories": {
            "nodes": [{ "slug": "fruits", "databaseId": 23 }]
          }
        }
     ...

Operation where category filters are NOT working.

query CategoryFiltering_NotWorking {
  paSellerid(id: "dGVybToyMA==") {
    products(where: {categoryId: 23}) {
      nodes {
        productCategories {
          nodes {
            slug
            databaseId
          }
    ...

Results in (again, cut to avoid useless code but it's enough to notice that even the first product has the wrong category):

{
  "data": {
    "paSellerid": {
      "products": {
        "nodes": [
          {
            "productCategories": {
              "nodes": [{ "slug": "vegetables", "databaseId": 22 }]
            }
          }
    ...

[kidunot89]

@lbenevento and the product queried isn't under both the vegetables and fruits categories? Because where.categoryId param on the ProductAttribute.products connection will only filter the products not their productCategories.

[lbenevento]

Thank you for the answer but I'm not sure I got what you mean.
Anyway no product has both categories and the queried product's category is visible in the example queries I posted!