TMACUL

CA SDM::. Um pequeno exemplo de scoreboard / Gerenciador de Filas

Blog Post created by TMACUL Champion on Mar 4, 2017

Exemplo de scoreboard / Gerenciador de Filas

 

 

  • Minha Fila
    • Meus Incidentes CODE = LOGININ - assignee = @cnt.id AND active = 1 AND type = \'I\'
    • Minhas Solicitações - assignee = @cnt.id AND (type = \'R\' OR type = \'\' OR type IS NULL) AND active = 1
    • Meus Problemas - assignee = @cnt.id AND active = 1 AND type = \'P\'
    • Agendados - active = 1 AND call_back_flag = 1 AND assignee = @cnt.id AND status <> \'RE\'
    • Agendados - Vencidos - assignee = @cnt.id AND active = 1 AND call_back_flag = 1 AND call_back_date < EndAtTime(\'TODO_TODAY\') and status<> \'RE\'
  • Meus Grupos
    • Sem Responsável
      • Incidente - (group.[group]group_list.member IN (@cnt.id)) AND active = 1 AND type = \'I\' AND assignee IS NULL AND status <> \'RE\'
      • Solicitação - (group.[group]group_list.member IN (@cnt.id)) AND active = 1 AND type = \'R\' AND assignee IS NULL
      • Problema - (group.[group]group_list.member IN (@cnt.id)) AND active = 1 AND type = \'P\' AND assignee IS NULL and status <> \'RE\'
    • No Grupo
      • Incidente - (group.[group]group_list.member IN (@cnt.id)) AND active = 1 AND type = \'I\' and status <> \'RE\'
      • Solicitação   -  (group.[group]group_list.member IN (@cnt.id)) AND active = 1
      • Problema    -  (group.[group]group_list.member IN (@cnt.id)) AND active = 1 AND type = \'P\' AND status <> \'RE\'
  • Não Atribuídos
    • Incidentes     CODE INUSG / (assignee IS NULL AND group IS NULL) AND active = 1 AND type = \'I\'
    • Solicitações  CODE= CRUSG /  (assignee IS NULL AND group IS NULL) AND (type = \'R\' OR type = \'\' OR type IS NULL) AND active = 1
    • Problema  CODE=PRUSG   /  (assignee IS NULL AND group IS NULL) AND active = 1 AND type = \'P\'

Outcomes