Hi again Trying to get all posts not owned by current user I

Question

Hi again Trying to get all posts not owned by current user I have specific user id and do `filter user id not qwerty123 ` but it returns me empty array what I do wrong

iamclaytonray · Answer

What s your schema look like

Maslov · Answer

< iamclaytonray> ``` type Post model user User relation name PostOnUser ```

iamclaytonray · Answer

Do you have a field called `id not`

Maslov · Answer

no

iamclaytonray · Answer

Cool You can t filter on fields you don t have

iamclaytonray · Answer

That sounds like something you want to throw some business logic into instead of just a filter

agartha · Answer

Yes you can id not is a generated filter field

agartha · Answer

just like all other filter fields generated not in contains starts with etc

agartha · Answer

Only this seems to be a bug

agartha · Answer

I can reproduce that too

iamclaytonray · Answer

Really

iamclaytonray · Answer

Oh yeah duh

agartha · Answer

Ah it filters for null values

Maslov · Answer

< agartha> thank you for answer If it is a bug should I create the issue etc to find if it fixed

iamclaytonray · Answer

If he had a default value would it work

iamclaytonray · Answer

Of a string

agartha · Answer

Can you confirm that the other Posts actually have a user

Maslov · Answer

no they not just null

Maslov · Answer

for test

agartha · Answer

If I do `allTests filter user id not x id ` it works if the Test node has a User

agartha · Answer

it is not returned when user is null

Maslov · Answer

looks like I have to use OR for it or it s just a bug

agartha · Answer

`filter OR user id not x user null `

agartha · Answer

Well because user is null it can t check the id value

agartha · Answer

So although it s not a bug it is counterintuitive

Maslov · Answer

< agartha> thank you dude +1

agartha · Answer

Bool math at play if ball = null ball color = blue cannot be executed