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

I’m experiencing a similar issue. Please let me know if you find a solution.

Ankur Bawiskar · 3 weeks ago

@Tran Nhan

The reason it works in native is you can play around with the list view on RITM table

Workspace lists are rendered using sys_ux_list and columns you configure there

I believe the only possible way is this

-> create a custom field on RITM table to hold that variable value

-> write business rule or flow logic to set that custom field when RITM is generated

-> then include that column when you configure sys_ux_list

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Ankur Bawiskar · 3 weeks ago

@Tran Nhan

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Tejas Adhalrao · 3 weeks ago

Hi @Tran Nhan , @Khang Nguyen 1 ,

you need to create the field which RITM table which will stores the value of that variable on RIMT table. like how @Ankur Bawiskar mentioned .

once you create the field and store the value in it.

and if you open the sys_ux_list table list view

and open your list record

you can select what columns you have to show on workspace or list view.

If you found my solution helpful, please mark it as Helpful or Accepted Solution...!

thanks,

tejas

Email: adhalraotejas1018@gmail.com

LinkedIn: https://www.linkedin.com/in/tejas1018