So the problem I am having is that I am required to sort by name, not id
however, my HQL will not return the myParentClass if myChildClass is null, but it will return the myParentClass if myChildClass is null and sort on id.
I have looked up in SQL where you would put
but I have try
and it's not working. Can someone help me out with this issue?
I don't see the point of using Java to sort if HQL does not return the row with myParentClass is null when I sort on myParentClass.name.
I am required to sort from Database level, not Java level and I think would be more difficult to sort in Java level for me anyways. Now to be clear, I don't need Null to be first or last, I just need HQL to display the rows with myParentClass is null. is it really not possible?
Thanks for your reply
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads