The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Catalog Varibles to show up in the RITM list view

Venkat799
Kilo Expert

Hi,

I have a requirement to create a new list view which references to a table RITM, but on that list view I need to get the variables from the catalog item and the data should populate in to that columns on the list view.

Any suggestions would be appreciated.

Regards

Sree  

5 REPLIES 5

Jace Benson
Mega Sage

Last I remember this is still not possible.  To do this you would have to do a database view between sc_req_item, and sc_item_optiom_mtom and then dot walk to the dependent record to get the value, and dotwalk to the parent to get the question to get the variable.

This is possible now at least in Core UI, there's a variables option when go to configure a list.  If you don't have admin permissions, you can also make a report (right click from your list headers, and create a bar graph, change it to a list, change the columns, variables should be listed there too).

kiruthika
Kilo Expert

Hi,

 

1)Create a new view for RITM table

2)Navigate to sys_ui_list_list.do and open a view you have created

3)In the List Elements related list create a new record and set Element field to variables.sys_id (sys_id of the variable in item_option_new table)

Hi @kiruthika 

 

 

I tried to bring in the catalog item variable on the list view of the My Groups Work list using the above steps listed. I'm getting the variable name but the value of that variable is populated only when we click on the list view .Can anyone help me with this. Please find the attachment below for the list view of how it is been visible.I tried to bring in the catalog item variable on the list view of the My Groups Work list using the above steps listed. I'm getting the variable name but the value of that variable is populated only when we click on the list view .Can anyone help me with this. Please find the attachment below for the list view of how it is been visible.


Bhavya11_0-1679049021496.png

 

Regards,

BK