as per topic title, can anyone suggest where I can find the list of all sent emails by system?
To be more detailed, I wrote a job for the scheduler module that send one email for each customer and after email has been sent, it creates an Email bean saving all informations about the email sent.
Where I can find a list of all sent Email beans?
Any help is appreciated. Thank you.
As far as I’m aware, there’s not a clean list of all Emails sent from the CRM
(Though, someone please correct me if i’m wrong!)
There might be some ways to get the info though
CRM-side, you would be able to view Emails sent to the specific records themselves, via the “History” subpanel:
From the Database, you could run a Query on the Emails table to retrieve all Sent/Outbound Email records.
SELECT * FROM `emails` WHERE `type` LIKE 'out' OR `status` LIKE 'sent' ORDER BY `date_entered` DESC
You might also be able to grab similar results via code, using the “get_full_list()” function when working with Beans:https://docs.suitecrm.com/developer/working-with-beans/#_get_full_list
This should allow you to grab all Email beans, filtered down by conditions
Hopefully something above can point in the right direction!