Dear Team,
I want to include in my report which lists all users in my database various action types to make my report more inclusive.
Currently I use the AND AuditDetails.AuditDef.ActionType = 1 for created Documents.
I would like to include additional parameters like *3, 21, 22* as an example to be included in the report so that my search gives me all the info I require.
Could you please assist with the correct EQL code.
Current code.
START WITH Document SELECT 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
Hi Dean,
Try the below eQL Query.
START WITH Document SELECT 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 IN ( 1, 3, 21, 22 ) ORDER BY Code, AuditDetails.AuditDef.ActionType
Regards,
Sayyad
Answer Verified By: Dean Stander