Hi,
I have to remember for my report which records all the clients in my dataset ome.tv camsurf omegle different types of activity to make my report more complete.
Currently I am using AND AuditDetails.AuditDef.ActionType = 1 for created documents.Maybe I would like to incorporate some additional limits like * 3, 21, 22 *, as an illustration, to remember for the report so that my research gives me all the data I need.
Current code.
START WITH DocumentSELECT Code, Class.Path, AuditDetails.AuditDef.ActionType, AuditDetails.AuditDef.Name, AuditDetails.AuditDate, AuditDetails.Person.FirstName, AuditDetails.Person.Surname WHERE Id > 0 AND IsTemplate = 'N' AND AuditDetails.AuditDate >= @DateFrom AND AuditDetails.AuditDate <= @DateUntil AND AuditDetails.AuditDef.ActionType = 1