How do get variable from RITM on sc_task_sla table list view
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2023 07:43 PM
We have a requirement where we need to show variables from RITM on list view of sc_task_sla table.
I have tried using configure list option but it is not giving me option to select variables on RITM.
I have also tried by adding new element as "parent.[variable_sys_id]" in System ui > list > sc_task_sla table but nothing worked.
I have attached a screenshot where we have two empty columns as "Technical Netname" and "Customer Name".
Currently these two fields are fields of same table but instead we want to dot walk it from parent RITM variables section.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2023 07:56 PM
I think you are talking about database view table sc_task_sla
Data for variable is stored in the table Variable Ownership (sc_item_option_mtom)
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2023 08:21 PM
Yes, Requirement is to show the catalog item variables stored on sc_item_option_mtom (from RITM) on the list view of sc_task_sla table how can I bring it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2023 09:07 PM
sc_task_sla is database view right?
If yes then it's not possible
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader