Filtering on aggregates now supported via @graphile/pg-aggregates

[benjie]

@graphile/pg-aggregates has added integration with this plugin to enable powerful aggregate filtering (e.g. "players who have scored more than 6 goals and had less than 2 fouls in the last 6 months"); I figure it might be useful to link to this in the README, but wasn't sure where to suggest - what do you think?

graphile/pg-aggregates#8

[jcrben]

This looks like what I needed!

But without this, is there a way to filter based on totalCount? Cause that's all I need for now

For now I'm just doing this on the client side

[benjie]

Not currently but feel free to file an issue about it

[jcrben]

fyi I ended up accomplishing my goal of filtering the industries based their count of companies via aggregates distinctCount; query looks like the blow

    query allIndustries($first: Int) {
        allIndustries(
            first: $first
            filter: {
                companiesByIndustry: {
                    aggregates: {
                        distinctCount: { industry: { greaterThan: "0" } }
                    }
                }
            }
            orderBy: COMPANIES_BY_INDUSTRY_COUNT_DESC
        ) {
            nodes {
                name
                code
                companiesByIndustry(first: 2) {
                    totalCount
                    nodes {
                        name
                        ticker
                    }
                }
            }
            totalCount
        }
    }

[mattbretl]

Awesome work! 🎉

I'm planning to move some of the huge sections of the README into separate files, and as part of that, I'll add a section with links to related plugins.

[mattbretl]

Updated the README 😄