Is it possible to filter a query by relational met...
# prisma-whats-new
m
Is it possible to filter a query by relational metadata. For example a user object has a related field that I want to filter by count but the meta appears unavailable which leaves me doing a big query and filtering the JSON myself (bad)
m
@magus does this help?
Copy code
Connection queries also expose aggregation features via aggregate:
# Count all posts with a title containing 'GraphQL'
query {
  postsConnection(where: {
    title_contains: "GraphQL"
  }) {
    aggregate {
      count
    }
  }
}
Note that additional aggregations will be added over time. You can find more information about that here.
m
Where doesn’t seem possible in playground
Is this supported?
m
hmmm not sure tbh