Go to Window Tab & Field on the System Role search for your desired document (in my case Purchase Order) and on the {{Sql WHERE}} field add your condition. In my case: C_Order.IsSOTrx=’N’ AND C_Order.em_mg_procurement=’Y’
Some emails are parsed, while others are not. It depends on the format of the email. Here are some highlights: Files of interest: /app/bundles/EmailBundle/MonitoredEmail/Processor/Bounce/DsnParser.php /app/bundles/EmailBundle/MonitoredEmail/Mailbox.php: /app/bundles/EmailBundle/MonitoredEmail/Processor/Bounce.php The process as I understand it is the following: Step 1. On Mailbox.php you define what emails are considered for un-subscription. The default criteria es UNSEEN, which the process […]
To check how many emails are triggered and sent for your campaigns Today. SELECT leads.id, leads.email, leads.company, leads.custom_mkt_drip, campaign_lead_event_log.* FROM campaign_lead_event_log left join leads on campaign_lead_event_log.lead_id = leads.id left join email_stats ON leads.email = email_stats.email_address WHERE DATE(date_triggered) = DATE(NOW()) AND campaign_lead_event_log.is_scheduled = 0 AND campaign_lead_event_log.channel = “email” AND metadata NOT LIKE “%failed%” ORDER BY […]
root@ubuntu:~# php /var/www/mautic/app/console cache:clear Note that after clearing Cache the App is Stuck because there is a Permissions problem (Mautic cannot write the Cache Folder) so you need to chmod -R 777 cache folder (this is insecure but works). You need to use the appropriate permissions based on your requirements.
https://www.mautic.org/docs/en/setup/cron_jobs.html