Reporting: RITM variable and task sla

[Nitin Panchal]

Hello, 

I am trying to build a report based on RITM and Task SLA and to build that I am using OOB database view sc_req_item_sla. In the report I need columns as catalog item variables and Task SLAs (Has breached, Business Elapsed Time, Actual Elapsed time) in report. I can navigate to the catalog item's variable in when choosing columns through Request->Questions->Catalog Variables but as soon I click Ok after choosing columns and refresh the report , those selected columns of catalog variables removed automatically. 

1) Choose columns and selected catalog item variables and Task SLA variable (actual elapsed percentage)

2) Clicked Ok and refresh the report. Catalog item variables removed. 

3) Then if I go back and choose columns again , those selected catalog item variables from step one removed automatically . 

Thanks,
Nitin

[Jay N]

Hi weikiat_guaz,

Can you please re-share the images, as images are no longer available.

Thanks, Jay

[weikiat_guaz]

Hi Jay,

In my post, I did re shared before. Refer my replied At ‎04-19-2018 12:43 AM

[weikiat_guaz · Accepted solution]

I solved this question before. You can refer to my answer here Answer

[Nitin Panchal]

hi weikiat, 

Thanks for your response. if you dont mind, can you please re-post snapshots of your database view ? I notices that images on that answer is not visible. 

Thanks, 
Nitin