Hi everyone, so I’m attempting to query a type and...
# orm-helpp
Philipp Rajah Moura Srivastava
09/15/2020, 11:16 PMHi everyone, so I’m attempting to query a type and I want all instances where a field of that type is null. Is there a proper way to do this? I can think of a solution, however I suspect that solution might create problems elsewhere.
r
Ryan
09/16/2020, 6:18 AMhey @Philipp Rajah Moura Srivastava 👋
Is this regarding Prisma 1 or 2?
p
Philipp Rajah Moura Srivastava
09/16/2020, 5:50 PMPrisma 1 😞 still waiting for mongodb support
Philipp Rajah Moura Srivastava
09/16/2020, 5:50 PMsticking with you guys tho!
🙌 1
Philipp Rajah Moura Srivastava
09/17/2020, 7:07 PMhey @Ryan is there an answer to my question tho?
r
Ryan
09/18/2020, 7:31 AMFor P1 let me check and get back to you
p
Philipp Rajah Moura Srivastava
09/18/2020, 5:22 PMsweet thank you. I don’t expect that this query will return many objects so I could query all of them and then do some work on the server to get the data i want, but a query would be nice
Philipp Rajah Moura Srivastava
09/21/2020, 4:48 PMDid you get around to checking yet? @Ryan
r
Ryan
09/22/2020, 9:50 AMIf it’s a field in the same relation, then it should be simple as doing this (for a user’s relation):
Copy code
prisma.users({ where: { age: null } })p
Philipp Rajah Moura Srivastava
09/22/2020, 9:11 PMI have an event with a school type subfield so i want something like prisma.events( { where: { otherecritearia, school: AND: [ null, users school] } } )
r
Ryan
09/23/2020, 9:54 AMI don’t think that’s possible in Prisma 1, where you can use a compound condition inside a field query. I think two queries would be required here, one to get the users school and the other for nulls and combining the two.
p
Philipp Rajah Moura Srivastava
09/24/2020, 7:03 PMok thanks
Philipp Rajah Moura Srivastava
09/24/2020, 7:03 PMand raw queries are not possible right?
r
Ryan
09/25/2020, 6:35 AMIf you're using Mongo, then you can directly use Mongoose for raw queries.
p
Philipp Rajah Moura Srivastava
09/26/2020, 3:56 PMIs there an example somewhere for that? I haven’t been able to find anything
r
Ryan
09/28/2020, 6:42 AMI don’t think there is, but let me still check.
p
Philipp Rajah Moura Srivastava
10/05/2020, 12:30 AMAny update on this?
Philipp Rajah Moura Srivastava
10/05/2020, 12:30 AMTried to find resources but haven’t been able to
r
Ryan
10/05/2020, 7:12 AMNo I couldn’t find any. I think checking Mongoose docs would be the only option here.
p
Philipp Rajah Moura Srivastava
10/05/2020, 5:49 PMOk cool, do you know where the access point in the context is? I was going through it, trying various things but I couldn’t figure it out