AnsweredAssumed Answered

Reminder not working for call at accounts detailview!

Question asked by Manish Manish on Jan 31, 2014
Latest reply on Feb 5, 2014 by Manish Manish
Hi Guys,

When I have created a calls against Accounts then reminder against call or meeting not working.But when I get a chance to load accounts detail page then it's working.But I observed query for same at include/Javascript/jsAlerts.php then issue is in query execution because for farsi language query contains ! = instead of !=.Please check attachment.

SELECT name, calls.id, description, date_start, reminder_time FROM calls LEFT JOIN calls_users ON calls.id = calls_users.call_id WHERE calls_users.user_id = 59b921bb-b1ad-f445-b4d8-52eb99e76c35 AND calls.reminder_time AND calls_users.deleted! = 1 and date_start> = '2014-01-31 12:50:30 'AND date_start<= '2014-01-31 13:50:30'

Instead of 

SELECT name, calls.id, description, date_start, reminder_time FROM calls LEFT JOIN calls_users ON calls.id = calls_users.call_id WHERE calls_users.user_id = 59b921bb-b1ad-f445-b4d8-52eb99e76c35 AND calls.reminder_time AND calls_users.deleted !=1 and date_start >= '2014-01-31 12:50:30 'AND date_start  <= '2014-01-31 13:50:30'



Please help me!

Thanks,
Manish

Outcomes