From 8e83c25788017acd56271a72286f7dcbc974e76d Mon Sep 17 00:00:00 2001
From: Sudarshan Kumar <sudarshan.kumar@att.com>
Date: Tue, 18 Feb 2020 16:16:26 +0530
Subject: Changes made to upgrade pom version

Upgraded pom version

Issue-ID: PORTAL-769
Change-Id: I65ae68acda464531d699dcb459d328de19a3c7c7
Signed-off-by: Sudarshan Kumar <sudarshan.kumar@att.com>
---
 .../src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml                   | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion')

diff --git a/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml
index e03c9762..961006cc 100644
--- a/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml
+++ b/ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml
@@ -571,6 +571,12 @@
 			from Language where languageId = :language_id
 		]]>
 	</query>
+	
+	<query name="getActiveUsersForApp">
+		<![CDATA[
+			select distinct(u) from EPUser as u inner join fetch u.EPUserApps as apps inner join fetch apps.app as app inner join fetch apps.role as role where app.id = :id and u.active = :active and role.id is not null
+		]]>
+	</query>
 
 	<!-- show the current user plus related users -->
 	<sql-query name="relatedUsers">
-- 
cgit 1.2.3-korg