Identifying Documents which can be deleted

Hi, we need to identify all docs which are older than 5 years in LiveLink (9.7.1 Version) which can be deleted. We will then use LAPI to delete the documents.

Could you have a look at my query to identify object IDs. I want to ensure only Documents are deleted and folder structure remains intact.

Select OWNERID, DATAID, PARENTID from DTREE
where OWNERID = '-2000' and SUBTYPE in ('144' ,'7771') and ModifyDate between <Date Range>

Thank You!

Find more posts tagged with

Comments

appuGmail

To be quite honest Manoj the DataID's that you may get which may be correct could sometimes not be deleted permanantly.

So when you use LAPI what you will get is.

In most cases your first delete will get it into some kind of retrievable area (main ones are Recyclebin,trashcan,undelete).You can very simply know tat by just deleting a dataid and then finding it back with another ownerid.
If you go past that you will sometimes run into errors like "it is reserved"
Then you will get deletion blockers like references,locks on versions,legal holds,RM based and its not a full list because anyone can write something prohibiting an absolute delete(purge)
For an end user the most easy way might be to delete these with the help of RM and then look at the rest /exception with programs.This is not easy and if you have no idea of how RM works don't go for it.

PS1 ;I abandoned the simple api's because I ran into all those and many were not do able in LAPI, CWS etc so I resorted to Oscript to do the entire things.

Query seems correct but it is assuming nobody has files other than 2000. and I have no idea what subtype 7771 is.

PS2: Modify Date is based on a trigger setting in your admin pages I would look at that setting to see if it is reliable or whether you ed up deleting content people wanted:)

..... appnair appunair( Livelink Rocks )

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Sun, May 20, 2018 at 12:18 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Identifying Documents which can be deleted Posted bymagrawal5@metlife.com (Agrawal, Manoj)On 05/20/2018 01:16 PM

Hi, we need to identify all docs which are older than 5 years in LiveLink (9.7.1 Version) which can be deleted. We will then use LAPI to delete the documents. Could you have a look at my query to identify object IDs. I want to ensure only Documents are deleted and folder structure remains intact.Select OWNERID, DATAID, PARENTID from DTREE
where OWNERID = '-2000' and SUBTYPE in ('144' ,'7771') and ModifyDate between <Date Range>Thank You!
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: My Support

Hans Stoop

Based on your description I don’t think the query returns what you want. The modify date also is updated when you edit the attributes or change the permissions. You need to check when the latest version is added. The versions are stored in DVersion I think. The latest version number is also in DTree.

The other question is if you also want to delete older versions even when the latest version is younger than 5 years.

Your query doesn’t find documents in personal workspaces, projects and maybe others.

Hans

On 20. May 2018, at 19:18, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

eLink : Identifying Documents which can be deleted
Identifying Documents which can be deleted Posted by magrawal5@metlife.com (Agrawal, Manoj) On 05/20/2018 01:16 PM

Hi, we need to identify all docs which are older than 5 years in LiveLink (9.7.1 Version) which can be deleted. We will then use LAPI to delete the documents. Could you have a look at my query to identify object IDs. I want to ensure only Documents are deleted and folder structure remains intact.Select OWNERID, DATAID, PARENTID from DTREE
where OWNERID = '-2000' and SUBTYPE in ('144' ,'7771') and ModifyDate between <Date Range>Thank You!
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: My Support

Manoj Agrawal

Hello Hans, If I have to delete documents which is in Personal workspace, projects, what other criteria I have to apply. Also reason I am using modified date is because when a version gets added, modified date is also updated. I want to delete all versions of documents which fall in that modified date range.

Thanks

Hans Stoop

Hi Manoj,

Just remove the restriction for OWNERTYPE and you will get all documents anywhere in the system.

As I wrote earlier, next to adding a version the modify date is also changed when editing attributes and changing permissions and some other actions. This means that some documents are excluded that are added over 5 years ago. To get all documents where the latest version is added more than 5 years ago you can use the following query:

Select d.OWNERID, d.DATAID, d.PARENTID from DTREE d

Join DVersData v on v.DocID = d.DataID and v.Version = d.VersionNum
where d.SUBTYPE in (144 ,7771) and v.VerCDate between <Date Range>

VerCDate is the date the version is added to the system.

To get all document versions older than 5 years you can use the following query:

Select d.OWNERID, d.DATAID, v.Version, v.VersionID, d.PARENTID from DTREE d

Join DVersData v on v.DocID = d.DataID
where d.SUBTYPE in (144 ,7771) and v.VerCDate between <Date Range>

Hans

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Montag, 21. Mai 2018 15:31
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Re Identifying Documents which can be deleted

Re Identifying Documents which can be deleted

Posted bymagrawal5@metlife.com (Agrawal, Manoj) On 05/21/2018 09:24 AM

Thanks

[To post a comment, use the normal reply function]
Topic:	Identifying Documents which can be deleted
Forum:	Content Server LiveReports Forum
Content Server:	My Support