Products & Solutions
Project Permissions LiveReport or WebReport
I'm struggling to create a LR or WR which will show all the projects and their participants. Does anyone know what I need to do to create it?
Thanks in advance.
Saame problem. but i think this will help us
To list Roles in Projects and Communities for a user, I use the following query (on Oracle):
SELECT g.ID "groupID", g.NAME "Group", dtree.DATAID "ProjectID",dtree.NAME "Project", decode(dtree.SUBTYPE, 202, 'Project', 3030202, 'Community', 'Unknown') "Type" FROM kuaf g, dtree WHERE (g.TYPE = 1 OR g.TYPE >= 2000) AND g.deleted = 0 AND g.TYPE = dtree.dataid AND g.ID IN ( SELECT ID FROM kuafchildren START WITH childid = %1 CONNECT BY PRIOR ID = childid) AND %2 ORDER BY dtree.NAME, g.NAME
User Input 1
This should be a good starting point for you.