how to select specific columns in hibernate search

Question

I need to select only few columns using hibernate search. Following is the code which works fine

  FullTextSession fts = org.hibernate.search.Search.getFullTextSession(getSession());

  org.apache.lucene.search.BooleanQuery query = prepareQuery(dto);
  fullTextQuery = fts.createFullTextQuery(query, ProfileBean.class);

  fullTextQuery.setFirstResult(dto.getProfileBean().getResultStartIndex());
  fullTextQuery.setMaxResults(dto.getProfileBean().getResultsLimit());

  List<ProfileBean> profiles = fullTextQuery.list();

In the above case I only want to select columns 'firstName' and 'lastName'.

Following code throws an exception

 List<String> projectedFields = new ArrayList<String>();
          projectedFields.add("firstName");
          projectedFields.add("lastName");

org.hibernate.search.SearchException: Projecting an unstored field: firstName

actually i don't want to store the firstName field in lucene any other suggession.?

Check http://stackoverflow.com/questions/10652358/how-do-you-select-a-column-using-hibernate?rq=1 — Sachin Gorade, Oct 18 '13 at 13:40
thanks for your reply. but above code doesn't work with hibernate search. — Ali, Oct 18 '13 at 13:42

score 1 · Answer 1 · edited Feb 08 '17 at 16:19

1

In your class ProfileBean, you'll need to add annotation:

@Field(store=Store.YES)

to fields firstname, lastname

Please find section 5.1.2.5. Projection in Hibernate documentation for details: https://docs.jboss.org/hibernate/search/3.2/reference/en/html/search-query.html#d0e3643

Happy coding!

edited Feb 08 '17 at 16:19

Ivar

6,138
12
49
61

answered Feb 08 '17 at 14:21

Mateusz Blaz

11
1

how to select specific columns in hibernate search

1 Answers1