Cron task

[jmdc]

Hello,

Well, i think it ?s easy to answer, but when i am using a schedule task, with email plugin, i would like to send email if one condition is Ok, just like:
{table___elementname} = 1

but i?m not able to write the correct condition php code.

Could you help me, please?

Thank you...

 

[troester]

Have a look at the tooltips.

Condition: OPTIONAL PHP to evaluate for each row of the table, row will not be processed if you return false. Standard element placeholders can be used, or row data can be accessed from $row array. Remember that this code runs on every row in the table, so keep your code efficient so you don't run in to max execution time issues.

So something like
return '{table___elementname}' =='1';

 

[jmdc]

Thank you....but i have an error page after i click "Run":



An error has occurred.
1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`xptousers`.`id` = '133' AND abc.date_time >= '2016-07-21 23:00:00'' at line 1 SQL=( `xptousers`.`id` = '133' AND abc.date_time >= '2016-07-21 23:00:00' )

Which are my pre-filter tablename abc:
-> where userid(raw) EQUALS {$my->id} AND date_time GREATER THAN 2016/07/22

and "abc tablename" is my connection list in schedule email plugin...

Could you help me, please?

Thank you.