How do I set role in Opportunities Contacts relationship in before_ or after_relationship_add logic hook?

Question

Question as per title in Sugar 7.6

Rafal Szczypka · Accepted Answer

You could use the DBManagerFactory - http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.7/Data_Framework/Database/DBManagerFac… . In custom/modules/Opportunities/logic_hooks .php: In custom/modules/Opportunities/logic_hooks_class.php: id . "' and contact_id = '" . $arguments [ 'related_id' ] . "' and deleted != 1" ; $result = $GLOBALS [ 'db' ] - > query ( $sql ) ; } } } ?> This will set it to Executive Sponsor each time, but obviously you can put your own logic there. Let me know how you get on.