My requirement is, I want to fetch the rows from the table in which for one of the condition is field value should be empty.
I have field to identify record is deleted or not. And if it is deleted we insert date in it. Else field is empty by default.

Now whenever I am issuing facet request it ignores the record for that field as it has no data. Any idea on how can I resolve this?

I tried with something like this in my code to add filter.
Query query = new WildcardQuery(new Term(term,"*"));
return new CachingWrapperFilter( new QueryWrapperFilter(query));

but this will also consider the field which has some text inside it. I want to fetch records only with empty string in the filed. If it has some text then I want to ignore that record.

Any idean on how to achieve this?

Thanks for your help in advance.

Hi,

Having an empty string is probably not such a good idea. Is the field really empty or is it null? If it is null you can have a look at the indexNullAs parameter of the @Field annotation. It allows you to index a arbitrary token for null values.

--Hardy