Report that shows my communities

Jörg_Heyne

Please help me with a report, that shows all communities that i am assigned to.

Thanks and best regards,

Joerg

Colin_Schmidt

Try this in Oracle.  It lists other groupings, as well.

select k1.name "User", k2.name "Group", 

case 

  when k2.type = 0 then 'User' 

  when k2.type = 1 then 'Group' 

  when k2.type = 3 then 'System' 

  when k2.type = 4 then 'Admin Group' 

  when k2.type = 5 then 'Domain' 

  when k2.type = 6 then 'X-Domain' 

  when k2.type = 101 then 'Signing Group' 

  when k2.type = 102 then 'eSign' 

  when k2.type < 0 or k2.type > 1000 then case dt.subtype 

              when 202 then 'Project' 

              when 3030002 then 'Community template' 

              when 3030201 then 'Community vol.' 

              when 3030202 then 'Community' 

              else 'Other ['||to_char(dt.subtype)||']' end 

  else 'Other ['||to_char(k2.type)||']' end Ktype, 

dt.dataid, NVL(dt.name, 'n/a') "Proj./Comm." 

from kuafchildren kc 

  join kuaf k1 on kc.childid = k1.id and k1.deleted = 0 and k1.type = 0 and k1.id = ????

  join kuaf k2 on kc.id = k2.id 

  join dtree dt on k2.type = dt.dataid

Colin J. 

On Mon, Feb 17, 2014 at 8:16 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Report that shows my communities

Posted byjoerg.heyne@gesis.de (Heyne, Jörg)On 02-17-2014 08:12

Please help me with a report, that shows all communities that i am assigned to. Thanks and best regards, Joerg

---

[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.