I have written a bespoke search webpart powered by the Enterprise Search FullTextSqlQuery object (MOSS 2007). Everything is working well apart from one slight hiccup:
Part of the requirement is to be able to filter the result set using the value of a metadata property on the list items. This property is of the Multi-Valued Lookup type. A user would assign one or more lookup values to the item and then would expect it to be returned in the search results when one or more of these values matches the filter criteria.
I've looked all over Google and I can't find any examples of where a multi-valued lookup field has been used in the WHERE clause of a full text sql query. Could anyone point me in the right direction?
Thanks very much,
View Complete Post