'LiveReport to display the deleted documents without the DeleteDoc table

Hi All,The DeleteDoc table has been removed for my case as Livelink Recycle bin has been instead. My question is if i will like to know what are the documents that users has deleted, what should be the SQL? and to query which table?Thanks.

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

To know what documents users have deleted, use the Personal menu in Livelink, and select "Recycle Bin" or "Recycle Bin - Today". If you don't see these options listed in the Personal menu, go to the Livelink Administration pages, Configure Recycle Bin section to enable them.

With regards to the tables used by Recycle Bin, I think the only one is GDCRecycleBin, which has data along the lines of the sample data shown below:

ID PARENTID VOLUMEID DOMAINID PARENTPATH

328522 8213938 2003 ? Admin Home:Important Documents:[328522] CIMG0388.JPG

Let me know if that helps...

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, April 27, 2009 8:40 AM
To: eLink Recipient
Subject: 'LiveReport to display the deleted documents without the DeleteDoc table

'LiveReport to display the deleted documents without the DeleteDoc table

Posted by tpeimei (Tan Pei Mei, Verlynn) on 2009/04/27 08:17

Hi All,

The DeleteDoc table has been removed for my case as Livelink Recycle bin has been instead. My question is if i will like to know what are the documents that users has deleted, what should be the SQL? and to query which table?

Thanks.

Appu_Nair

Havenot tried this but in the grand scheme of things it is my guess that LL is suing a voulme as recycle bin.So I would do something like this.I would first try running this query on a known objectid such as 12345select ownerid,parentid,dataid,subtype from dtree where dataid=12345I will note down the ownerid.Then I will delete it so it has gone into the recycle bin.run the query again and note the ownerid.If it is a volume then a query such as this would return all the object from dtree within the deleted volumeselect ownerid,parentid,dataid,subtype from dtree where ownerid=Sorry I could be wrong if the recycle bin is not a volme. so my apologies for not testing this out without posting.(ll projects use this methodolgy)