List by Group of User

 
1
0
-1

Hi everyone,


I am trying to create a list, which displays all users of a certain group. In that list I would like to track the number of assignments in the individual Users inbox, and of course the name, etc.

But currently I can't figure out how to select users by group. My first idea was to use the Joget Entity Databinder and add the constraint in the extra conditions field, but I don't think I can do that, because the group of the user is not contained in the user table - or so I think.


Thank you for your help!

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      Hi, I don't believe the Joget Entity Data Binder allows joining multiples entities so I would suggest using the JDBC Datalist Database Binder. With it, you can use a custom SQL query to retrieve the kind of data you need by joining the dir_user, dir_group and dir_user_group tables.

        CommentAdd your comment...