Fetching Unique Categories related to Entries via GraphQL

Question

Suppose I have some entries in a section called 'product' that are related to a category call 'brand' - I know I can get the brands that are related to each product that match a search term using GraphQL like so:

query Query($searchTerm: String) {
  entries(search: $searchTerm, section: "product") {
    ... on product_product_Entry {
      brand {
        id
      }
    }
  }
}

Which returns something like this:

{
  "data": {
    "entries": [
      {
        "brand": [
          {
            "id": "3"
          }
        ]
      },
      {
        "brand": [
          {
            "id": "5"
          }
        ]
      },      
      {
        "brand": [
          {
            "id": "3"
          }
        ]
      },
      ...

What I'm looking to do is get all the brands that are related to the products matching the search, but obviously if I use the above query then the response will get very big very quick. Is it possible to get just the distinct brand id values returned from the above GraphQL query? Or am I better off making a module with a controller action and querying the database that way?

Answer 1

You can run a categories query and pass it your product id(s) as well as the category group id (though that's not necessary) to fetch all categories related to your products.

The query:

query getRelatedBrands($relatedTo: [QueryArgument] = "", $groupId: [QueryArgument] = "") {
  categories(groupId: $groupId, relatedTo: $relatedTo) {
    id
  }
}

and the variables:

{
  "relatedTo": [13306, 13638],
  "groupId": [1]
}

Which would return:

{
  "data": {
    "categories": [
      {
        "id": "3"
      },
      {
        "id": "234"
      }
    ]
  }
}

Answer 2

If I understand correctly you are searching for products with a $searchTerm query variable and you want a separate list of the unique brands related to those products.

You could use a categories GraphQL query with the relatedToEntries argument. Pass in search: $searchTerm like you would with an element query.

query Query($searchTerm: String) {
  brands: categories(group: "brand", relatedToEntries: [{section: "product", search: $searchTerm}] {
    id
  }
}

Should return a list like this:

{
  "data": {
    "brands": [
      {
        "id": "3"
      },
      {
        "id": "5"
      },
      {
        "id": "19"
      },
      ...