🧮 Aggregate queries

[FelixMalfait]

Our GraphQL API should support aggregate queries on findMany queries.

We already have totalCount so we can take inspiration from that.
But it's significantly more challenging because the aggregated fields name are dynamic and depend on the object names themselves. Here's how it could look like:

query {
   companies {
    edges {
      node {
        id
        domainName {
          primaryLinkLabel
        }
        people {
          totalCount
          maxCreatedAt
        }
      }
    }
    totalCount
    maxCreatedAt
  }
}

We'll need to add: min, max, avg, sum, countDistinct

[FelixMalfait]

Default aggregations available for all fields:

For date fields:

For numeric fields:

[Bonapara]

CleanShot.2024-09-19.at.13.57.53.mp4

[ijreilly]

CleanShot.2024-09-19.at.13.57.53.mp4

@Bonapara do we have further designs ?

[Bonapara]

Do you still need anything, @ijreilly?

[ijreilly]

no all good for now after our talk ! @Bonapara

[ijreilly]

Next steps:

1. Expose current available aggregate operations (MAX, MIN, AVG, SUM) on table views: Use aggregate queries in table views #8734
2. Same for kanban views Use aggregate queries in kanban views #8735
3. Use "count" from aggregate operations instead of "totalCount"