diff options
| author |   Sunder Tattavarada <statta@research.att.com> | 2020-02-26 15:28:02 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2020-02-26 15:28:02 +0000 |
| commit | a03dfa273ef6e196bf65acc54b9357d35eb0ed5e (patch) | |
| tree | 9445256604dd9acd97337d61339fd95b69be045e /ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion | |
| parent | 751a5e5776b4615c8d3333f7b7d37d17bbf775ba (diff) | |
| parent | 8e83c25788017acd56271a72286f7dcbc974e76d (diff) | |
Merge "Changes made to upgrade pom version"
Diffstat (limited to 'ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion')
| -rw-r--r-- | ecomp-portal-BE-common/src/main/webapp/WEB-INF/fusion/orm/EP.hbm.xml | 6 |
1 files changed, 6 insertions, 0 deletions
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"> |