SpringData/Hibernate：按枚举的字段排序

Question

我在使用SpringData/Hibernate按自定义规则对枚举进行排序时遇到了一些小问题。

A有一个名为DeviceState的枚举，它有自己的优先级字段。

public enum DeviceState {
    ON(4), OFF(3), UPDATE(2), CRITICAL(0), WARNING(1);
    private final int priority;

    private DeviceState(int priority) {
        this.priority = priority;
    }

    public int getPriority() {
        return priority;
    }
}

枚举由DeviceEntity使用：

@Entity
public class Device implements Serializable {

    // .... other fields

    @Enumerated(EnumType.STRING)
    private DeviceState state;

    // ....
}

Page<Device> pagedDevices = deviceRepository.findAll(DeviceSpecifications.findByFilter(filter), pageable);

有线索吗，救命？点子？请记住，这是生产工作系统，我不能做任何“烟火”。

Answer 1

order by case 
  when state = 'CRITICAL' then 0
  when state = 'WARNING' then 1
  when state = 'UPDATE' then 2
  when state = 'OFF' then 3
  when state = 'ON' then 4
  end