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

[shivanki1]

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.

[shivanki1]

Thanks for the Reply,

 Can you please explain How did you created the database view and how reporting will be done on this , because I am still unable to report on one of the database views we already have sc_req_item_sla. The variables field is not coming here as well.I can see Question field which I cannot select as a column don't know why. Is this a high vendor issue ?

[weikiat_guaz]

Since u already created the view, you no longer need to use report to generate the list.

Can you try to do a sc_req_item_sla.list? You should able to see the records and you can personalize your list columns to add question and value into list.

Can you share with me your sc_req_item_sla view configuration?

[weikiat_guaz]

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:

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.

[weikiat_guaz · 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.

[karthiknagaramu]

@weikiat.g Could you please share the screen shot of the view configuration. Since I am also looking for a way to create a report with SLA and Variable information of a catalog task.

Your solution will help me.

Regards,

Karthik