Prazos Pendentes
SELECT vtiger_troubletickets.ticketid, vtiger_troubletickets.title, vtiger_troubletickets.parent_id, vtiger_crmentity.smownerid, vtiger_troubletickets.status, vtiger_ticketcf.cf_921, vtiger_ticketcf.cf_920 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 INNER JOIN vtiger_ticketcf ON vtiger_troubletickets.ticketid = vtiger_ticketcf.ticketid INNER JOIN vt_tmp_u209 vt_tmp_u209 ON vt_tmp_u209.id = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted=0 AND ( (( vtiger_troubletickets.title IN ( select translation_key from vtiger_cbtranslation where locale="pt_br" and forpicklist="HelpDesk::ticket_title" and i18n <> 'Separado para Distribuir') AND vtiger_troubletickets.title <> 'Separado para Distribuir') and ( vtiger_troubletickets.status IN ( select translation_key from vtiger_cbtranslation where locale="pt_br" and forpicklist="HelpDesk::ticketstatus" and i18n = 'Aberto') OR vtiger_troubletickets.status = 'Aberto') or ( vtiger_troubletickets.status IN ( select translation_key from vtiger_cbtranslation where locale="pt_br" and forpicklist="HelpDesk::ticketstatus" and i18n = 'Notificado') OR vtiger_troubletickets.status = 'Notificado') )) AND vtiger_troubletickets.ticketid > 0
SELECT vtiger_troubletickets.ticketid, vtiger_troubletickets.title, vtiger_troubletickets.parent_id, vtiger_crmentity.smownerid, vtiger_troubletickets.status, vtiger_ticketcf.cf_921, vtiger_ticketcf.cf_920 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 INNER JOIN vtiger_ticketcf ON vtiger_troubletickets.ticketid = vtiger_ticketcf.ticketid INNER JOIN vt_tmp_u209 vt_tmp_u209 ON vt_tmp_u209.id = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted=0 AND ( (( vtiger_troubletickets.title IN ( select translation_key from vtiger_cbtranslation where locale="pt_br" and forpicklist="HelpDesk::ticket_title" and i18n <> 'Separado para Distribuir') AND vtiger_troubletickets.title <> 'Separado para Distribuir') and ( vtiger_troubletickets.status IN ( select translation_key from vtiger_cbtranslation where locale="pt_br" and forpicklist="HelpDesk::ticketstatus" and i18n = 'Aberto') OR vtiger_troubletickets.status = 'Aberto') or ( vtiger_troubletickets.status IN ( select translation_key from vtiger_cbtranslation where locale="pt_br" and forpicklist="HelpDesk::ticketstatus" and i18n = 'Notificado') OR vtiger_troubletickets.status = 'Notificado') )) AND vtiger_troubletickets.ticketid > 0
Ranieri
eCRM Web
eCRM Web