Document Count for Given Folder

[ujjval090683]

Hi,

I am looking for a Query which gives me DOcuments count with and without versions fo a Given Folder.

How can I retrive that?

 

[ggriffit]

are you looking for a count of just that folder or the folder and all child folders etc ?

SELECT count(*) FROM dtree WHERE parentid=<id> AND subtype=144

will give you a count of all documents in the folder specified by <id>

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[ujjval090683]

But, This only gives documents inside this folder.
Suppose there is folder inside given folder and it has also documents, then it should count all te documents.

Count should display immediate documents as well as documents withthing the nested folder.

Which query can give that?

 

[ggriffit]

Then you could use DTREEANCESTORS table to join with DTREE to show that information.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/