Catalog Item search is not working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2024 05:51 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2024 06:00 AM
Are you admin?
If so, I think your list has additional filters that prevent showing results
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2024 06:44 AM
Hi @AnirudhKumar - Yes i am admin eventhough not able to search. for others also not able to search

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2024 06:03 AM
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