Dear Team,
I need to write a report pulling data for a specific user showing what documents that person created, when and when a document has been modified by that person.
Suggestion,
we provided this functionality in our extended search... see picture..
With options created modified etc between date1 & date2
rgds
Patrick
Dear Patrick,
Thank you, we are running eB 15.6.1 which does not have that included in the extended section.
Hi Dean,
I have written a eql query may be this could help. Please check and let me know.
START WITH Document SELECT Code, Name, Middle, Revision, ApprovalStatus, DateAdded, AddedBy.FirstName, DateChanged, ChangedBy.FirstName WHERE ( AddedBy.FirstName LIKE @FirstName OR AddedBy.Surname LIKE @Surname ) AND IsTemplate = 'N' ORDER BY Code
Regards,
Sayyad
I think the following query will be more useful.
START WITH Document SELECT Code, Name, DateAdded, AuditDetails.Properties.OldValue, AuditDetails.Properties.NewValue, AuditDetails.AuditDate, AuditDetails.Person.FirstName WHERE AddedBy.FirstName LIKE @PersonName OR AddedBy.Surname LIKE @Surname AND IsTemplate = 'N' ORDER BY Code
Also you can specify the display name for the column in the "format layout" tab of eQL report designer.
Dear Sayyad,
I am new to the designer and this is what I have in my EQL design, but is give me an error.
error given
"please check the spelling and ensure the case is correct for the column"