How I can know how many documents are in a folder?

Obed Silva

Good morning everybody.

A question:

 H ow I can know how many documents are in a folder?

Regards;

 

Mukesh_Giri

Hi,

If you want to use a live-report for this purpose (i assume DB to be oracle), using a connect by statement you can get all the documents in a particular folder (pass the dataid of that particular folder e.g 12345).

select * from Dtree where subtype = 144 CONNECT BY PRIOR dataid = parentid start with dataid =12345

Count will be

select count(*) from Dtree where subtype = 144 CONNECT BY PRIOR dataid = parentid start with dataid =12345

I hope this is what you are looking at?

Thanks