Search kit text field 'is null' issue
I'm seeing an issue on search kit that we solved in civireport by treating 'is null' as 'is empty' on text fields
Basically I want to search for people with no value in my custom field 'custom field'. It's in the constituent custom data set and anyone who has had this data set edited WILL have a value on that field ('') - so I'm looking for what we call in Search Builder 'Is Empty' - because I don't have that option I choose 'is null' - but that doesn't do what I want
As an sql writer I know I could use 'LIKE '%'' but I don't think that is intuitive