LiveReport error when run by non system Admin issue with Filter Permissions

Hi there,

I am wondering if anyone can tell me where I am going wrong with the below LiveReport. If a user with System Admin permissions runs the report it returns the correct results of Compound Documents (%1 being the container to search against). As soon as a standard user runs the report they get ORA-00904 Invalid Identifier. If I remove the Filter Permissions parameter %2 the report can be run by both standard user and System Admin with no errors. My problem is I need the report to filter the permissions when a standard user is running it.

We are on Content Server 10.5 SP1 Update 2015-12

select dtreecore.*,
kuaf.firstname as FrName,
kuaf.lastname as LaName,
kuaf.name as Username
from kuaf JOIN dtreecore
ON (KUAF.ID=DTreecore.UserID)
where (DTreecore.SubType=136)
AND %2
start with dtreecore.dataid = %1
CONNECT BY PRIOR dtreecore.DATAID = dtreecore.PARENTID

I am new to working with these reports so any help/ guidance would be very appreciated.

Many thanks,

Emma

Find more posts tagged with

Comments

sıɹɥɔ

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

Hi Emma,

Try using "DTree" instead of "DTreeCore"; I suspect that will resolve your problem. (I'm unsure as to why I've recently seen many people starting to use DTreeCore instead of DTree; there's rarely any need to do that.)

By the way, it's good to see you putting the permissions check in your query; that too is occasionally overlooked, and it's very important.

Hope this helps,

-chris

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, May 04, 2016 3:11 AM
To: eLink Recipient
Subject: LiveReport error when run by non system Admin issue with Filter Permissions

LiveReport error when run by non system Admin issue with Filter Permissions

Posted by Tutty, Emma On 05/04/2016 06:04 AM

Hi there,I am wondering if anyone can tell me where I am going wrong with the below LiveReport. If a user with System Admin permissions runs the report it returns the correct results of Compound Documents (%1 being the container to search against). As soon as a standard user runs the report they get ORA-00904 Invalid Identifier. If I remove the Filter Permissions parameter %2 the report can be run by both standard user and System Admin with no errors. My problem is I need the report to filter the permissions when a standard user is running it.We are on Content Server 10.5 SP1 Update 2015-12 select dtreecore.*,
kuaf.firstname as FrName,
kuaf.lastname as LaName,
kuaf.name as Username
from kuaf JOIN dtreecore
ON (KUAF.ID=DTreecore.UserID)
where (DTreecore.SubType=136)
AND %2
start with dtreecore.dataid = %1
CONNECT BY PRIOR dtreecore.DATAID = dtreecore.PARENTIDI am new to working with these reports so any help/ guidance would be very appreciated.Many thanks,Emma

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Emma_Tutty

Hi Chris,

Many thanks for the quick response. That has done the job. It was something so simple as well. The reason I have been using DTreeCore instead was because I had noticed the table name had changed when we recently upgraded to version 10.5. I will know now for the future.

Thanks again.

Emma

John Simon

Emma,

I notice you used the old connect by clause. Is the order of the heirarchy important to you OR are you just trying to look at everything under a specific node? If the order is not important then you should consider using DTreeAncestors...replace your "start with connect by" with a join to DTreeAncestors (ex: select dt.dataid from dtree dt join dtreeancestors dta on dt.dataid = dta.dataid where dta.ancestorid = XXXXX).

The "connect by" can cause performance issues, not such a big deal on smaller DBs but can have a big impact on larger systems.

Cheers...

Livelink_Admin

Could you, please, help me with the following – we need to create a report under folder which would contain the following information:

<![if !supportLists]>1. <![endif]>Object name

<![if !supportLists]>2. <![endif]>Object ID

<![if !supportLists]>3. <![endif]>Date created

<![if !supportLists]>4. <![endif]>Date last modified

<![if !supportLists]>5. <![endif]>Who created

<![if !supportLists]>6. <![endif]>Who modified it last

Thanks and Regards,

Mohammed Abdul Naser.

Phone:24670361.

Email:Mohammed.MN.Naser@pdo.co.om

sign

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, May 04, 2016 4:40 PM
To: eLink Recipient
Subject: RE LiveReport error when run by non system Admin issue with Filter Permissions

RE LiveReport error when run by non system Admin issue with Filter Permissions

Posted by Simon, John On 05/04/2016 08:38 AM

Emma,

The "connect by" can cause performance issues, not such a big deal on smaller DBs but can have a big impact on larger systems.

Cheers...

[To post a comment, use the normal reply function]
Topic:	LiveReport error when run by non system Admin issue with Filter Permissions
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

________________________________________ This e-mail, any attachment and response string contain information belonging to PDO, some or all of which information may be legally privileged, and is intended solely for the addressee(s). Please do not copy, forward or use this message or attachment except as permitted by the sender. If you are not the intended recipient, please delete this message and any attachment immediately and notify the sender of the wrong delivery. Any opinions, conclusions and views expressed in this message are solely personal to the sender unless the sender has sent the message with due authority of PDO. Petroleum Development Oman LLC (PDO) is incorporated in the Sultanate of Oman by Royal Decree as a limited liability company. Commercial Registration No.9999, Head Office: Mina Al-Fahal. P.O.Box 81, PC 100, Muscat, Sultanate of Oman.

image001.png

Livelink_Admin

Could you, please, help me with the following – we need to create a report under folder which would contain the following information:

<![if !supportLists]>1. <![endif]>Object name

<![if !supportLists]>2. <![endif]>Object ID

<![if !supportLists]>3. <![endif]>Date created

<![if !supportLists]>4. <![endif]>Date last modified

<![if !supportLists]>5. <![endif]>Who created

<![if !supportLists]>6. <![endif]>Who modified it last

Thanks and Regards,

Mohammed Abdul Naser.

Phone:24670361.

Email:Mohammed.MN.Naser@pdo.co.om

sign

RE LiveReport error when run by non system Admin issue with Filter Permissions

Posted by Simon, John On 05/04/2016 08:38 AM

Emma,

The "connect by" can cause performance issues, not such a big deal on smaller DBs but can have a big impact on larger systems.

Cheers...

[To post a comment, use the normal reply function]
Topic:	LiveReport error when run by non system Admin issue with Filter Permissions
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

image001.png