+
+@NamedNativeQuery(
+ name = "PortalAdmin.PortalAdminDTO",
+ query = "SELECT " +
+ "u.id AS userId, " +
+ "u.loginId AS loginId " +
+ "u.firstName AS firstName " +
+ "u.lastName AS lastName " +
+ "FROM " +
+ "FnUser u, " +
+ "FnUserRole ur " +
+ "WHERE u.activeYn = 'true' AND u.user_id = ur.user_id AND ur.role_id= :adminRoleId",
+ resultSetMapping = "PortalAdminDTO")
+@NamedNativeQuery(
+ name = "PortalAdmin.ActivePortalAdminDTO",
+ query = "SELECT " +
+ "u.id AS userId, " +
+ "u.loginId AS loginId " +
+ "u.firstName AS firstName " +
+ "u.lastName AS lastName " +
+ "FROM fn_user u, fn_user_role ur " +
+ "WHERE u.user_id = ur.user_id " +
+ "AND ur.user_id= :userId " +
+ "AND ur.role_id=:SYS_ADMIN_ROLE_ID",
+ resultSetMapping = "PortalAdminDTO")
+
+@SqlResultSetMapping(
+ name = "PortalAdminDTO",
+ classes = @ConstructorResult(
+ targetClass = PortalAdmin.class,
+ columns = {
+ @ColumnResult(name = "userId"),
+ @ColumnResult(name = "loginId"),
+ @ColumnResult(name = "firstName"),
+ @ColumnResult(name = "lastName")
+ }
+ )
+)
+