Jpql query for BProc user select

Support
#1

Hi, everyone!

I am not being able to select users that have a particular role. Can you help me with that?

More specifically, I am trying to model BProc and want to have a user for a particular input dialog parameter. However, only users with a particular role need to be selected.

Something like select u from User u where (:role in u.roles)

#2

Hi,
try something like this:

select u from sec$User u join u.userRoles ur where ur.role.name = 'TestRole1'
1 Like