Your software
My Mautic version is: 4
My PHP version is: 7.4
My Database type and version is:
Your problem
My problem is:
Hello,
i’m wondering it is posible to segment contacts whether or not they have a notes.
I’m trying to target all my leads we haven’t call yet.
I can do it with sql request, but i 'm looking for someting more dynamic directly in Mautic.
Thanks
Hello chente, Thanks for your question. As far as I know this is not possible with the notes.
You can use the mysql plugin for that. Again - its an sql query but at least Mautic does it.
Hey @joeyk are you talking about mautic-sql-conditions-bundle plugin ?
If so I have never been able to get my head around how this works or the use case for it. Maybe you can give a simple example ?
Hello @mikew , Yes that’s the one (altough on M4 it doesn’t appear in my menu list on certain instances.)
Here is a how to use video from a Mautic Meetup:
The fun starts at minute 20.
That is really great Joey - I was wondering a few things, first where it shows up inside a campaign - the answer in conditions (for some strange reason I was looking in actions).
Second interesting thing is you mentioned you can create a new table inside the mautic DB and reference this table as well - is my understanding correct ? This is super cool.
The next thing is to understand the syntax that can be used exactly.
Thankvery much for the video