add fields to session
I'm using Prisma and doing an initial query to get
an example of a typical query:
This is probably a noob question, but want to see other folk's thoughts on how they would handle this.
Thanks!
orgIdctx.session.user.idan example of a typical query:
getLowInvWarnings: protectedProcedure.query(async ({ ctx }) => {
const orgID = await ctx.prisma.user.findUnique({
where: {
id: ctx.session.user.id,
},
select: {
orgID: true,
},
});
if (!orgID?.orgID) return;
const lowInvGreenCoffee = await ctx.prisma.greenCoffee.findMany({
where: {
orgId: orgID?.orgID,
},
select: {
id: true,
name: true,
weight: true,
minInventory: true,
},
});This is probably a noob question, but want to see other folk's thoughts on how they would handle this.
Thanks!
