Hibernate Community • View topic - query order by an empty field doesn't return every rows

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

query order by an empty field doesn't return every rows

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Sepharat

Post subject: query order by an empty field doesn't return every rows

Posted: Fri Mar 05, 2010 8:40 am

Newbie

Joined: Thu Feb 18, 2010 6:11 am
Posts: 5

Hi, I have a query like this
select t from Orders t order by t.merchanType.varMercTypeDescription desc
The problem I have is if the field merchanType is empty, the query doesn't return that row. I have a grid where I want to let the user order by field. The other fields are always filled so it works great with them but when I order by this merchaType field it just returns those not empty. Anyone knows how can I resolve this?
Thank you

Top

nordborg

Post subject: Re: query order by an empty field doesn't return every rows

Posted: Fri Mar 05, 2010 9:25 am

Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden

You'll need to do an explicit left join if you want to keep null associations:

Code:

select t from Orders t left join t.merchanType m order by m.varMercTypeDescription desc

The implicit join (dot notation) results in an inner join which excludes null associations.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum