Workflow Proxy data in LiveReport

I am trying to create a LiveReport that shows which users have assigned a workflow proxy and who that is. As many people are using this but the recipients aren't always aware of whom they have been proxyed by.Can someone tell me please that where Livelink stores the workflow proxy data or someone is already having this type of LiveReport?

Find more posts tagged with

Comments

Developers_Comparex_Africa_(x-comparexdevelopment_

I have attached 2 Oracle queries which might help you with the LiveReport you are trying to create...

Ed_McCafferty_(emccafferty@momentumsystems.com_(De

I just ran into this the other day and had to come up with a report to return all users with a proxy defined and who the proxy is. Create a new livereport and put the following statement in the SQL box (must be a continuous string..one line):SELECT PROXY_DESIGNATOR.NAME PROXY_DESIGNATOR,PROXY_DESIGNEE.NAME PROXY_DESIGNEE FROM (SELECT A.NAME, B.ID FROM LIVELINK.KUAF A, LIVELINK.KUAFPROXY B WHERE A.ID = B.ID) PROXY_DESIGNATOR, (SELECT A.NAME, B.ID FROM LIVELINK.KUAF A, LIVELINK.KUAFPROXY B WHERE A.ID = B.PROXYID AND B.ID<>B.PROXYID) PROXY_DESIGNEE WHERE PROXY_DESIGNATOR.ID = PROXY_DESIGNEE.ID