How to use enum in @Query as a constant

Question

I have tried to put a full class path (com.xxxx.State.Finish) after != but not helping.

@Query("select c from CustomOrder c where c.dealer = :roleName and 
     c.nextManager = null and c.currentState != Finish")
List<CustomOrder> findOpenOrder(@Param("roleName") String roleName);

Entity:

@Getter
@Enumerated(EnumType.STRING)
CustomOrderEnums.State currentState;

Enum:

public enum State {
    Open, Finish
}

Answer 1

@Query("select c from CustomOrder c where c.dealer = :roleName and 
     c.nextManager = null and c.currentState != com.xxx.FooEnum.Finish")

FooEnum has to be a top class not an inner one. If it has to be an inner class, use ' quoted string (haven't tried it without ').

@Query("select c from CustomOrder c where c.dealer = :roleName and 
     c.nextManager = null and c.currentState != 'Finish'")

I have just found that instead of using @Query it could be simply used as:

List<User> findIdByRoleRoleAndProvinceType(String role, ProvinceEnum.ProvinceType provinceType);

and this is entity User:

@Entity
public class User {
    Role role; // entity has a String field role;
    Province province; // entity has a ProvinceEnum.ProvinceType field type.
...
}