• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How do I use JOINS in my Hibernate Search (FullText) query??

 
Nina Anderson
Ranch Hand
Posts: 148
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys,

I'm new to using Hibernate Search and I have no clue what I'm doing. I have an existing hibernate search query that I'm trying to change to that advantage of FullText query capabilities. My current query uses JOINs and I'm wondering how I can write JOIN queries with fullTextSession.createFullTextQuery().

Here's my current code:


In this example, the 3 tables I need to join are BUSINESS, BUSINESS_ADDRESS, and ADRESS

And I have selected BUSINESS.Business_Name, ADDRESS.City_Name, ADDRESS.State and the 3 IDs as the indexed fields.

How can I change this to a FullTextQuery?
This is what I have so far:


Unfortunately, they are NO examples on using JOINS out there!!! Please...Help!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic