Hql sort empty values are placed behind

Because some of the syntax of MySQL is not supported in HQL, so after querying all kinds of information to obtain

If the sort requirement is, if the A field is sorted (the A field is stored in a string of numbers), when the A field is empty, it is the last, and the empty one is sorted with the modified time modify_date, you can write

Order  by  Case  when Ifnull (A,")='then0Else1  Enddesc, A+0ASCASC

A+0 prevents the occurrence of 1,11,123,11234,2,3,4 when sorting occurs .... The situation

Hql sort empty values are placed behind