I want to filter a variable in my list view.

[AlejandroE]

Hey community,

I'm facing some problems in my instance to track some orders of a particular software_product variable input. 

When a user rise a request via Catalog item, one of the variables that user fills in, is the sofware product and we want to have this variable in our list view but not sure how to look for it.

I can't try to do it using dot walk due to the privileges I have in my instance right now.

If you can support me, it will be great. 

Thank you. 

[Tanushree Maiti · Accepted solution]

Hi @AlejandroE 

Most probably you are looking for this. Step by step instruction has been given with screen shot.

Refer this:

1.Article #19 - How to show Catalog Variables on RITM Lists 

2. How to bring the catalog variables to the list view of the RITM as it holds the OOB fields. 

[AlejandroE]

Thanks for the answer. 

Unfortunately, in client instance and due to my privileges, i can't reply this but I've done it in my own instance and it works!!!

[ayushraj7012933]

Hi @AlejandroE ,

This is a common scenario when working with catalog item variables  — since variables are not stored directly as fields on the RITM table, they don’t show up easily in list views.

Best Practice Approach

You cannot directly use dot-walking (especially with limited roles), so the recommended approach is to expose the variable value in a reportable way.

 Use Database View (Recommended if you have access)

Steps:

1. Navigate to:

   • System Definition → Database Views

2. Create a new view joining:

   • sc_req_item

   • sc_item_option_mtom

   • sc_item_option

3. Filter:

   • Variable name = software_product

This allows you to report and view the variable in list/report
option 2:

Add Variable to RITM (Best Practical Solution)

this is the most practical and commonly used approach.

Steps:

Step 1: Create a Field

• Table: sc_req_item

• Field: u_software_product (String / Reference)

Step 2: Populate Field via Flow or Business Rule

• On Catalog Item submission:

  • Copy variable value → RITM field

Example (Business Rule):

var val = current.variables.software_product;
current.u_software_product = val;

Step 3: Add Field to List Layout

• Open RITM list

• Configure → List Layout

• Add u_software_product