EQL Report - AND AuditDetails.AuditDef.ActionType

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