AND AuditDetails.AuditDef.ActionType ?.

Hello,

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.

https://ometv.onl https://chatroulette.top https://omegle.wtf https://bazoocam.cam

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 

thanks

alexsunny

  • You have 2 options:


    * Use OR
    [. . .]
    AND
    (
    AuditDetails.AuditDef.ActionType = 1
    OR AuditDetails.AuditDef.ActionType = 2
    [OR . . .]
    )

    * Use IN
    [. . .]
    AND AuditDetails.AuditDef.ActionType IN ( 1, 2, 3 [, 4, . . .])

    = = = =

    The action type values that are relevant to documents are:

    1 Created
    2 Approved
    3 Changed
    4 Deleted
    5 Purged
    21 Checked Out
    22 Checked In
    32 Cancelled Checkout
    39 Notification Sent

    Eric Rajala | Consultant

    Cohesive

    Email: eric.rajala@cohesivegroup.com

    www.bentley.com

       
    This is a test