Adding catalog items variables as columns in list view of modules.

[Nikhil Bahurup1]

Adding catalog items variables as columns in application modules.

Many times we come across the requirement wherein customer wants the catalog item variables to be displayed as columns in list view of modules.

This article describes simple steps to achieve this.

1. Create a report of type List on sc_request_item table.

2. Add all the desired columns from sc_req_item table you want to be displayed in list view.

 

3. Add the desired variables from the catalog items which you want to display in list view.
4. Select the variables which you want to add as part of list view.

 

5. Save the report.

6. Once the report is saved. Open the update sets where these changes are captured and copy the value of view column of type List Layout as shown below.

7. Go to application menu where you want to create a new module and click on New button.

 

8. Go Link Type and select Link Type as URL(from Arguments:) and paste below link in Argument field.

/sc_req_item_list.do?sysparm_query=cat_item%3D1e01f08ac0a801070187b08d81c0845c&sysparm_view=RPT2a67a25c1bb83010941a0f26624bcba7

Note: Please replace cat_item sys_id with the sys_id of your catalog item and sysparm_view with the value copies in previous step.

9. Submit the module and all the variables selected appeared as columns in list view.

 

[Travis Davison]

Fantastic workaround and write up @Nikhil Bahurup1 ! Thank you for this, this helped me for a business requirement needed! 

[Kousalya Alagap]

@Nikhil Bahurup1  Thanks a lot for showing this!!! I need to implement this badly and i was looking for many thing to achieve this. 

But still i have a issue 😞  Filter condition is not effective, I set filter in report it was working there but in list view on URL  its not working

Can you please guide?

[Asep]

@Nikhil Bahurup1Thanks for the explanation ! currently i have the same requirement but when i hit point 5 save the report, all the variable is missing and left the box empty but the report saved successfully.

[tiguin2798]

@Kousalya Alagap I am having the same issue you were where once I create the module the list view is reverting. Were you able to resolve this?

[Marsha Clark]

I used the method Nikhil provided. Oddly enough I got the module to render the list view I wanted, including catalog variables, when using sc_req_item. However, I have not succeeded in getting this to work on sc_task reports. 

[Jay Jav]

Hi,

I want to produce something like that with the Export Set; do you have solution for it? @Nikhil Bahurup1 

thank you in advance.