Order by nullable property simultaneously with ordering by not nullable property in HQL

Posted by Episodex on Stack Overflow See other posts from Stack Overflow or by Episodex
Published on 2010-03-08T14:03:31Z Indexed on 2010/03/08 14:06 UTC
Read the original article Hit count: 408

Filed under:

hql

|

order-by

Hi, I have a table called Users in my database. Let's assume that User has only 3 properties

int ID; string? Name; string Login;

If user doesn't specify his name then Login is displayed. Otherwise Name is displayed. I wan't to get list of all users sorted by what is displayed. So if user specified Name, it is taken into consideration while sorting, otherwise his position on the list should be determined by Login. Eventually whole list should be ordered alphabetically. I hope I made myself clear...

Is that possible to do in HQL?

© Stack Overflow or respective owner

Related posts about hql

HQL Query Not Running

as seen on Stack Overflow - Search for 'Stack Overflow'
select new UpdateCountDataBean(count(elements(am.actionId)) as noOfUpdates, am.pname as name) from ActivityMaster am group by am.pname The UpdateCountDataBean is created by me while the second class i.e. ActivityMaster is POJO class. java.lang.NullPointerException at org.hibernate.hql.ast.tree… >>> More
Whats wrong with this HQL query?

as seen on Stack Overflow - Search for 'Stack Overflow'
did i encounter a hibernate bug or do i have an error i dont see: select enty.number from EntityAliasName enty where enty.myId in ( select cons.myId from Consens cons where cons.number in ( select ord.number from Orders ord where ord.customer = :customer and ord.creationDate… >>> More
Hibernate Query Exception

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a hibernate query I'm trying to get working but keep getting an exception with a not so helpful stack trace. I'm including the code, the stack trace, and hibernate chatter before the exception is thrown. If you need me to include the entity classes for MessageTarget and GrpExclusion let… >>> More
hql equivalent query to this sql query

as seen on Stack Overflow - Search for 'Stack Overflow'
Select top 1 from <tablename> what is hql query for the above ? >>> More
Subquery using derived table in Hibernate HQL

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Hibernate HQL question. I'd like to write a subquery as a derived table (for performance reasons). Is it possible to do that in HQL? Example: FROM Customer WHERE country.id in (SELECT id FROM (SELECT id FROM Country where type='GREEN') derivedTable) (btw, this is just a sample query so… >>> More

Related posts about order-by

CakePHP: find neighbors, order on 'name' or 'order'

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a list of ordered items, ordered according to the int field order. I'm creating a gallery in CakePHP 1.2 that has a prev and next button and those should link to the previous and next item according to their ordering, not according to their id. In order to get this result I've included… >>> More
Linq-to-sql orderby thenby

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using the following query syntax from table where where orderby orderby Where the first orderby is a date and second orderby is a date. I would assume this would work like orderby thenby but appears to be doing something else. 1 How can I do an orderby thenby using the above syntax without… >>> More
MySQL stuck on "using filesort" when doing an "order by"

as seen on Stack Overflow - Search for 'Stack Overflow'
I can't seem to get my query to stop using filesort. This is my query: SELECT s.`pilot`, p.`name`, s.`sector`, s.`hull` FROM `pilots` p LEFT JOIN `ships` s ON ( (s.`game` = p.`game`) AND (s.`pilot` = p.`id`) ) WHERE p.`game` = 1 AND p.`id` <> 2 AND s.`sector` = 43 AND s.`hull`… >>> More
how to get the int order sorting asc, the order field already in varchar type

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the field receiptno as varchar and want to sort this, if normal order sorting getting wrong sorting value. Then have the idea to sort the field by convert int type. Is there anyway to converting int type in query itself >>> More
Treeset to order elements in descending order

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the piece of code that I have used for Java 5.0 TreeSet<Integer> treeSetObj = new TreeSet<Integer>( Collections.reverseOrder() ) ; Collections.reverseOrder() is used to obtain a comparator in order to reverse the way the elements are stored and iterated. Is there a more optimized… >>> More