Home General

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

    %1 User Input 1
    %2Filter Permissions

    This should be a good starting point for you.
  • Did you have a fix on this issue? I have the same problem with Facing same issue but no response from anyone and couldnt find this topic troubleshooting in google.

Sign In or Register to comment.