Adding variable in Catalog Task SLA [sc_task_sla] table

[ChristineMB]

We have a requirement that we need to capture the SLA of catalog variable. I found the column "Requested Item [Catalog Task] > Variables and added the necessary variable which is shown in the screenshot below. However, when I Run the report the column is not visible. Only shows the first 2 selected columns. I also noticed that the column name is red in color. Does this mean that the column data is not connected to sc_task_sla table? Please advise on how I can capture variable data in sc_task_sla table. Thank you. 

[Mark Manders]

Can you elaborate the exact requirement? Because a variable should never have a Service Level Agreement attached to it. SLAs are an agreement on the time it will take for something to get fulfilled. That's never based on a variable (at least not to measure on, it could be that the variable itself is a trigger for a certain SLA definition, but we're often seeing that on services/cis). 

Variables aren't directly linked to the records they are set on, in a way you can easily query to them. So for this you will have to create a database view, or map the value of that variable to a field on the form, if it is that important (it doesn't even have to be visible, as long as it is mapped). 

[Ankur Bawiskar]

@ChristineMB 

It seems it's a database view joining multiple tables (sc_req_item, sc_task and task_sla)

You should be able to Show RITM variables on List report.

You should dot walk RITM -> Item since the database view has sc_task involved.

share how did you add the variable?

Did you save the report and then verify?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[ChristineMB]

I got the variable added through Task > Request item [Catalog Task] > Variables > "variable name" > required field. When I saved the report the added variable field is gone.

[Ankur Bawiskar]

@ChristineMB 

it's strange.

Did you try to logout and login and then verify?

If my response helped please mark it correct and close the thread so that it benefits future readers.