- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2018 11:38 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-20-2018 02:28 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2020 05:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2021 03:32 PM
The images are not visible in this solution, Could you share the images?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2018 07:25 AM
There should already be out of the box database views for this - try sc_request_sla and sc_req_item_sla.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2018 12:13 AM
Hi,
I hope related list condition builder helps you here, please check the below url:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-19-2018 12:23 AM
You can create database view against task SLA & Request item. So that you can get the fields details from both tables.