I have an `int32` field. How do I specify `IS NULL...
# community-help
e
I have an
int32
field. How do I specify
IS NULL
when filtering?
j
This is not possible to do. But here's a workaround: https://github.com/typesense/typesense/issues/790#issuecomment-1314105452
e
That is troubling. We have over 100 fields and most of them are optional, and we need to be able to search for null values. Having to create
_is_empty
fields for each optional field is a non-starter. Is this feature request on the roadmap?
j
Not at the moment - we have higher priority items that we're working on and we re-evaluate priorities regularly based on community feedback. Could you add a comment and a thumbs-up to that issue?
The additional fields shouldn't take up too much memory btw, since they'll be boolean values
And you can exclude them from search results using the include_fields and exclude_fields search parameter
You also want to generate them programmatically on your application side, so there's no manual effort involved.
e
A lot of dev time involved for this though. We need to add dozens of new fields to the ETL pipeline's transform layer. I'll have to speak to product to see how much we need to expand the project scope to accommodate that.