"Application Name" Field not available on Requests filters

abc1233
Tera Contributor

Hi All,

 

When I'm trying to create filter to filter Requests I can't find the Application Name  available for filter or present as a column on the filter search results.

Application name is field on RITM and I want to apply that filter on Request.

What I need to do so that I can see "Application Name" column On list view of Request and will able to apply filter on Requests.

12 REPLIES 12

Bert_c1
Kilo Patron

Neither sc_request or sc_req_item is extended from the 'sys_metadata' ("Application") table. so how you see that field in a filter definition for sc_req_item is odd.

abc1233
Tera Contributor

Hi @Bert_c1 

 

But In my instance I could see "Application Name" under variables in RITM and I want to apply filter on "Application Name".

abc1233_0-1697892482627.png

 

Harsh_Deep
Giga Sage
Giga Sage

Hello @abc1233 ,

 

Please refer this document and it will help you surely.

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0962438

 

Plz mark my solution as Accept, If you find it helpful

Bert_c1
Kilo Patron

@abc1233 ,

 

The 'item_option_new' ("Variables") table is a grand child of 'sys_metadata' ("Application") table. that is why you can see "Application" there.  If You want to see relationships with sc_request or sc_req_item tables, use a database view as described in the KB Harsh_Deep posted.