Need report to count Document

Hello,I'm looking for an report to count the document in an specific folder. ( I want to select the folder ) It should count in all subfolder as well.We're running LL 9.5.0 with oracle.Any idea's?RegardsPeter

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

The following discussion thread provides some tips for this query:

https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3092318&objAction=view&show=2

- 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: Thursday, May 29, 2008 10:49 AM
To: eLink Recipient
Subject: Need report to count Document

Need report to count Document

Posted by pstegl (Stegl, Peter) on 05/29/2008 10:44 AM

Hello,

I'm looking for an report to count the document in an specific folder. ( I want to select the folder ) It should count in all subfolder as well.
We're running LL 9.5.0 with oracle.

Any idea's?

Regards

Peter

adarsh_lobo_(adarsh.lobo@shell.com_(Delete)_112626

Message from via eLinkPeter,You could use the following query:select count(1) from dtree where dataid in (select dataid from dtree start with parentid in (%1,-%1) connect by prior dataid=abs(parentid)) and subtype=144Inputs: Type = ContainerPrompt = FolderParam %1: User Input1Report Format: Auto LiveReportThanks,Adarsh-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, May 29, 2008 8:19 PMTo: eLink RecipientSubject: Need report to count DocumentNeed report to count DocumentPosted by Stegl, Peter on 05/29/2008 10:44 AMHello,I'm looking for an report to count the document in an specific folder. ( I want to select the folder ) It should count in all subfolder as well.We're running LL 9.5.0 with oracle.Any idea's?RegardsPeter[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/Livelink_LiveReports_DiscussionLivelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Chad Latka

Does this work for SQL Server 2000 ? select count(1) from dtree where dataid in (select dataid from dtree start with parentid in (%1,-%1) connect by prior dataid=abs(parentid)) and subtype=144 Inputs: Type = Container Prompt = Folder Param %1: User Input1 Report Format: Auto LiveReport

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

No, this will not work in SQL 2000.

The "connect by prior" construct is Oracle only.

You would need to write a stored procedure that calculated all the dataid values and reference that.

Search in this discussion forum and you will find examples.

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 17 September 2009 16:51
To: eLink Recipient
Subject: Does this work for SQL Server 2000 ?

Does this work for SQL Server 2000 ?		Posted by northo01user2 (Latka, Chad) on 2009/09/17 11:50
In reply to: RE Need report to count Document 2		Posted by adarshlobo (lobo, adarsh) on 2008/05/29 11:35

Does this work for SQL Server 2000 ?

select count(1) from dtree where dataid in (select dataid from dtree start with parentid in (%1,-%1) connect by prior dataid=abs(parentid)) and subtype=144

Inputs:
Type = Container
Prompt = Folder
Param %1: User Input1
Report Format: Auto LiveReport