Hi,
We have setup a smart search to search through 2 document types and need to filter them according to dropdown list value.

In the dropdown we have a list of states.
In document 1 we have a field "AddressState" with a single value (for example "NSW").
In document 2 we have a field "AddressStates" which can have multiple states separted by space (for example "VIC NSW ACT").

I have setup the filter string to be something like this "+( AddressState:NSW )" which works fine for document 1. However we need also to bring a result for document 2 if the "AddressStates" has a value "NSW".

The query should be "where AddressState = 'NSW' OR AddressStates like '%NSW%'"

From the Lucene documentation we cannot user wildcart "*" at the begining.

Currently we are thinking about running the result without filtering and then use code behind to loop through the result and filter it there.

Any suggestions?

Thank you
Peter