GraphQL: Filter for tags that have at least one entry associated

[julianklotz]

Hi there,

I’m just wondering how to filter for tags that have at least one entry associated.

Our use case:

• We list events on our website (events have their own section)
• Events are tagged by topic, e.g. with a movie, a band, …
• The events expire as soon as they’re over
• We’d like to show a tag bubble in the main menu (Show all events for the movie A, show all concerts of band B)
• The tag bubble should exclude tags that are not linked to active events

In pseudo code: tags = Tags.filter('entries__active'=True).annotate(entry_count=Count('entries__count')).filter(entry_count > 0)

I haven't yet figured out how to accomplish this:

• TagCount doesn't seem to help
• The Tag’s _count field doesn't seem to help, because there’s no field to query related entries (filtering is possible, though)

Any thoughts, ideas?

Thanks!

[brandonkelly]

You can accomplish that using the relatedToEntries argument:

query {
  tags(relatedToEntries:{}) {
    title
  }
}

(You can filter down which entries the tags must be related to by passing nested arguments inside that {}, but as it stands that will return all tags that are related to any entries.)

[julianklotz]

Thank you Brandon, lovely!