Fervore
Fervore
Explore posts from servers
PPrismaTTCTheo's Typesafe Cult
PostsComments
PPrisma
Created by Fervore on 7/22/2024 in #help-and-questions
Nested relation query help
Hello, I was trying to query users, then I added the implementation to show payments but now I realize it was bringing payments of all users from the membership instead of bringing all payments of that specific user for each specific membership. Is there a way to do this query in the same object or is there a way to reference the current user for each index of the array? 
prisma.user.findMany({
  orderBy: {
    id: 'desc',
  },
  include: {
    memberships: {
      include: {
        payments: {
          take: 1,
          orderBy: {
            endDate: 'asc'
          }
        }
      }
    }
  }
})
prisma.user.findMany({
  orderBy: {
    id: 'desc',
  },
  include: {
    memberships: {
      include: {
        payments: {
          take: 1,
          orderBy: {
            endDate: 'asc'
          }
        }
      }
    }
  }
})
Example of what It would be ideal but ofc it doesn't work 
prisma.user.findMany({
  orderBy: {
    id: 'desc',
  },
  include: {
    memberships: {
      include: {
        payments: {
          where: {
            memberId: "current_member_id??"
          },
          take: 1,
          orderBy: {
            endDate: 'asc'
          }
        }
      }
    }
  }
})
prisma.user.findMany({
  orderBy: {
    id: 'desc',
  },
  include: {
    memberships: {
      include: {
        payments: {
          where: {
            memberId: "current_member_id??"
          },
          take: 1,
          orderBy: {
            endDate: 'asc'
          }
        }
      }
    }
  }
})
6 replies