we are getting message" There are 2 exact match" when we search for closed catalog tasks

[Ranjith95]

Recently after Washington Upgrade we have observed an issue when ever we search for Task number in our instances with below duplication message
eg : "There are 2 exact match results. View other records here: "TASK100000" in sc_task."

Solution : 

Exact match works according to the prefixes defined in the "sys_number" table.

if there are 2 tables with same Prefix, then results for both to be displayed in search.

to avoid  this issue , we need to remove/modify the prefixes with same prefixes.

>sys_number.list

>search for prefix you are looking for eg : TASK

>Open one of the record

>Modify/Delete

Option 1:

1. Navigate to sys_numbers.list
2. Search for prefix "TASK"
3. Open one of the record.
4. Delete it.
5. Flush cache with cache.do
6. Notice issue is gone.
Alternatively, you can solve this issue by following the below steps:

Option 2:

1.Go to sys_properties.list
2.Create new record
3.Under name:
glide.ui.text_search.enable_search_single_matched_record

4.Under type: true|false
5.Under value: true

#Servicenowcommunity #ServiceNow

Thanks

[Sumanth16]

Hi @Ranjith95 , 

Please refer to below thread:

https://noderegister.service-now.com/kb?id=kb_article_view&sysparm_article=KB1423554

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

Please mark helpful/accepted if it helps.

Regards,

Sumanth Meda

[Eric K1]

Where did this information come from, specifically the part about the system property glide.ui.text_search.enable_search_single_matched_record?

We are seeing this in Xanadu for SC_TASK records.

None of the other KBs referenced in this thread or elsewhere seem especially relevant.

[Ranjith95]

It was provided by servicenow, when we raise HI case with them.

Thanks