networking: asus rt-n66u automatic reboot
I'm using the RT-N66U only as an Access Point as I have a dedicated PF-Sense box as my main Router/Switch. The access point get […]
Author: Ricardo Malla
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 = […]
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 […]
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: […]
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 […]
jasper reports: api configuration
http://192.168.1.220:8080/jasperserver/rest_v2/reports/reports/MG/Compras/Compras_Fabricantes_Notes.pdf?Fabricante=3M
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 […]
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 […]
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 […]
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 […]