Determining if a Document has been deleted when querying the DTree table

Hi,I'm writing a LiveReport that lists documents by querying the DTree table. I want to filter out deleted documents though. I've noticed that the UPermissions, GPermissions, WPermissions, SPermissions values seem to get set to '128' when a document is deleted. Is this an accurate way to determine if a document has been deleted, or is there a better way?Thanks,Thom

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

I think a better way would be to include the DeletedDocs table in your query, something like "AND where DataID not-in (select NodeID from DeletedDocs)" (roughly speaking of course). This assumes you are not using the Recycle Bin module, but rather you have only the core undelete functionality which covers documents only.

- Bhupinder

------------------------------------------------------
Bhupinder Singh, B.Math., B.Ed.
Senior Product Specialist, Customer Support
Open Text Corporation, Waterloo, Ontario, Canada
Customer support e-mail: support@opentext.com
Customer Support Telephone: 800-540-7292
------------------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, May 11, 2007 8:49 AM
To: eLink Recipient
Subject: Determining if a Document has been deleted when querying the DTree table

Determining if a Document has been deleted when querying the DTree table

Posted by logicaukadmin (Mercer, Laurie) on 05/11/2007 08:48 AM

Hi,

I'm writing a LiveReport that lists documents by querying the DTree table. I want to filter out deleted documents though.

I've noticed that the UPermissions, GPermissions, WPermissions, SPermissions values seem to get set to '128' when a document is deleted.

Is this an accurate way to determine if a document has been deleted, or is there a better way?

Thanks,

Thom

Anquoc_Tran

That sounds better. Thanks BhupinderThom