Live report that fetches results according to the permissions of the one who is running it

Hi,

Would like to put forth a case of a document audit report :

Select distinct d1.name as "Document Name", REPLACE(dan2.auditstr,'Fetch','Download') as "Action", dan2.auditdate as "Date", k1.name as "User Name", k2.name as "Group name" from dtree d1, dauditnew dan2, kuaf k1,kuaf k2, dtreeancestors dac where dan2.dataid = d1.dataid and dan2.performerID = k1.id and k1.groupid = k2.id and d1.subtype=144 and d1.dataid = dac.dataid and dac.ancestorid = <someID> and k1.name!='Admin'

Suppose A is the coordinator of projects X1, X2.. and B is the coordinator of projects Y1, Y2. So, if A logs in and runs the report then A should see the results of the documents present only in X1, X2.. Similarly, if B logs in and runs the report, B should see the results of the documents present only in Y1, Y2.

How can the live report fetch result as to who is running it , and the same can be used in the report or a sub report ?

Find more posts tagged with

Comments

Appu_Nair1

and you are saying %1 Filter Permissions will not cut it?

sıɹɥɔ

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Hi Puratan,

The answer to your question will depend on theReport Format of your LiveReport.

If the Report Format for your LiveReport is "Livereport:" then the system knows the output consists of node items and as such can perform the access checks required i.e. can filter the response for the particular user running the report; I suspect this will be sufficient for your needs.

If the Report Format for your LiveReport is anything else, e.g. "Auto LiveReport", then all security checks are the responsibility of the author of the SQL. The "Filter Permissions" parameter may be helpful in implementing this (although whether it is sufficient may depend on what modules are installed on your system).

Hope this helps,

-chris

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, May 18, 2015 5:51 AM
To: eLink Recipient
Subject: Live report that fetches results according to the permissions of the one who is running it

Live report that fetches results according to the permissions of the one who is running it

Posted by puratan.pani@nationalgrid.com (Pani, Puratan) On 05/18/2015 08:48 AM

Hi,Would like to put forth a case of a document audit report :Select distinct d1.name as "Document Name", REPLACE(dan2.auditstr,'Fetch','Download') as "Action", dan2.auditdate as "Date", k1.name as "User Name", k2.name as "Group name" from dtree d1, dauditnew dan2, kuaf k1,kuaf k2, dtreeancestors dac where dan2.dataid = d1.dataid and dan2.performerID = k1.id and k1.groupid = k2.id and d1.subtype=144 and d1.dataid = dac.dataid and dac.ancestorid = <someID> and k1.name!='Admin' Suppose A is the coordinator of projects X1, X2.. and B is the coordinator of projects Y1, Y2. So, if A logs in and runs the report then A should see the results of the documents present only in X1, X2.. Similarly, if B logs in and runs the report, B should see the results of the documents present only in Y1, Y2. How can the live report fetch result as to who is running it , and the same can be used in the report or a sub report ?