tags:

views:

577

answers:

0

There are two tables with no relation defined eg : Bugs and Comments

For each bug id there are multiple comments.Suppose I am using a query like

  • select b.bugid,b.bugtitle,c.comment from bugs b , comments c where b.bugid = c.bugid

In hibernate search ,is there any method to write text queries for multifield searches ?

In case, for a search :- title:h* + comm:exce*

I used this code

MultiFieldQueryParser mparser =   new MultiFieldQueryParser(new String[]
 { "comm",   "title" },new StandardAnalyzer());
Query q = mparser.parse("title:h* + comm:exce*");
FullTextQuery fq =fs.createFullTextQuery(q,org.sample.hibsearch.data.entity.LongDesc.class,
    org.sample.hibsearch.data.entity.Bug.class);

When i tried this the code resluts two entities ie execute two hqls than a single one i expected .

Is there any solution for these type of scenarios?