Re: indexing values which might be null

2005-06-21 Thread Robert Newson
An approach I've used successfully is to add a separate field called 'empty' and include the names of other fields that are empty, e.g, empty: subject You can search for; +empty:subject for messages with empty (null) subjects. This approach means you don't need to think of a magical value

Re: indexing values which might be null

2005-06-21 Thread Otis Gospodnetic
Hi George, A field value needs to be indexed if you want to sort by it - see http://www.lucenebook.com/search?query=index+for+sorting . As for null fields, you could use an empty string, or better yet, some "custom field value" that means "NULL" for your application. Otis --- George Abraham <[

indexing values which might be null

2005-06-21 Thread George Abraham
Hi, I am using Lucene to index database content. I have two questions: 1. Along with some of the fields that I want indexed, there are some fields that I want stored (not indexed) in the index so as to return with hits. However I also want to be able to sort a search result using these non-indexed