I'm trying to use lucene in my project to search for people.
I created the index using records from a db table of people (firstname, lastname, social, phone, address, etc). However, in the db, some of these fields are missing (ie, no address supplied).
In my project, users can search for a person using fields from the db table/index. But is there a way to exclude search fields where the index value is empty?
For example, the db record is:
and the user searches using these fields:
No matches come up because it is matching 123-45-6789 against an empty value. But I would still like John/Doe/<empty> to come up (even if there is more than one record like that)