CRITICAL! queries with 'not like' started failing

General
21

Mark, thank you for reply.
I`ve jsut tested query as you suggested

event_object.objectId is not null AND to_user.objectId is not null AND from_user.objectId is not null AND to_user.social_user_id = 4044463 AND accepted = false AND viewed = false

the result is ok - no more null related objects, but, as I noted above, that code was working fine.

22

I understand it was working before, but it was a “lucky” or rather unfortunate coincidence. The proper check for missing relation is by checking it’s objectId for null.

23

Thank you again.
We will update our apps` code using right syntax to fix this.