Hibernate search version : hibernate-search-3.1.0.Beta1
Lucene: lucene-core-2.3.2.jar

Hi,

I am a newbie.

I just configured lucene using hibernate search. But I find that the sorting does NOT ignore null values.

I am searching using one field, say X and want to sort the results using another, say Y (Which can have null values). But I am expecting Sort to ignore all the null values and just sort only records that has values in Y field.

How can I achieve this. Is there anywhere I can set the flag in SortField that specifies it to ignore all the null values ?

Please help.



In the above code "lastUpdatedDate" can be null value. But I don't want null to be considered by my Sort .

thanks

Hi,

What do you mean with "I don't want null to be considered by my Sort "? If records with null values for this field are in the result set the sort will have to take care of this, meaning you can sort them to the beginning or end of the result list. Sorting does not remove any result from the result list.

If you want to ignore the null values you could for example write a query which combines title and lastUpdateDate. In case you want to explicitly search for values which are null you will have to implement a custom bridge though, since per default null values are not indexed at all. However, with a custom bridge you can insert a chosen 'null' token. See also http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-115.

Hope this helps,
Hardy

Hardy, Thanks for your reply.

I resolved this by using my custom filter that ignores all the fields that has "null" in them