mysql: assigned calls to user based on parent account or lead
Select List of Calls to Update: SELECT * FROM calls LEFT JOIN accounts ON calls.parent_id = accounts.id LEFT JOIN leads ON calls.parent_id […]
Category: sugarcrm
mysql: query to find "orfan" notes on sugarcrm
The following Query get me a List of the Lines I want to Delete, but I cannot execute a query to Delete […]
mysql: update database
SELECT * FROM crm_em.notes WHERE name LIKE '%cierre%'; UPDATE crm_em.notes SET name = 'Nota de Cierre' WHERE name LIKE '%cierre%';
sugarcrm: security suite for custom modules
On regular modules, when adding a Record to a Security Group, a line is created on the 'securitygroups_records' database. When doing this […]
sugarcrm: manually remove relationships
http://forums.sugarcrm.com/f3/how-remove-custom-relationship-37781/ When you create a new relationship through Admin -> Studio -> <Module Name> -> Relationships, Sugar create several files at custom […]
google: google maps iframe based on variables
OFFICIAL EMBED GUIDE https://developers.google.com/maps/documentation/embed/guide OFFICIAL WEB SERVICE COMMANDS https://developers.google.com/maps/documentation/webservices/ ZOOM Level: Not all applicable to Embeds https://developers.google.com/maps/documentation/staticmaps/?csw=1#Zoomlevels ACCOUNTS https://www.google.com/maps/embed/v1/search?key=APIKEY&q=%20{name}%20+%20{a01_pais_accounts_name}%20+%20{a01_estados_accounts_name}%20 LEADS […]
sugarcrm: studio not updating column width
I decided to upgrade my server from Ubuntu 12.04 to 14.04 (switched the server) and suddenly I could not edit the variables […]
sugarcrm: agregar numero de cotizacion
http://www.sugarcrm.com/forums/f6/how-create-autogenerated-field-63662/ Hi , Try this 1) create one Text field name 'opp_code_c' keep it in all views through studio in Opportunity modules […]
sugarcrm: update modified date when adding a note
This makes a los of sense because we filter both Leads and Opportunities by modified Dates (leads in order to know when […]