Hi, i am trying to create a campaign.
In the campaign i want to check if the user has product value of ‘product’ or value of ‘product-number2’.
Is there a way for me to do that without create 2 different condition boxes?
At the moment it doesn’t seems like i can do complex query, is there a way to make it work with comma or something like this?
Hi, you have to use 2 boxes.
If you are tech savy you can write a mysql querry and use the SQL Conditions plugin.
Joey
Hey thanks, that is unfortunate.
I will check the sql option.
if you had a chance to check it, in terms of how it works does it take more resources from the hosting compre to regualr mautic query?
It seems another option that might work as well and i just thought about is to create segement for each product with a user and filter. On segment you can use more than one value.
But from my experience it seems like the filter update is not always reliable.
I am not sure if it would work, but have you tried regex operator using a pipe | to separate your values?
If you one condition could contains more than one value in the field could save tons of time compare to create many condition. for example i need to change the segment to a segment name “Public Email Provider” that contact field contains “gmail,yahoo,hotmail” in the email field. I’m not sure comma could be a separator in the condition field.
Senario 1
I have a list have many email are end with gmail.com, yahoo.com, hotmail.com, these are the public email provider. I don’t want to use mautic standard way to broadcasting email in the cronjob by sending 100 email every time, it will trigger the spam abuse, because we sending 100 emails in 1 minutes to gmail.com, google might think i’m insane, sending too much email from one hostname with same IP
I’ve overviewed the Mautic documentation, % is the operator for the field, if i didn’t made misunderstaned it. the value could be like %gmail%%yahoo%%hotmail%
