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 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
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 Created2 Approved3 Changed4 Deleted5 Purged21 Checked Out22 Checked In32 Cancelled Checkout39 Notification Sent
Eric Rajala | Consultant
Cohesive
Email: eric.rajala@cohesivegroup.com
www.bentley.com