Reporting - How to get Task SLA and RITM form variables fields in the same report

shivanki1
Mega Expert

Hi Everyone,

I am trying to create a report where I can have TASK sla fields like elapsed percentage and RITM form Variables in the same report as columns. (Current version : Jakarta patch 😎

1. I did reporting on TASK_SLA table

2. In the available column section ,I tried to fetch the TASK[+]  fields but could not find the variables of RITM there. 

3.When I do reporting on sc_req_item table I get the variables field in Available columns which I am not getting in the Task_sla table available column.

find_real_file.png

Can someone please help me out here how to fetch variables of RITM form here.

1 ACCEPTED SOLUTION

I created a new view based on sc_req_item_sla and I added sc_item_option_mtom and sc_item_option so that @shivanki can get the RITM variables.

The result: 

Remember to make correct if this is the solution.

Please refer to my below screenshot so how to create view:

1. create new view based on below configuration.

2. Now do u_test.list to show the record for the view and now u can add QUESTION and VALUE into your list.

View solution in original post

17 REPLIES 17

Hi, below is my database view for your reference. Remember mark correct.

Thanks,

find_real_file.png

The images are not visible in this solution, Could you share the images?

There should already be out of the box database views for this - try sc_request_sla and sc_req_item_sla.

Padmanabam Tiru
ServiceNow Employee

Hi,

 

I hope related list condition builder helps you here, please check the below url:

 

https://docs.servicenow.com/bundle/kingston-platform-user-interface/page/use/using-lists-v3/task/cre...

Abdul Fathah
Mega Guru

You can create database view against task SLA & Request item. So that you can get the fields details from both tables.