Home General

Project Permissions LiveReport or WebReport

Hi,

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.

Comments

  • 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

    with
    %1 User Input 1
    %2Filter Permissions

    This should be a good starting point for you.
Sign In or Register to comment.