Livelink 9.1.3 liveReport on a sum of the latest version of documents within a given Project

Edward_Dudetsky_(edudetsky_(Delete)_3648187)

Dear eLinkI have a LiveReport that given me a total count of objects (size and etc.) within a given Project.Status - Size of a [Project] including all versions select sum(a.datasize)/(1024*1024) "Mb" , count(distinct(a.docid)) from dversdata a, dtree b where a.docid=b.dataid and b.ownerid=%1Param %1: User Input 1: Select project : Type ProjectHowever I want to get a sum of just the latest versions of the documents within a given Project.Can anyone provide me with any tips how to amend my SQL for this LiveReport to get this sumAny valuable comments would be much appreciated.RegardsEdward.Dudetsky@causeway.com

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Ed,Add the clause and a.version=b.versionnumYou only want to count the datasize for the version in dversdata whichrelates to the current versionnum of dtree. There is only one row in dtree per document but one for each version indversdata.RegardsLindsayUK-Support-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 22 February 2005 18:54To: eLink RecipientSubject: Livelink 9.1.3 liveReport on a sum of the latest version ofdocuments within a given ProjectLivelink 9.1.3 liveReport on a sum of the latest version of documentswithin a given ProjectPosted by Dudetsky, Edward on 02/22/2005 01:49 PMDear eLinkI have a LiveReport that given me a total count of objects (size andetc.) within a given Project.Status - Size of a [Project] including all versions select sum(a.datasize)/(1024*1024) "Mb" , count(distinct(a.docid)) fromdversdata a, dtree b where a.docid=b.dataid and b.ownerid=%1Param %1: User Input 1: Select project : Type ProjectHowever I want to get a sum of just the latest versions of the documentswithin a given Project.Can anyone provide me with any tips how to amend my SQL for thisLiveReport to get this sumAny valuable comments would be much appreciated.RegardsEdward.Dudetsky@causeway.com[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