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.
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.
Thanks for your reply !
But we are avoiding to create database view . But Is this a issue of Service Now Vendor? ideally we should get all the fields of Requested item in the available columns to report on Task_sla table as well as task is a reference field. We get in sc_req_item table so here in Task_sla also it should be the same.
I think maybe is their limitation.
My scenario:
u_xx_request is my custom table and it reference to sc_req_item as well. When I do reporting on this u_xx_request table, I able to select the variables from RITM as well but when you generate the report and the variable column is not created.
My solution:
1: create view
Thanks a lot guazwk for explaining !!! Appreciate your help.
Although Can we get Question as a column (e.g., Vendor Code,PAN card in the column and value in the rows)
I am getting this in report currently. Here, all the questions are coming present in the service request creating multiple records of same RITM.
