Hi,

How do I specify a search like this in Hibernate Search?

select * from table where keyword is "java" and location in "new york " and category in "Science" ?

I was using <ultifieldparser but it is not working. It is returning all the field.

String[] queries = new String[]{keyword,location, category};
String[] fields = new String[]{"title","category","city", "state","zipcode"};
String preProcessedSearchTerms = new QueryTermsProcessor()
.processQueryTerms(criteria, new String[] {
"title","category","city", "state","zipcode" },
QueryOperator.OR);
MultiFieldQueryParser parser = new MultiFieldQueryParser(fields,new StandardAnalyzer());
// System.out.println(query.toString());
EntityManager em = this.jobDao.getEm();

org.apache.lucene.search.Query query = parser.parse(preProcessedSearchTerms);

FullTextEntityManager fullTextEntityManager = Search
.getFullTextEntityManager(em);
FullTextQuery fullTextQuery = fullTextEntityManager
.createFullTextQuery(query, Job.class);

Any hints?

Thanks,

I guess you're looking for something like this



That would match all documents that contain keyword java, location "new york" and category science.

That is the simplest approach. You refer to the query syntax in lucene to get more information http://lucene.apache.org/java/2_4_0/que ... yntax.html

Hi,

what i want is to get all java job located in New York and in the science category.

How can i express that.

The Query will in sql like that:

select * from job where keyword ='java' and city in('New York') and category in ('science');

Thanks,