Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Help with Writing Report to Count Number of Times...
18User3_(Delete)_2154966
Need help with the specific language on how to count the number of times a document has been fetched. If someone has done this, could you please provide what I should enter (Specific wording) when creating the Live Report. Thanks,
Find more posts tagged with
Comments
Alex_Kowalenko_(akowalen_(Delete)_2285456)
Number of times a document was fetched...Select Count(*) "Times"From DTree, DAuditWhereDTree.DataID = DAudit.DataID AndDAudit.Event = 'FETCH' AndDTree.DataID = Number of times a document had any auditable event....Select DAudit.Event, Count(*) "Times"From DTree, DAuditWhereDTree.DataID = DAudit.DataID AndDTree.DataID = Group By DAudit.Event