JonApps
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?
3 replies
Showing related fields in other views
When adding an opportunity, it's currently linked to a company and to a person. Is it possible, to show on the opportunity screen, a field from the company table and use this as a grouping/filter? Currently the only fields I am able to use as those that belong directly to the opportunity data model.
Another example would be, I want to filter all companies with field value of x on the people view so that I can pull all those contact details.
3 replies