API filtering NULL value on enums
I have added a select to the people model with some values. Later I found the set as default which I did not do when creating the field. I now have a bunch of records with a NULL value (seen in the API response) for this field as setting to default after does not backfill.
I am trying to now script this using the API, the issue I have however, is I can find no way to find people based on this NULL value. I have tried combinations of operators and none seem to yield the correct result.
emailStatus[eq]:BLOCKED ✅
emailStatus[neq]:BLOCKED ❌ No results
not(emailStatus[eq]:BLOCKED) ❌ No results
emailStatus[in]:BLOCKED ❌ Needs array
emailStatus[in]:[BLOCKED] ✅
not(emailStatus[in]:[BLOCKED]) ❌ Returned empty
emailStatus[is]:NULL ❌ NULL not allowed as enum value
emailStatus[in]:[NULL] ❌ NULL not allowed as enum value
So it seems like NULL values are omitted from the result set and no operator or combination of operators on enum fields can get me the result I want. Am I missing something or will I just need to pull all records and use the cursor to go through them?
2 Replies
Hey thank you for reaching out. Indeed we can't filter by null enum types. I create an issue