You need to be careful not to mix property names (Java) and column names (SQL).
Joined: Jul 24, 2011
Thanks James for your guidance, I have try and the result appear the same ...I think it could be ITEM_gid duplication.
Currently, I'm pull all the record and use the if statement to filter out unnecessary return record..sound bad but working at the moment...I'll definitely try to make a simple sample after my tasks meet the timeline..
I'm just curious, our entity already define the relationship, do we still need to join again in the HQL? would it take as extra join?