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
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"
When are you getting this error ? After running the report in web ? Or in the eQL designer ?
Please share the screenshot of the error.
Then I run the report in EQL Designer and getting the following error.
Hi, Any feedback as yet?