:wave: Any suggestions on how to get the aggregat...
# orm-help
c
👋 Any suggestions on how to get the aggregate of a field separated out by user IDs?
example:
Copy code
query GET_ACTIVE_ELECTIONS {
  getActiveElections {
    id
    electionName
    endTime
    ballots {
      results {
        candidate {
          id
          firstName
          lastName
        }
        count
      }
    }
  }
}
where
results
would return an array of objects, each with a
candidatedId
and count of votes? My
datamodel.prisma
at the moment:
Copy code
type User {
  id: ID! @unique
  firstName: String!
  lastName: String!
  ...
  candidateFor: [Ballot]! @relation(name: "CandidateUser")
  votesReceived: [Vote]! @relation(name: "VotesRecdUser")
  votedFor: [Vote]! @relation(name: "VotedUser")
}

type Election {
  id: ID! @unique
  electionName: String!
  startTime: DateTime
  endTime: DateTime
  ballots: [Ballot!]!
}

type Ballot {
  id: ID! @unique
  title: String!
  desc: String
  candidates: [User!]! @relation(name: "CandidateUser")
  votes: [Vote] @relation(name: "BallotVote")
  # results: [Result]
}

type Vote {
  id: ID! @unique
  ballot: Ballot! @relation(name: "BallotVote")
  dateTime: DateTime
  candidate: User @relation(name: "VotesRecdUser")
  voter: User! @relation(name: "VotedUser")
}

# type Result {
#   candidate: User!
#   count: Int! @default(value: 0)
# }
I’m a little lost trying to tie the
Results
info into my resolver
I tried to follow [this](https://www.prisma.io/forum/t/how-to-use-field-resolvers-to-get-aggregates-of-inner-relation-types/2930/2) but I can’t translate it to my example. I don’t understand where the
likes
fragment and resolver goes