[SOLVED] Â Use of additional query in MassMailer |
1/16/2017 3:10:48 PM |
PHPRunner General questions | |
W
WilliamB authorDevClub member
Hello, |
|
admin 1/16/2017 | |
On official MassMailer template page ( http://xlinesoft.com/massmailer ) check section "How do I use 'Execute SQL query after email sent' field". In that code example we main.CustomerID to access CustomerID feild from the main query. You can use the same approach to access any field from your additional query. |
W
|
WilliamB authorDevClub member 1/16/2017 |
On official MassMailer template page ( http://xlinesoft.com/massmailer ) check section "How do I use 'Execute SQL query after email sent' field". In that code example we main.CustomerID to access CustomerID feild from the main query. You can use the same approach to access any field from your additional query. And here is a more complete example for you: http://xlinesoft.com/blog/2016/01/29/massmailer-template-use-case/
select count(ID) as num from tTrans where ClientID='%main.ClientID%' and CancelCode='N/A' and TransDate>='%main.StartDate%'
|
admin 1/17/2017 | |
It looks like it should work. It's hard to tell though without seeing database structure and the rest of setup. |