ricardo malla's blog

October 23, 2015mysql, sugarcrm

mysql: assign opportunities to user based on parent account

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 = […]

October 23, 2015mysql, sugarcrm

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 […]

October 22, 2015October 22, 2015mysql

mysql: update or delete with join operators (contacts)

Same as previous post but this time with Accounts instead of Leads. List the Contacts related to the Accounts this employee has assigned: […]

October 22, 2015October 22, 2015mysql

mysql: update or delete with join operators

I'm trying to update some records on Table C (contacts.assigned_used), but I have a Join from Table A (leads) and passing through […]

October 19, 2015October 19, 2015tibco - jasper reports

jasper reports: api configuration

http://192.168.1.220:8080/jasperserver/rest_v2/reports/reports/MG/Compras/Compras_Fabricantes_Notes.pdf?Fabricante=3M

October 17, 2015August 3, 2016java, tibco - jasper reports

java: compare boolean vale

I require this to limit the Print when Expression Field on Jasper Studio. I had some trouble getting the comparison formule, because […]

October 16, 2015October 16, 2015mysql, 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 […]

October 11, 2015October 11, 2015openbravo, postgresql

pgsql: list and remove triggers

I want to delete directly on the PgSQL database on my OpenBravo application but it has a los of triggers that prevent […]

October 11, 2015October 11, 2015openbravo

openbravo: delete physical inventory

I cannot Post "Goods Receipt", I believe there is an error when opening the Physical Inventory. I have created a couple of […]

October 11, 2015openbravo

openbravo: goods shipment not posting

It is not posting because the Costing Algorithm is not working, probably because it is not recognizing the Currency.