Acessing RITM variables on SLA table

[Lucas Romani1]

Hi,

Is it possible to filter records using variables on sc_req_item_sla table filter conditions like is possible on sc_req_item table ?

I am trying to use variables on filter for report purpouses, but I can't find on filter conditions.

SC_REQ_ITEM_SLA table:

SC_REQ_ITEM table:

[Ankur Bawiskar]

Hi,

it seems SC_REQ_ITEM_SLA is a database view table?

Is that correct?

regards
Ankur

[Ankur Bawiskar]

Hi,

check this link

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

one more link

Variable columns do not show on List Report when selected table is a Database View

regards
Ankur

[Kieran Anson · Accepted solution]

Unfortunately not with that database view as the task field on task_sla doesn't allow for the special servicenow logic to show the variables option: Variable columns do not show on List Report when selected table is a Database View - Known Error (se....

You can create a new database view, with the inclusion of the necessary tables sc_item_option_mtom and sc_item_option to allow you to filter based on variable value, or construct a remote table and leverage a gliderecord query to build the data you want.