Can Process Author Execute SQL?

Sorry, I know you were specifically asking about Process Author and not a logic hook, but is there any reason you don't want to call the SQL from a logic hook? Sugar has a DBManager class that can call the SQL from within the logic hook after_save, and it'd be easier to implement in my opinion.

Oddly, I have done a fair bit with Process Author, but have not done any work in Logic Hooks, hence my preference.

I am happy to give things a try with Logic hooks, can you point me to a good place to start?

Here is the documentation:

http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/Logic_Hooks/ 

The documentation for the dbmanager is here:

http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/API/Classes/DBManagerFactory/ 

For example, let's say you want an after save logic hook in accounts that would run sql, in /custom/modules/Accounts/logic_hooks.php put:

<?php

    $hook_version = 1;

    $hook_array = array();
    $hook_array['after_save'] = array();
    $hook_array['after_save'][] = array(
        1,
        'Hook description',
        'custom/modules/Accounts/customLogicHook.php',
        'className',
        'methodName'
    );
?>

In custom/modules/Accounts/customLogicHook.php, put the following code:

<?php

class className {

    function methodName($bean, $event, $arguments) {
        $sql = "update accounts set name ='test' where id ='".$bean->id."'";
        $result = $GLOBALS['db']->query($sql);
        $GLOBALS['db']->fetchByAssoc($result);
    }

}

?>

Here is the documentation:

http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/Logic_Hooks/ 

The documentation for the dbmanager is here:

http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/API/Classes/DBManagerFactory/ 

For example, let's say you want an after save logic hook in accounts that would run sql, in /custom/modules/Accounts/logic_hooks.php put:

<?php

    $hook_version = 1;

    $hook_array = array();
    $hook_array['after_save'] = array();
    $hook_array['after_save'][] = array(
        1,
        'Hook description',
        'custom/modules/Accounts/customLogicHook.php',
        'className',
        'methodName'
    );
?>

In custom/modules/Accounts/customLogicHook.php, put the following code:

<?php

class className {

    function methodName($bean, $event, $arguments) {
        $sql = "update accounts set name ='test' where id ='".$bean->id."'";
        $result = $GLOBALS['db']->query($sql);
        $GLOBALS['db']->fetchByAssoc($result);
    }

}

?>

Thanks very much, I really appreciate you taking the time to lay out an example, i will have a go at it.

I will still give the process author approach a try if it is possible.

We like how customizations have strong visibility via that approach.

Adding extensibility to Advanced Workflow is on the horizon. For example, we plan to allow custom actions that you can incorporate into your workflows. These custom actions would allow you to define PHP code that runs as part of a process.