"Application Name" Field not available on Requests filters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2023 07:40 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2023 08:19 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-21-2023 05:49 AM - edited 10-21-2023 05:50 AM
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".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-21-2023 05:56 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-21-2023 06:44 AM
@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.