• Scheduler job doesn't execute my php changes

    Hi, I work with sugar pro 7.6 and I want to execute a custom job which checks the status of the contracts and does something. I correctly setup my batch file (following the documentation instructions) for the execution of the scheduled job and the file…
  • Query not return any result in logic hook but query work in MySQL workbench

    My code in Cases module hook: $sql = "select c.id from cases c left join emails e on e.parent_id = c.id and e.parent_type = 'Cases' left join emails_text et on et.email_id = e.id where c.id = '{$focus->id}' and et.to_addrs like '%_string_%'"; $result…