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'
          }
        }
      }
    }
  }
})

Prisma•2y ago•

5 replies

Fervore

Nested relation query help

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'
          }
        }
      }
    }
  }
})

Nested relation query help

Similar Threads

Nested relation query help

Similar Threads

Similar Threads

Similar Threads