hey all, i know this has probably been asked so ap...
# orm-helpv
val
09/25/2018, 12:17 PMhey all, i know this has probably been asked so apologies if so. How can i sort a query based on the number of items in an array the object has. I.e. if
Userfollowers: [User!]!a
Arnab
09/25/2018, 12:33 PMI don't think that kind of nested sorting (sorting on subfields) is possible on the graphQL API that prisma provides. However maybe that's possible in the ORM that prisma released? I dunno
v
val
09/25/2018, 12:39 PMany links that i can read on the ORM?
a
Arnab
09/25/2018, 12:40 PMThis is the only thing I found: https://www.prisma.io/blog/prisma-client-beta-ahph4o1umail/
Arnab
09/25/2018, 12:44 PMI found something similar to your usecase, but just for relay:
https://github.com/graphql/graphql-relay-js/issues/20
Does that help?
v
val
09/25/2018, 12:46 PMI was looking at the raw SQL query support in prisma 1.17 - that might work
a
Arnab
09/25/2018, 12:47 PMWell that's always a useful crutch I guess
Arnab
09/25/2018, 12:47 PMBut what are you trying to actually solve?
v
val
09/25/2018, 12:49 PMI want to return a list of users based on the number of followers they have
val
09/25/2018, 12:49 PMit seems the current way to do that is to store the number of followers for each user and update it
a
Arnab
09/25/2018, 12:50 PMDo you use eventsourcing?
v
val
09/25/2018, 12:50 PMi had to look up what that is, so my guess is no 😛
a
Arnab
09/25/2018, 12:50 PMOk, yeah then it's a bit harder