• 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!
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!