the inverse works, ie not equal null lists all with assigned relationship
listview debug
SELECT vtiger_troubletickets.title, vtiger_crmentity.smownerid, vtiger_troubletickets.status, vtiger_troubletickets.parent_id, vtiger_crmentity.createdtime, vtiger_troubletickets.from_mailscanner, vtiger_troubletickets.ticketid FROM vtiger_troubletickets INNER JOIN vtiger_crmentity ON vtiger_troubletickets.ticketid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid LEFT JOIN vtiger_account ON vtiger_troubletickets.parent_id = vtiger_account.accountid LEFT JOIN vtiger_contactdetails ON vtiger_troubletickets.parent_id = vtiger_contactdetails.contactid WHERE vtiger_crmentity.deleted=0 AND ( (( trim(vtiger_account.accountname) IS NOT NULL OR trim(CONCAT(vtiger_contactdetails.firstname,' ',vtiger_contactdetails.lastname)) IS NOT NULL) )) AND vtiger_troubletickets.ticketid > 0 ORDER BY vtiger_troubletickets.title DESC
how to generate workflow email alert if you didn't received a workflow email from yesterday today.?
today there should be an email alert that no report done yesterday.
System include a registry for all global variable defined in this table
but when one specific registry is removed, not is erased into table
How system knows what registry as active?
My question is, because I wish created a job include or change a text field, with a text in global variable ApplicationAnnouncement to display a message, when connection with PBX is broken
In other words, all time my monitoring process identify connection is down, my plan is input a text message in this GV to alert all users to contact a support for solve this problem.
In the CRM contact have picture field.
I would like to import a lot of contacts with the pictures.
Each contact have unique picture name in my disk directory.
