Get count of pages, files

whitenjg's Avatar

whitenjg

10 Aug, 2010 08:07 PM

Is there any way to get a count of the number of Pages contained in the database?

Similarly, is there any way to get a count of the number of files?

Thanks!
Jon

  1. Support Staff 1 Posted by Tim on 11 Aug, 2010 03:45 PM

    Tim's Avatar

    Hi Jon,

    There is no way to do this from the interface, but you should be able to do this with a query like:

    select count(*) from cxml_foldercontent
    where assetType = 'PAG' 
    and isCurrentVersion = 1 
    and isRecycled = 0;

    This will give you the count of all pages (not including past versions and not including recycled pages).

    You can execute the same query but change assetType to 'FIL' to get the count for files.

    Hope this helps!

  2. Tim closed this discussion on 11 Aug, 2010 03:45 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac