SQL conditions for Mautic

https://mtcextendee.com/plugins

• composer require mtcextendee/mautic-sql-conditions-bundle
• php app/console mautic:plugins:reload
• Go to /s/plugins and setup SQL Conditions

• Download last version https://github.com/mtcextendee/mautic-sql-conditions-bundle/releases
• Unzip files to plugins/MauticSqlConditionsBundle
• Clear cache (app/cache/prod/)
• Go to /s/plugins/reload
• Setup SQL Conditions integration

1, See new item on left menu:

2, Setup SQL conditions

3, Parameters for SQL

• :contactId
• :campaignId
• :eventId
• :rotation

4, Condition return true If there is results

Condition for contacts with ID greather like 2000

SELECT l.id FROM leads l WHERE l.id = :contactId and l.id > 2000

Icons made by Eleonor Wang from www.flaticon.com