How to do SQL IN like query in hibernate search

Question

A simulating scenario is:

Search for books whose content contains "success" AND author is in a list of passed names(could be thousands of).

I looked into filter: http://docs.jboss.org/hibernate/stable/search/reference/en-US/html_single/#query-filter

Seams like hibernate search has no native support of this.

What is recommended approach for this problem? I think I am not alone.

Thanks for any inputs.

Answer 1

Let me post my current solution.

Get the search results with minimal projections for the keywords, and loop through the results to get only matching ones from the IN list.

I am not using filter.

Open to other alternatives once convinced.