Live report-> Binder,Cases ,Contract Roles and usergroup

Dear All,

Has anyone tried written live report get role participants and groups assigned to a roles for the case ,binders, and contracts? please advise.

Cheers,

Find more posts tagged with

Comments

kumar dwarakanath

Guys, I was able to create query for getting roles names and user group assigned to the roles. I did smoke test. it seem work fine. but recommend to test it fully before you user.

SELECT k.NAME AS role,
       k.id   AS roleid,
       k.type,
       d.NAME,
       a.dataid,
       g.id,
       g.NAME AS usergorup
FROM   otcs.kuaf k,
       otcs.dtreeacl a,
       otcs.dtreecore d,
       otcs.kuafchildren c,
       otcs.kuaf g
WHERE  k.id= a.rightid
AND    d.dataid=a.dataid
AND    c.id=a.rightid
AND    c.childid=g.id
AND    a.dataid=417297 /* remove this condition if it is against whole system */
AND    k.type>=1000  /*ignore assigned usersgroups */