Query 1 Adds Vendedor = 1 To All Contacts that are Joined to a Manufacturer UPDATE contacts INNER JOIN a26_proveedor_contacts_c ON contacts.id = a26_proveedor_contacts_c.a26_proveedor_contactscontacts_idb INNER JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c SET contacts_cstm.vendedor_c = 1 Query 2 […]
When I create a new module in module builder, the databases are not creates/ Resolution: There was a problem with the group and user permissions. I did chgrp -R www-data (On Sugar Folder) chown -R www-data (On Sugar Folder) But […]
If you want to change the who is able to see for example the Assigned to Contacts on the Advanced Menus, because maybe you don’t want employees to see names of all other users, you have to do an Edit […]
Requirements: – Mail server needs on SugarCRM needs– Inbound Email cannot function without the IMAP c-client libraries enabled/compiled with the PHP module. Please contact your administrator to resolve this issue.
Query to Select List: SELECT * FROM opportunities LEFT JOIN accounts_opportunities ON accounts_opportunities.opportunity_id = opportunities.id LEFT JOIN accounts ON accounts_opportunities.account_id = accounts.id WHERE accounts.assigned_user_id = ‘7077c616-4f2c-f966-d9b6-5581807bae86’; UPDATE Query: UPDATE opportunities x LEFT JOIN accounts_opportunities y ON y.opportunity_id […]