This week's book giveaways are in the Scala and Android forums.
We're giving away four copies each of Machine Learning Systems: Designs that scale and Xamarin in Action: Creating native cross-platform mobile apps and have the authors on-line!
See this thread and this one for details.
Win a copy of Machine Learning Systems: Designs that scale this week in the Scala forum
or Xamarin in Action: Creating native cross-platform mobile apps in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

TypedQuery Returns no Results  RSS feed

 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Greetings. I'm hoping someone can point out the fault in my logic:

The actual query is more complex, but for the sake of brevity it looks like: select t from table t left join t.pendingemployee.name as name left join t.employee.name as _name where name LIKE '%Bob%' or _name LIKE '%Bob%'

The reason for two joins is one of them will always be null; it's a workflow. When the workflow reaches it's conclusion, the data is stored in the table of the second join, and the link to the former is removed from the table. But I want to search across both of them starting with the table. Furthermore, Employee is the superclass of PendingEmployee (not sure if that matters, but thought it was prudent to mention). Both are annotated with @Entity and @Table, and Employee is @Inheritance(strategy=InheritanceType.JOINED) and PE is @PrimaryKeyJoinColumn(name="id")

Anyway, this query returns no results, no errors, nothing.

Any help would be greatly appreciated. Thanks in advance.
 
A sonic boom would certainly ruin a giant souffle. But this tiny ad would protect it:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!