Reports specified per folder, including all subfolders

Ruth_Keijzer_(KPNUser1_(Delete)_2268578)

I'm looking for reports which contain the following information over the last two weeks:the number (#) of added items;the names of users who added these items;the number (#) of logins.All of the above specified per project, folder and subfolders.I've got the DataID's from the DTree table of the folders and projects. Now I'm looking for a query to get the above information specified per project, folder and subfolders.Thanks in advice.

Find more posts tagged with

Comments

Dave_Lynn_(NSWCSP24Admin_(Delete)_1849434)

I had a similar requirement, to list all tasks within projects, all within the same parent folder. TEch support got me started. Here's my modified SQL statement:select to_char(status), count(*) from dtree where subtype=206 start with dataid=(select distinct abs(dataid) from dtree where name='ECR Repository') connect by prior dataid=abs(parentid) group by to_char(status)subtype=206 selects tasks, this could be changed as required. 'ECR Repository' is the parent folder name. The ...connect by prior... is that magic that 'walks the tree' (Dtree).Now the bad news:connect by prior limits your ability to perform joins, so looking up user names is not straightforward. What I did was write a PL/SQL stored function to perform the Userid to name mapping. /dave/

eLink User

Message from Bax Ruud, F.C. via eLinkI've made this query to list all documents in a certain workspace:select a.name "Document", b.version "Version", b.filetype "Type",b.datasize/1048576 "Size in MB", b.datasize "Size in bytes" fromlivelink.dtree a, livelink.dversdata b where a.dataid = b.docid and a.dataidin (select dataid from livelink.dtree start with dataid = (select dataidfrom livelink.dtree a, livelink.kuaf b where subtype = 142 and a.userid =b.id and b.name = %1) connect by prior dataid = parentid) order byb.datasize descThis gives you all the documents in the folder of a certain user (parameter1)Ruud> -----Oorspronkelijk bericht-----> Van: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Verzonden: dinsdag 29 augustus 2000 15:48> Aan: eLink Recipient> Onderwerp: RE- Reports specified per folder, including all subfolders> > RE- Reports specified per folder, including all subfolders> Posted by NSWCSP24Admin on 08/29/2000 10:46 AM> > I had a similar requirement, to list all tasks within projects, all within> the same parent folder. TEch support got me started. Here's my modified> SQL statement:> > select to_char(status), count(*) from dtree where subtype=206 start with> dataid=(select distinct abs(dataid) from dtree where name='ECR> Repository') connect by prior dataid=abs(parentid) group by> to_char(status)> > subtype=206 selects tasks, this could be changed as required. 'ECR> Repository' is the parent folder name. The ...connect by prior... is that> magic that 'walks the tree' (Dtree).> > Now the bad news:> connect by prior limits your ability to perform joins, so looking up user> names is not straightforward. What I did was write a PL/SQL stored> function to perform the Userid to name mapping. > > /dave/> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Topic: Reports specified per folder, including all subfolders> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=232066> 1&objAction=view> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967> 7&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> >

Mahmoud_Dayeh_(ecead_mad_(Delete)_2045359)

What abt making it work in SQL Server.The existing Query doesnt work.Any suggestions on using the connect by statement

Johann_Lazarus_(sglcadmin13_-_(deleted))

I have tried this Livereports, but they are not working with MSSQL. Is there any equal command like start with .... connect by prior ??

eLink User

Message from Bhupinder Singh via eLinkAs far as I know, there is no equivalent to "connect by prior" in MS-SQL.Sincerely,Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed. Customer SupportOpen Text Corporation Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292------------------------------------------------------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Friday, March 14, 2003 1:06 AMTo: eLink RecipientSubject: I have tried this Livereports, but they are not working withMSSQL. Is there...I have tried this Livereports, but they are not working with MSSQL. Isthere...Posted by SglcAdmin13 on 03/14/2003 01:02 AMI have tried this Livereports, but they are not working with MSSQL. Is thereany equal command like start with .... connect by prior ??[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Reports specified per folder, including all subfoldershttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2320661&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe