Livereport to show items that are opened after they are placed in the recycle bin

Hello,

Can anyone help me to create a query to show the documents that are opened after they are placed inside the recycle bin.

Currently i have:

Select
d.ownerid,
d.parentid,
d.dataid,
k.firstname,
k.middlename,
k.lastname,
d.aclcount,
d.name,
d.subtype,
dad.auditstr,
dad.performerid,
dad.eventid,
dad.valuekey,
dad.auditdate
from dtree d, dauditnew dad, kuaf k
where
k.id = dad.performerid and
dad.auditstr = 'Fetch' and
d.dataid = dad.dataid
start with d.dataid=30426565
connect by ABS(d.parentid) = PRIOR d.dataid

The problem is that also the documents are showed that are opened before they where placed into the recycle bin

Any help would be apreciated

Tom

Find more posts tagged with

Comments

Rinita_Pranaykanti

Hi Tom

Can you please try this query

Select

d.ownerid,

d.parentid,

d.dataid,

k.firstname,

k.middlename,

k.lastname,

d.aclcount,

d.name,

d.subtype,

dad.auditstr,

dad.performerid,

dad.eventid,

dad.valuekey,

dad.auditdate

from dtree d, dauditnew dad,dauditnew da, kuaf k

where

k.id = dad.performerid and

dad.auditstr = 'Fetch' and

d.dataid = dad.dataid and

d.dataid = da.dataid and

da.auditstr = 'Recycle' and

dad.auditdate > da.auditdate

start with d.dataid=30426565

connect by ABS(d.parentid) = PRIOR d.dataid

Regards

Rinita

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, December 07, 2012 5:59 PM
To: eLink Recipient
Subject: Livereport to show items that are opened after they are placed in the recycle bin

Livereport to show items that are opened after they are placed in the recycle bin

Posted bytom.lunding@nl.thalesgroup.com (Lunding, Tom) On 12-07-2012 07:27

Hello,

Can anyone help me to create a query to show the document that are opened after they are placed inside the recycle bin.

Currently i have:

The problem is that also the documents are showed that are opened befor they are placed into the recycle bin

Any help would be apreciated

& nbsp;

Tom

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

The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.