TMACUL

CA SDM Consulta de chamados

Blog Post created by TMACUL Champion on Dec 15, 2016

Um pequeno exemplo de consulta de chamados

 

 

select

t.name as tenant_name,

cr.ref_num,

s.sym as status,

enduser.last_name as usuario_final,

analista.last_name as analyst,

grupo.last_name as group,

ctg.sym as category,

cr.open_date,

cr.resolve_date,

cr.close_date,

cr.active_flag,

cr.summary,

cr.type

 

from call_req cr
inner join ca_tenant t on t.id = cr.tenant
inner join cr_stat s on s.code = cr.status
inner join ca_contact enduser on cr.customer = enduser.contact_uuid


left join ca_contact analista on cr.assignee = analista.contact_uuid
left join ca_contact grupo on cr.group_id = grupo.contact_uuid
left join prob_ctg ctg on cr.category = ctg.persid

Outcomes