Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
WorkSiteMP document count?
jwl
Hi, Does anyone know how to get a total count of the documents in a WorkSiteMP (4.1) system?
Many thanks,
John
Find more posts tagged with
Comments
jwl
Got it:
SELECT COUNT(*)
FROM WORKSITEMP.DOC_DOCUMENT
Migrateduser
In Worksite MP5, I have to filter where p_datasource='document'. I'm not sure if the same applies in 4.1. 5.0 stores other elements such as folders in the doc_document table as well.
Jie