Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java =================================================================== diff -u -r30165 -r30225 --- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java (.../InvoicePlanManagerImpl.java) (revision 30165) +++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java (.../InvoicePlanManagerImpl.java) (revision 30225) @@ -1753,7 +1753,7 @@ String extraOrder = ""; if(enableUrgentFunction){ extraJoin = " left join fetch po.urgentLevel "; - extraOrder = " po.urgentLevel.grade desc,"; + extraOrder = " case when po.urgentLevel is null then 0 else po.urgentLevel.grade end desc,"; } String queryColumnSql = " select po from InvoicePlan po " + extraJoin; String whereSql = " where po.committedStatus=1 ";