Issue
Description
All searches are going to be aggregated and displayed in all global search boxes as suggestions regardless of where they are issued from and who should be having access to seeing these results.
When users type into the text search box it runs a search against the ts_search_stats table as follows:
The search_term column starts with the characters the user entered
The mean_hits column value is greater than zero
The results are then ordered by:
search_count
mean_hits
search_term
Listed by what the maximum # of choices is set to (glide.xmlhttp.max_choices system property).
Procedure
To stop past search results displaying on Global Text Search in CMS, please see the following options available.
NOTE: Please remember to test this thoroughly on a sub-production instance before pushing it to your production instance to ensure you do not run into any further issues.
Option 1
Remove records from the ts_search_stats table
- Navigate to ts.search_stats.list from the filter navigator
- In the "Search term" column, put in the search that users are doing and find the necessary records
- Delete the records that are required to be removed
Option 2
Disable the past results from appearing for CMS
- Navigate to sys_ui_macro.list from the filter navigator
- Search for the UI Macro named "global_text_Search_Widget"
- Remove line 16 and save the record
Applicable Versions
All versions are applicable
