Zurmo, creating your own report through SQL
I’m having an issue with the execution time of the scripts in Zurmo so I have created the following SQL statement to extract the data I need: SELECT `contact`.`id` contactid, `contact`.`companyname` companyname, `person`.`firstname` firstname, `person`.`lastname` lastname, `email`.`emailaddress` emailaddress, `address`.`state` state FROM `contact` INNER JOIN `person` ON `person`.`id` = `contact`.`person_id` INNER JOIN `email` ON `email`.`id` = … Read more