X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=portal-BE%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fportal%2Fdomain%2Fdb%2Ffn%2FFnUserRole.java;fp=portal-BE%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fportal%2Fdomain%2Fdb%2Ffn%2FFnUserRole.java;h=f3fdec1e1f66f4124bdfb24a74f694746958ed0a;hb=dd4c51e4349b596766f2fda555a7a0d3ba46e9fa;hp=06320c4c82b707df77d2838693a80250c5053e7d;hpb=d904fc786956891946e7bd92b559fdb98f62330f;p=portal.git

diff --git a/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnUserRole.java b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnUserRole.java
index 06320c4c..f3fdec1e 100644
--- a/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnUserRole.java
+++ b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnUserRole.java
@@ -144,7 +144,10 @@ CREATE TABLE `fn_user_role` (
                         + "  FnUserRole userrole\n"
                         + "WHERE\n"
                         + "  userrole.roleId.roleId = :roleId\n"
-                        + "  AND userrole.appId.appId = :appId"
+                        + "  AND userrole.appId.appId = :appId"),
+        @NamedQuery(
+            name = "FnUserRole.retrieveByAppIdAndUserId",
+            query = "from FnUserRole where appId.appId =:appId and userId.userId =:userId"
         )
 })