This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Report on PersonWantsOrg: user see all requests

Hi,

 

I'm trying to implement a report fot the productOwner that show only the requests an owner can see.

A product owner can be owner of more than a product so in object browser an user that is owner of 2 products will see only request for those products but in a report he can see all the requests.

I thought the permission on what an user can see will be applied to the report too.

Any advice?

 

(7.1)

Parents
  • In report editor I set a datasouce with the following query:

    select r.DisplayName, g.cn as Role, p.LastName + ' ' + p.FirstName as Person, s.ident_PwoState as Status, pwo.CCC_RequestCode as RequestCode, pwo.OrderDate as OrderDate from PersonWantsOrg pwo
    join UNSGroupB g on pwo.ObjectKeyOrdered = g.xobjectkey
    join Person p on pwo.UID_PersonOrdered = p.UID_Person
    join PWOState s on s.UID_PWOState = pwo.UID_PWOState
    join UNSRootB r on r.UID_UNSRootB = g.UID_UNSRootB
    order by 1,2

    Then i create a band with each column of the item in the select.

    From web portal I subscribed to that report and hit mail icon to generate immediatly a mail with the report attached...

Reply
  • In report editor I set a datasouce with the following query:

    select r.DisplayName, g.cn as Role, p.LastName + ' ' + p.FirstName as Person, s.ident_PwoState as Status, pwo.CCC_RequestCode as RequestCode, pwo.OrderDate as OrderDate from PersonWantsOrg pwo
    join UNSGroupB g on pwo.ObjectKeyOrdered = g.xobjectkey
    join Person p on pwo.UID_PersonOrdered = p.UID_Person
    join PWOState s on s.UID_PWOState = pwo.UID_PWOState
    join UNSRootB r on r.UID_UNSRootB = g.UID_UNSRootB
    order by 1,2

    Then i create a band with each column of the item in the select.

    From web portal I subscribed to that report and hit mail icon to generate immediatly a mail with the report attached...

Children
No Data