AnsweredAssumed Answered

Hello, exist some way to display the contract number field related to the affected resource on the ticket (cr)?

Question asked by Bassoalto on Jan 17, 2017
Latest reply on Jan 19, 2017 by jmayer

I need to display the contract num field on the detail_cr.htmpl ??

 

Using SQL Server i can get it from this query:

 

select a.contract_num from svc_contract a, sdsc_map b, ca_owned_resource c
where a.id=b.map_contract and b.map_persid = 'nr:'+ dbo.hex(c.own_resource_uuid)
and a.contract_num is not null

 

Any idea??

Outcomes