does anyone have a pagination example with nestjs ...
# orm-helpn
n
02/01/2022, 7:08 PMdoes anyone have a pagination example with nestjs + graphql that also returns count
n
02/01/2022, 7:25 PMa
Austin Zentz
02/01/2022, 7:27 PMin Prisma, I've wound up having to make two queries with the same filters inside of a transaction. The first gets the count, the second includes the pagination details and gets the selected details
Austin Zentz
02/01/2022, 7:28 PMwinds up looking like
Austin Zentz
02/01/2022, 7:29 PMconst [total, users] = await prisma.$transaction([prisma.user.count({where: // your where stuff}),prisma.user.findMany({where: // your where stuffskip: // skip detailstake: // 10 or whatever})]);n
n
02/01/2022, 7:48 PMhow did you return that to edge/nodes @Austin Zentz (thanks for the reply btw)
a
Austin Zentz
02/01/2022, 7:50 PMah, i don't have the gql constraint in my example -- that just gets returned in a REST-style API call
Austin Zentz
02/01/2022, 7:51 PMso hopefully that's a good 1st piece of the puzzle but doesn't solve the latter part
n
n
02/01/2022, 7:51 PMah, yeah that's the issue i'm having is returning it as a edge and node also, but the full lifecycle of it