Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
SQL - count
Loretta_Goralczyk_(goralczyk.loretta@gene.com_-_(d
What is the sql for creating a LR that just counts how many times a version is opened for a document or customview? I have this but it doesn't seem to workSELECT Count(*) "Accesses by User"FROM Daudit aWHERE a.DataId = %1AND (CreateDate>%2) and (CreateDate<%3)AND Event = "Version Opened"
Find more posts tagged with
Comments
Steve_McDonough
I'm not sure if there is an event called "Version Opened". However, here is a copy of a report that prompts for a data Id number and a date selection. Inputs: String Enter DataIDDate Enter Beginning DateDate Enter Ending DateSQL: SELECT b.Name, COUNT(*) "Times Accessed" FROM DAuditNew a, DTree b, DVersData c WHERE b.DataID = %1 AND a.DataId = b.DataId AND a.AuditDate >= %2 AND a.AuditDate <= %3 AND a.AuditId IN (26, 14) AND c.DocID = b.DataId GROUP BY a.DataId, b.Name Params:%1 User Input 1%2 User Input 2%3 User Input 3Report Format:Auto LiveReportHope it helps!
