- @NamedNativeQuery(
- name = "FnUserRole.retrieveUserRoleOnUserIdAndRoleIdAndAppId",
- query = "FROM FnUserRole where user_id= :userId"
- + " and role_id= :roleId"
- + " and app_id= :appId"),
- @NamedNativeQuery(
- name = "FnUserRole.retrieveCachedAppRolesForUser",
- query = "FROM FnUserRole where user_id= :userId"
- + " and user_id= :userId"
- + " and app_id= :appId"),
- @NamedNativeQuery(
- name = "FnUserRole.isSuperAdmin",
- query = "SELECT"
- + " user.USER_ID as userId,"
- + " user.org_user_id as orgUserId,"
- + " userrole.ROLE_ID as roleId,"
- + " userrole.APP_ID as appId"
- + " FROM"
- + " fn_user_role userrole"
- + " INNER JOIN fn_user user ON user.USER_ID = userrole.USER_ID"
- + " WHERE"
- + " user.org_user_id = :orgUserId"
- + " AND userrole.ROLE_ID =:roleId"
- + " AND userrole.APP_ID =:appId",
- resultSetMapping = "UserRole",
- resultClass = UserRole.class
- )
+ @NamedNativeQuery(
+ name = "FnUserRole.retrieveUserRoleOnUserIdAndRoleIdAndAppId",
+ query = "FROM FnUserRole where userId= :userId"
+ + " and role_id= :roleId"
+ + " and app_id= :appId"),
+ @NamedNativeQuery(
+ name = "FnUserRole.retrieveCachedAppRolesForUser",
+ query = "FROM FnUserRole where userId= :userId"
+ + " and userId= :userId"
+ + " and app_id= :appId"),
+ @NamedNativeQuery(
+ name = "FnUserRole.isSuperAdmin",
+ query = "SELECT"
+ + " userId.id as userId,"
+ + " userId.org_user_id as orgUserId,"
+ + " userrole.ROLE_ID as roleId,"
+ + " userrole.APP_ID as appId"
+ + " FROM"
+ + " fn_user_role userrole"
+ + " INNER JOIN fn_user user ON user.USER_ID = userrole.USER_ID"
+ + " WHERE"
+ + " user.org_user_id = :orgUserId"
+ + " AND userrole.ROLE_ID =:roleId"
+ + " AND userrole.APP_ID =:appId",
+ resultSetMapping = "UserRole",
+ resultClass = UserRole.class
+ )