How do I use JOINS in my Hibernate Search (FullText) query??
posted 8 years ago
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!