Active false catalog item showing on search bar list in req item?

[Kalpesh B30]

While making Active false to some catalog Item on sc_cat_item table, and search it by using filter option on sc_req_item by applying filter as item is *name of the search item.

All false cat item not to seen on search list.

ex. on attached ss 2 cat item with same name on of its active true and another is false but still both are seen on search list.

[SumanthDosapati]

Hi @KALPESH BHAVSAR 

You will see inactive item names as well in the filter in sc_req_item table list because even if the catalog item is inactive now it might previously have requests from it when it is active.

If you want to filter that then dot walk and apply filter as below:

Mark as correct or helpful if it works.

Regards,

Sumanth

[Kalpesh B30]

Hi @Sumanth Dosapati ,

I did but still same active false catalog items are seen.

[SumanthDosapati]

@KALPESH BHAVSAR 

You have three options:

1) Modify the filter as below

Item.Active  = True

AND

[Item  =  New Email Account

OR

Item = New Email Account]

It will filter the RITMs only for the active catalog item.

------------------------------------------------------------------

2) You can change the name of inactive catalog item something like "New Email Account Old" etc so that you can differentiate.

------------------------------------------------------------------

3) Apply Filter with  catalog item sys_id instead of name like this

  item.sys_id = "active item's sys_id"

Mark as Correct if it helps.

Regards,

Sumanth

[Govind Das OI]

Hi @KALPESH BHAVSAR ,

Please refer to below links, which might help the issue

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/list-administration/task/t_RestrictBreadcrmbsWFixedQueries.html

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/list-administration/task/t_SuppressFiltersAndBreadcrumbs.html

Thank you,

govind