Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Piush

Awaiting Email Confirmation
Registered:
Posts: 6
Reply with quote  #1 
Hi... I'm trying to build a dropdown using a SQL SELECT statement that will list all users that have been granted a specific ROLE within "Users and Roles".  The problem I have is, the users are in table eUser and the roles are in table eRole however they don't seem to have a common field to link on.  Am I looking at the wrong tables? Clearly there must be a way to achive this as the designer itself stores this relationship for the Roles option to work!

Any help is welcome.
0
jpesout

Avatar / Picture

Veteran
Registered:
Posts: 107
Reply with quote  #2 
Hello Piush, the relationship between users and roles is in the eAssignment table.
0
Piush

Awaiting Email Confirmation
Registered:
Posts: 6
Reply with quote  #3 
Excellent... thank you very much jpesout!
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!