WHERE conditions to compare columns in same table....
# orm-helpm
Manish Kumar
04/23/2021, 7:54 AMWHERE conditions to compare columns in same table.
this is my WHERE condition for mysql query:
EventCD NOT IN ('DIV' , 'DRIP') and SEDOL = ? and PrimaryExchgCD = ExchgCD
How can I do PrimaryExchgCD = ExchgCD part (column comparision) in prisma ?
const { SEDOL } = args;// EventCD NOT IN ('DIV' , 'DRIP') and SEDOL = ? and PrimaryExchgCD = ExchgCD"const whereCondition = {SEDOL,EventCD: {not: {in: ["DIV", "DRIP"],},},};r
Robert Witchell
04/23/2021, 7:57 AMmore info please. what is your schema properties? is
PrimaryExchgCDExchgCDm
Manish Kumar
04/23/2021, 8:05 AMPrimaryExchgCD, ExchgCDr
Robert Witchell
04/23/2021, 8:08 AMtry something like:
Copy code
where: {
AND: [
{EventCD: here},
{PrimaryExchangeCD: {equals: {ExchangeCD}}},
SEDOL,
],
}m
Manish Kumar
04/23/2021, 8:20 AMgives error: ExchgCD is not defined.
which does make sense because
ExchangeCDr
Robert Witchell
04/23/2021, 8:21 AMa) can you show your resolver now?
b) can you add query logging and see what the SQL looks like?
Robert Witchell
04/23/2021, 8:23 AM Copy code
new PrismaClient({log: [
'query',
{
emit: 'event',
level: 'query',
},
],})m
Manish Kumar
04/23/2021, 8:26 AMResolver
Copy code
Query: {
description: async (parent, args, ctx, info) => {
console.log(parent);
const { identifier, identifierVal } = args;
// ListStatus <> 'D' and ActFlag <> 'D'
const data = await ctx.prisma.eDI_SecurityMasterVMS.findFirst({
where: {
[identifier]: identifierVal,
ListStatus: {
not: "D",
},
Actflag: {
not: "D",
},
PrimaryExchgCD: { equals: { ExchgCD } },
},
});
}Manish Kumar
04/23/2021, 8:32 AMQuery log when I remove
PrimaryExchgCD: { equals: { ExchgCD } }vmsEDI_SecurityMasterVMSScexhIDvmsEDI_SecurityMasterVMSSedolIDvmsEDI_SecurityMasterVMSActflagvmsEDI_SecurityMasterVMSChangedvmsEDI_SecurityMasterVMSCreatedvmsEDI_SecurityMasterVMSSecIDvmsEDI_SecurityMasterVMSIssIDvmsEDI_SecurityMasterVMSISINvmsEDI_SecurityMasterVMSCUSIPvmsEDI_SecurityMasterVMSIssuerNamevmsEDI_SecurityMasterVMSCntryofIncorpvmsEDI_SecurityMasterVMSSICvmsEDI_SecurityMasterVMSCIKvmsEDI_SecurityMasterVMSIndusIDvmsEDI_SecurityMasterVMSSectyCDvmsEDI_SecurityMasterVMSSecurityDescvmsEDI_SecurityMasterVMSParValuevmsEDI_SecurityMasterVMSPVCurrencyvmsEDI_SecurityMasterVMSStatusFlagvmsEDI_SecurityMasterVMSPrimaryExchgCDvmsEDI_SecurityMasterVMSSEDOLvmsEDI_SecurityMasterVMSSedolCurrencyvmsEDI_SecurityMasterVMSDefunctvmsEDI_SecurityMasterVMSSedolRegCntryvmsEDI_SecurityMasterVMSStructCDvmsEDI_SecurityMasterVMSExchgCntryvmsEDI_SecurityMasterVMSExchgCDvmsEDI_SecurityMasterVMSMICvmsEDI_SecurityMasterVMSMicsegvmsEDI_SecurityMasterVMSLocalCodevmsEDI_SecurityMasterVMSListStatusvmsEDI_SecurityMasterVMSSharesOutstandingvmsEDI_SecurityMasterVMSEffectiveDatevmsEDI_SecurityMasterVMSvmsEDI_SecurityMasterVMSCUSIPvmsEDI_SecurityMasterVMSListStatusvmsEDI_SecurityMasterVMSActflag28 Views