Is it possible to display the list of sent emails ?

[elitt]

All the articles (internal and external emails, internal and external notes...) are gathered into each ticket view.
But my agents asked me to display the list of all sent emails (or all written articles).

In fact, they want to be able to see a list with some data :
- the agent who has written the article
- the subject and the date of the article
- the recipients of the article
- the ticket number related to the article

Is it possible ?

I created a SQL request

Code: Select all

SELECT ticket.tn AS ET, article.ID AS ID, article.A_FROM AS De, article.A_TO AS A, article.A_SUBJECT AS Objet, article.CREATE_TIME AS Date, users.login AS Utilisateur FROM ticket, article, users WHERE ticket.ID = article.TICKET_ID AND users.ID = article.CREATE_BY ORDER BY ET DESC

Is it possible to allow agents to run this request ? How ?