Hi,

When I index a table from my database there is a field status_code which can have null values, the index does not store that field for records which has its value as NULL. In my search query I need to search/filter on the field status_code where status_code=NULL.

However since this field is not getting stored for NULL values my query is failing. How do I over come this?


Thanks,
David

Hi,
look into the reference documentation for "indexNullAs", and set the default null token to something which doesn't cause ambiguity (maybe the literal "NULL" ?), then you can search for your custom token.