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

shivanki1 · ‎04-19-2018

Hi hkf,

We have a database view of Requested item and task sla already but the form variables are not coming in this table( sc_req_item_sla ) as well.

Although I saw the Questions[+] fields which is similar to variables but I whenever I select the column and run the report . The columns I select automatically vanishes and do not come in the report

Abdul Fathah · ‎04-19-2018

Shivanki,

For variables, You should include variable ownership table (sc_item_option_mtom) in database view.

Variables data's are stored in variable ownership table.

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

Scott Jordheim · ‎04-19-2018

I'm kind of curious if dot-walking would work without a database view being created. This setting shouldn't impact the dot-walking I'll show, but just in case it does, make sure you enable Allow base table lists (task, cmdb_ci, etc.) to include extended table fields (incident_state, os_version, etc.), and allow filtering on extended table fields. from the System Properties - UI Properties module.

I don't have high confidence in it actually displaying data when you show the variable in the Selected Columns list, but worth a shot, if trying to avoid creating that view.

Click on the (+) next to Task in the Available Columns list.
Click on the (+) next to Questions. (This should bring up your list of various Catalog Items.
Click on the catalog item you want from the pop-up menu that comes up.
You should now have the list of variables to choose from and place in the Selected Columns list. (Again, unsure if it will actually bring over data with it or not.)