Hi,

I use Hibernate Search and have now the following problem. I don't want a query for a particular content but rather for all existing lucene data in a field (for field proposals in the ui).



Sample content:

id | name | cities
.. | abc | London, Paris, Berlin
.. | bcd | Paris, New York City, London
.. | cde |
.. | def | Berlin, Dallas, London


The query should return a set with the 5 elements: Berlin, Dallas, London, New York City and Paris.

What’s the way to do this, via org.hibernate.search.query.dsl.QueryBuilder or org.apache.lucene.index.IndexReader? I checked both but found no solution.

Every help is very appreciated.

Thanks a lot,
Detlev

Hi Detlev,



No query would return this for you, since w/ Hibernate Search you would get managed Conference instances back. At least in per default.
You could use the IndexReader for Conferences and its IndexReader.terms(Term t) method. Depending on how you are going to use it, it might work. For example I could imagine that you use it once and cache the cities. I definitely would not use it for every request.

One other way could be to model the Cities are their own class/entities. Depending on your use case that might or might not make sense. You can send build a separate city index and query it which is probably better performance. You could use wildcard queries as the user types.

Well, just some ideas.

--Hardy

Of this would in theory also be a good use case for faceting. However, Search does at the moment only support faceting for single values fields - https://hibernate.onjira.com/browse/HSEARCH-900

Thanks, that helped me!