I am having some trouble with getting the related entity using JPQL query.
For example when I am trying getting User roles using this query:
UserRole> existingUserRoles = dataService.loadList(LoadContext.create(UserRole.class) .setQuery(LoadContext.createQuery("select ur from sec$UserRole ur join fetch ur.role where ur.user.login = :user_login") .setParameter("user_login", user.getLogin())) );
it fails to load the UserRole.role field and accessing it throws an java.lang.IllegalStateException: Cannot get unfetched attribute [role] from detached object com.haulmont.cuba.security.entity.UserRole.
I have also tried different forms of join, based on JPQL documentation but still got the same result.
What is the proper way of doing this?