I have the following situation:
- i have a db table called notification
- it has a field called 'target_users', it's text field but marked as list, so basically the exact same as an array (if I understood the structure correctly)
- when I query all the notifications that have target_users = null, I will not get those where this list has been initiated, yet is still empty
so basically, I can't seem to query on those where there are no target_users, or at least I wouldn't know how to do it? I even tried adding the filter 'length' but that doesn't seem to work either.
also, when creating rows, by default it's not set as NULL, but it's simply an empty array. and there's no way to change it from empty to null.
I believe it should be possible to define empty, or null, and work with it somehow?