Quick find not working properly

Question

Hi 
 we have recently upgraded a customer to v2022 R1 and everything seems to be working ok apart from the quick find - it returns results but the icons are missing and clicking into a record doesnt take you to the record, it doesnt do anything 
 anyone seen this before? 
 Many Thanks

Mathew Simon · Answer

Did you try the Rebuild Quick Find steps? 
 
 Try this steps first https://help.sagecrm.com/on_premise/en/2022R1/Administration/Content/Troubleshooting/TS_RecreatingQuickFindIndex.htm 
 If it does not work, the try this script -to remove spaces. 
 DROP INDEX [IDX_Bord_Caption] ON [dbo] . [Custom_Tables] 
 GO 
 ALTER TABLE [dbo] . [Custom_Tables] DROP CONSTRAINT [UC_CustomTables_Name] 
 GO 
 alter table custom_tables alter column bord_caption nvarchar ( 40 ) 
 go 
 alter table custom_tables alter column bord_name nvarchar ( 40 ) 
 go 
 CREATE NONCLUSTERED INDEX [IDX_Bord_Caption] ON [dbo] . [Custom_Tables] 
 ( [Bord_Caption] ASC 
 ) WITH ( PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , SORT_IN_TEMPDB = OFF , DROP_EXISTING = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] 
 GO 
 ALTER TABLE [dbo] . [Custom_Tables] ADD CONSTRAINT [UC_CustomTables_Name] UNIQUE NONCLUSTERED 
 ( [Bord_Name] ASC , [Bord_DatabaseID] ASC , [Bord_Deleted] ASC 
 ) WITH ( PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , SORT_IN_TEMPDB = OFF , IGNORE_DUP_KEY = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] 
 GO 
 update custom_tables set bord_caption = RTRIM ( bord_caption ), bord_name = RTRIM ( bord_name ) 
 go 
 
 Remember to try step#2 after taking a backup. so that you have to option to revert if something goes wrong.

Sage CRM

Quick find not working properly

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING