Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

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
Boost this thread!