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

shivanki1 · ‎04-18-2018

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.

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

weikiat_guaz · ‎04-20-2018

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

weikiat_guaz · ‎12-15-2020

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

Thanks,

AsharRahul · ‎03-23-2021

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

Josh Cooper · ‎04-19-2018

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

Padmanabam Tiru · ‎04-19-2018

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 · ‎04-19-2018

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

Thanks,
Abdul Fathah
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.