Contact notes

Your software
My Mautic version is: 4
My PHP version is: 7.4
My Database type and version is:

Your problem
My problem is:


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.

Hello chente, Thanks for your question. As far as I know this is not possible with the notes.

1 Like

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.

1 Like

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

Thank you @fabienne @joeyk @mikew