PrismaP
Prisma2y ago
2 replies
Mert Efe

Raw query doesn't work

 let result: any = await this.prisma.$queryRaw`
      select V.name, V.id, SUM(O."amount"::BIGINT)::BIGINT
        from "Variety" V
                 left join "Flower" as F on F."varietyId" = V.id
                 left join "Orderline" as O on O."flowerId" = F.id
  
      group by V.id, V.name`;


Do not know how to serialize a BigInt
Was this page helpful?