October 29, 2015October 29, 2015pfsense pfsense: bypassing nat reflection or split dns using windows hosts file We have a PFSense box, the problem is that it does not resolve WAN Domains on our internal network. What does this […]
October 27, 2015October 27, 2015ubuntu ubuntu: change resolution on virtual appliance To show available resolutions # xrandr To apply resolution # xrandr -s 1360x768 The problem is that it is not permanent […]
October 24, 2015October 24, 2015sys admin 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 […]
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 […]