nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!