How can I get the count of number of documents that are in livelink?

Siva_Shanmugam

We need to find out the number of documents that are currently in Livelink. This count should not should not include multiple versions of a document?With the SQL below, I can find the total number of documents but I am not sure how to exclude multiple version of a document. For example if adocument has 5 version, my count should only trat it as a 1 (single) document.select count(*) from DTree where subtype=144

volvostephen

Message from via eLinkThat is the correct SQL for what you want. Version information is stored ina separate table (dversdata). One thing you might want to consider addingto your report is a filter for deleted documents. If you are using theundelete module, then you will have a deleted documents volume so you wouldneed to exclude documents with a parent ID of the deleted Documents Data IDwhich is usually 2052.So it would just beselect count(*) from DTree where subtype=144 and ParentID not in (2052)-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: November 4, 2004 10:17 AMTo: eLink RecipientSubject: How can I get the count of number of documents that are inlivelink?How can I get the count of number of documents that are in livelink?Posted by Shanmugam, Siva on 11/04/2004 09:36 AMWe need to find out the number of documents that are currently in Livelink.This count should not should not include multiple versions of a document?With the SQL below, I can find the total number of documents but I am notsure how to exclude multiple version of a document. For example if adocumenthas 5 version, my count should only trat it as a 1 (single) document.select count(*) from DTree where subtype=144[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe