Catalog Item search is not working

[Saib1]

Catalog item search is not working in maintain item table (sc_cat_item) when searching via name or short description. There could be more tables affected with this issue..

For Example : There are multiple catalog item available with the name starts with 'Falcon'. But when you create a filter 'name starts with Falcon' in sc_cat_item table list view and search, No records found.

This issue exists only after upgrade to Washington.

1. Goto sc_cat_item.LIST
2. On the Name search with keyword "firewall"

As a result you will not get anything

1. Goto sc_cat_item.LIST
2. Right click on the record and select Show Matching

It is not working

[AnirudhKumar]

Are you admin?

If so, I think your list has additional filters that prevent showing results

[Saib1]

Hi @AnirudhKumar - Yes i am admin eventhough not able to search. for others also not able to search

[Kieran Anson]

I have experienced a bug in Vancouver where if a table doesn't have a default sort order, no records are returned as part of a filter criteria. I don't have access to the case record to get the specifics, but if you try the following to see if it's a similar issue:

• Add your search criteria via the query builder
• Set an order by on a known-valid field like name