Quick find not working properly

SUGGESTED

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

  • 0
    SUGGESTED

    Did you try the Rebuild Quick Find steps?

    1. Try this steps first https://help.sagecrm.com/on_premise/en/2022R1/Administration/Content/Troubleshooting/TS_RecreatingQuickFindIndex.htm
    2. 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

    3. Remember to try step#2 after taking a backup. so that you have to option to revert if something goes wrong.