How to show catalog item's Variable on Workspace List

Tran Nhan · 3 weeks ago

Hi Everyone,
I have a catalog item with a variable called "Is published". I want to show it on the Service Operation Workspace's List View. (sc_req_item)

I know that this can be achieved in ITIL View and Report/Visualization via dot walking, but I'm having trouble doing it in the Service Operation Workspace's List View.

Please let me know if you have any solutions. See the attached image for reference
Thank you.

Khang Nguyen 1 · 3 weeks ago

Hi @Tran Nhan and @Tejas Adhalrao ,

Thank @Tejas Adhalrao for your information. I have found another approach that still fulfills Nhan’s requirement without creating an additional custom field.

In the sys_ui_list table, you can navigate to the correct view (please note that you should select the view without a User, as this is the default view for the entire instance). You can then add a new field to retrieve the variable on the list by entering variable.<sys_id of the variable>.

View solution in original post

Khang Nguyen 1 · 3 weeks ago

Hi @Tran Nhan and @Tejas Adhalrao ,

Thank @Tejas Adhalrao for your information. I have found another approach that still fulfills Nhan’s requirement without creating an additional custom field.

In the sys_ui_list table, you can navigate to the correct view (please note that you should select the view without a User, as this is the default view for the entire instance). You can then add a new field to retrieve the variable on the list by entering variable.<sys_id of the variable>.

Tran Nhan · 3 weeks ago

@Khang Nguyen 1 ,
Thank you, it's worked!
Your solution is really helpful and easy to implement.