Hi again. Trying to get all posts, not owned by cu...
# prisma-whats-newm
Maslov
10/19/2017, 5:53 PMHi again. Trying to get all posts, not owned by current user. I have specific user id and do:
filter({ user: { id_not: "qwerty123" } })✅ 1
i
iamclaytonray
10/19/2017, 5:56 PMWhat’s your schema look like?
m
Maslov
10/19/2017, 5:58 PM@iamclaytonray
Copy code
type Post @model {
user: User @relation(name: "PostOnUser")
...
}i
iamclaytonray
10/19/2017, 5:59 PMDo you have a field called
id_notm
Maslov
10/19/2017, 5:59 PMno
i
iamclaytonray
10/19/2017, 6:01 PMCool. You can’t filter on fields you don’t have
iamclaytonray
10/19/2017, 6:02 PMThat sounds like something you want to throw some business logic into instead of just a filter
a
agartha
10/19/2017, 6:02 PMYes, you can. id_not is a generated filter field
agartha
10/19/2017, 6:03 PMjust like all other filter fields generated (not_in, contains, starts_with etc.)
agartha
10/19/2017, 6:03 PMOnly this seems to be a bug
agartha
10/19/2017, 6:03 PMI can reproduce that too
i
iamclaytonray
10/19/2017, 6:03 PMReally?
iamclaytonray
10/19/2017, 6:04 PMOh, yeah, duh
a
agartha
10/19/2017, 6:04 PMAh, it filters for null values
m
Maslov
10/19/2017, 6:04 PM@agartha thank you for answer, If it is a bug, should I create the issue, etc, to find if it fixed?
i
iamclaytonray
10/19/2017, 6:04 PMIf he had a default value, would it work?
iamclaytonray
10/19/2017, 6:04 PMOf a string
a
agartha
10/19/2017, 6:04 PMCan you confirm that the other Posts actually have a user?
m
Maslov
10/19/2017, 6:05 PMno they not, just null
Maslov
10/19/2017, 6:05 PMfor test
a
agartha
10/19/2017, 6:05 PMIf I do
allTests(filter: { user: { id_not: "x" }}){ id }agartha
10/19/2017, 6:05 PMit is not returned when user is null
m
Maslov
10/19/2017, 6:06 PMlooks like I have to use OR for it or it's just a bug?
a
agartha
10/19/2017, 6:06 PMfilter:{ OR: [{ user: { id_not: "x" }}, { user: null }]}agartha
10/19/2017, 6:06 PMWell, because user is null, it can't check the id value
agartha
10/19/2017, 6:07 PMSo although it's not a bug, it is counterintuitive
m
Maslov
10/19/2017, 6:07 PM@agartha thank you dude 👍
😎 1
a
agartha
10/19/2017, 6:08 PMBool math at play, if ball = null, ball.color != 'blue' cannot be executed
3 Views