Trying to use an array of values in a IN clause bu...
# orm-help
m
Trying to use an array of values in a IN clause but Prisma.join is not returning properly. SOLVED....I had the parameters in the wrong order.... Nope not solved....query returns but it does NOT exclude the values in the array and it still shows the same as above instead of Not IN (1,2,3)
r
@Melvin Gaye 👋 Could you share the query?
m
Yes when I get home later today, I'll post it here. This is related to stored procedure I talked about on another thread and I wasn't able to call it so now I'm using
queryraw(sql string here, four parameters passed here)
@Ryan this is the query I'm using