How to create a Interactive Filter base RIT question values

[marko_mald]

I want to create a filter based on users historical responses for catalog item request, I'm currently getting this report, but I want to be able to filter by "ddm_stage" column. this "ddm_stage" its a variable from my catalog item.  

 

[BillMartin]

Hi @marko_mald ,

I suggest finding a template similar to what you need, duplicating it, and changing the filter and tables in alignment with your requirement.

please like and mark as accept as solution if you find it lucrative.

[marko_mald]

Hi @BillMartin , what I think will really help me, its to know which tables I need to look into, for example, requested items are stored in sc_req_item, but what about values for questions? 

[BillMartin]

Hi @marko_mald ,

The structure of ServiceNow is always table-based. Each form is represented by a table. To get the values of any form you need to know the correct table then after you will just need to navigate to the application menu and type in tablename.list. From there, you should get the values of what you are looking for.