X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=portal-BE%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fportal%2Fdomain%2Fdto%2Ftransport%2FEPUserAppCurrentRoles.java;h=d994f6a0ab4c4fb1a83f2fc1a3ba4bed973c5128;hb=39fb119cdaea6bd8d801b22d195db39f6d8faaca;hp=249aee1195491fdb507aa42975c7f25cfee77246;hpb=2eaf7baff879929156699033bf62d29c0fd0040f;p=portal.git

diff --git a/portal-BE/src/main/java/org/onap/portal/domain/dto/transport/EPUserAppCurrentRoles.java b/portal-BE/src/main/java/org/onap/portal/domain/dto/transport/EPUserAppCurrentRoles.java
index 249aee11..d994f6a0 100644
--- a/portal-BE/src/main/java/org/onap/portal/domain/dto/transport/EPUserAppCurrentRoles.java
+++ b/portal-BE/src/main/java/org/onap/portal/domain/dto/transport/EPUserAppCurrentRoles.java
@@ -42,11 +42,47 @@ package org.onap.portal.domain.dto.transport;
 
 import com.fasterxml.jackson.annotation.JsonInclude;
 import java.io.Serializable;
+import javax.persistence.ColumnResult;
+import javax.persistence.ConstructorResult;
+import javax.persistence.NamedNativeQuery;
+import javax.persistence.SqlResultSetMapping;
 import lombok.AllArgsConstructor;
 import lombok.Getter;
 import lombok.NoArgsConstructor;
 import lombok.Setter;
 
+@NamedNativeQuery(
+		name = "EPUserAppCurrentRoles",
+		query = "select\n"
+				+ "  distinct fu.role_id,\n"
+				+ "  fr.user_id,\n"
+				+ "  fu.role_name,\n"
+				+ "  fu.priority\n"
+				+ " from\n"
+				+ "  fn_role fu\n"
+				+ "  left outer join fn_user_role fr ON fu.role_id = fr.role_id\n"
+				+ "  and fu.app_id = fr.app_id\n"
+				+ "  and fr.role_id != 999\n"
+				+ " where\n"
+				+ "  fu.app_id = :appId\n"
+				+ "  and fr.user_id = :userId\n"
+				+ "  and fu.active_yn = 'Y'\n",
+		resultSetMapping = "EPUserAppCurrentRoles"
+)
+
+@SqlResultSetMapping(
+		name = "EPUserAppCurrentRoles",
+		classes = @ConstructorResult(
+				targetClass = EPUserAppCurrentRoles.class,
+				columns = {
+						@ColumnResult(name = "roleName"),
+						@ColumnResult(name = "userId"),
+						@ColumnResult(name = "priority"),
+						@ColumnResult(name = "roleId")
+				}
+		)
+)
+
 @Getter
 @Setter
 @NoArgsConstructor