Skip to content
Custom SQL condition for campaigns
PHP JavaScript
Branch: master
Clone or download
Latest commit a7165c6 Jul 30, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Assets Add/Edit SQL from action Jul 15, 2019
Config Add category support Jul 30, 2019
Controller Add/Edit SQL from action Jul 15, 2019
Entity Add category support Jul 30, 2019
Event Init commit Jul 12, 2019
EventListener Add/Edit SQL from action Jul 15, 2019
Executioner First version Jul 13, 2019
Form/Type Add category support Jul 30, 2019
Integration Init commit Jul 12, 2019
Model Add/Edit SQL from action Jul 15, 2019
Security/Permissions Init commit Jul 12, 2019
Translations/en_US Init commit Jul 12, 2019
Views Add category support Jul 30, 2019
MauticSqlConditionsBundle.php Init commit Jul 12, 2019
README.md Typo fix Jul 15, 2019
SqlConditionsEvents.php Added new files Jul 13, 2019
composer.json Init commit Jul 12, 2019

README.md

MauticSqlConditionsBundle

SQL conditions for Mautic

Support

https://mtcextendee.com/plugins

Installation

Command line

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

Manual

Usage

1, See new item on left menu:

image

2, Setup SQL conditions

3, Parameters for SQL

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

4, Condition return true If there is results

Examples

Condition for contacts with ID greather like 2000

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

Credits

Icons made by Eleonor Wang from www.flaticon.com

You can’t perform that action at this time.