Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
error on dashboard
#4
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


Attached Files Image(s)
   
Ranieri
eCRM Web
Reply


Messages In This Thread
error on dashboard - rslemer - 05-17-2019, 05:51 PM
RE: error on dashboard - rslemer - 05-17-2019, 06:54 PM
RE: error on dashboard - joebordes - 05-18-2019, 02:12 PM
RE: error on dashboard - rslemer - 05-18-2019, 06:35 PM
RE: error on dashboard - joebordes - 05-19-2019, 10:30 AM
RE: error on dashboard - rslemer - 05-19-2019, 01:34 PM
RE: error on dashboard - joebordes - 05-19-2019, 10:06 PM
RE: error on dashboard - rslemer - 05-19-2019, 11:22 PM
RE: error on dashboard - joebordes - 05-20-2019, 07:21 AM
RE: error on dashboard - rslemer - 05-24-2019, 05:34 PM
RE: error on dashboard - joebordes - 05-24-2019, 10:04 PM
RE: error on dashboard - rslemer - 05-30-2019, 04:15 PM
RE: error on dashboard - joebordes - 05-30-2019, 07:33 PM
RE: error on dashboard - joebordes - 05-30-2019, 08:55 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)