Report which lists all Groups, a User can Edit (is member of GroupLeader)

Hallo

How to get a list of all Groups a User can edit?

Basically i need out of the result of this page all the Group-Names, where the User has an "edit" link (not a "view" Link)

?func=user.listusers&_ug_targetType=3&_ug_searchType=1&_ug_action=0&_ug_searchOpr=1&_ug_pageNum=0&_ug_startValue=&_ug_startId=0&_ug_groupId=-1&_ug_rowsRequest=30&_ug_sortCols=LASTNAME|NAME&_ug_spaceID=0&_ug_searchColumn=0&_ug_searchValue=%25

Where is this information available (something like kuafACL?)

Or do i need to "go back" all "GroupLeaderId"? How to do this efficient (think about a user is member of GlobalFinanceAdmin, wich is Member of LocalFinanceAdmin, wich is member of RegionalFinanceAdmin wich is Group Leader in ReginalFinanceDepartment)

Thomas

Find more posts tagged with

Comments

Colin_Schmidt

A mixture of KUAF & KUAFCHILDREN.

Colin J. Schmidt

Opentext Content Server Support Admin

colin.schmidt@mwv.com
+1 804.444 5012 (Direct)

MWV
501 South 5th Street
Richmond, VA 23219-0501
mwv.com

On Thu, Jul 18, 2013 at 11:06 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Report which lists all Groups, a User can Edit (is member of GroupLeader) Posted bythomas.heusser@infocentricresearch.com (Heusser, Thomas)On 07-18-2013 11:05

Hallo How to get a list of all Groups a User can edit? Basically i need out of the result of this page all the Group-Names, where the User has an "edit" link (not a "view" Link) ?func=user.listusers&_ug_targetType=3&_ug_searchType=1&_ug_action=0&_ug_searchOpr=1&_ug_pageNum=0&_ug_startValue=&_ug_startId=0&_ug_groupId=-1&_ug_rowsRequest=30&_ug_sortCols=LASTNAME|NAME&_ug_spaceID=0&_ug_searchColumn=0&_ug_searchValue=%25 Where is this information available (something like kuafACL?) Or do i need to "go back" all "GroupLeaderId"? How to do this efficient (think about a user is member of GlobalFinanceAdmin, wich is Member of LocalFinanceAdmin, wich is member of RegionalFinanceAdmin wich is Group Leader in ReginalFinanceDepartment) Thomas
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Thomas Heusser

Hi Colin

Thank you, so you mean follow the Groupleader - Path

This becomes quite fast quite complicated, isn't it. So i wonder, that the ?func=user.listusers&... is as fast

With 3 levels it will be something like this?:

/*get id's of all Groups where "User A" is GroupLeader*/
select ... kuaf where ledarid = UserA-Id

union

/* get id's of all Groups where the inner GroupId's are GroupLeader */
select ... kuaf where ledarid in (

/* get id's of all Groups, where "User A" is Member of */
select ... from kuaf join kuafchildren join kuaf ... where childrenId = UserA-Id

)

union

/* get id's of all Groups, where the inner Groups (which are Groupleader) are Member of */
select ... from kuaf join kuafchildren join kuaf ... where chidrenId in (