Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/supplyroomconfig/service/SupplyRoomConfigManagerImpl.java =================================================================== diff -u -r29916 -r30226 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/supplyroomconfig/service/SupplyRoomConfigManagerImpl.java (.../SupplyRoomConfigManagerImpl.java) (revision 29916) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/supplyroomconfig/service/SupplyRoomConfigManagerImpl.java (.../SupplyRoomConfigManagerImpl.java) (revision 30226) @@ -917,7 +917,7 @@ boolean enableUrgentFunction = CssdUtils.getSystemSetConfigByNameBool("enableUrgentFunction", false); String orderColumnSqlByConfig = ""; if(enableUrgentFunction){ - orderColumnSqlByConfig = "po.urgentLevel.grade desc"; + orderColumnSqlByConfig = "case when po.urgentLevel is null then 0 else po.urgentLevel.grade end desc"; } if(StringUtils.isNotBlank(orderRuleOfDepartApplicationView)){ JSONArray jsonArray= JSONArray.fromObject(orderRuleOfDepartApplicationView);