I was trying to do this super simple query: ```th...
# orm-help
f
I was trying to do this super simple query:
Copy code
this.prisma.objective.findMany({
  orderBy: {
    createdByMemberId: 'asc',
    createdAt: 'desc',
  }
});
Getting an error:
Copy code
ObjectiveOrderByInput needs exactly one argument, but you provided createdByMemberId and createdAt. Please choose one.
I've literally built 50% of my APP using prisma2 (mostly mutations so far) and now I find out I cannot query and sort by multiple columns. That is very much deal-breaker and heart-breaker for me. There is no mentioning anywhere about this limitation so I'm thinking maybe i need to enable something in order to make this to work? Please help
👍🏽 1
r
Hey @fenospro 👋 Unfortunately this is currently only possible via 
prisma.queryRaw
. There is still an open request for this here that you can follow.