Question & Answer > View Question

List by Group of User

Confluence User - 11 Nov, 2021

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!

datalists;user;groups

1

Confluence User •

12 Nov, 2021 •

confluenceUser •

1 •

confluenceUser •

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.

1

CSV | Excel | XML | PDF

Your answer

Print

List by Group of User

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

List by Group of User.builder-style-ba43d394-0937-4876-8b9a-0655254b904b{background: #efefef59 !important; margin: 0px !important; padding: 10px !important; border-radius: 5px !important; border: 1px solid #ddd !important; text-align: left !important; color:#0E4A40 !important;}

1.builder-style-46e0dd54-381b-4f3b-8ae1-0001c6498043{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-6a5820d6-788f-4b8e-bfcf-a1c2e78c56b1{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

List by Group of User

1

Your answer