155
I have an issue with the contact quick search. When i search for a contact, it gives Generic SQL error. Tracing shows the exception "
Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot use a CONTAINS or FREETEXT predicate on column 'ParentCustomerIdName' because it is not full-text indexed.".
FYI..Quick search on all other entities work as expected. The issue is only with contact entity.
Please suggest a solution.
Hello,
I also had search problem with quick find view in Microsoft Dynamics until I developed my own solution.
its simple and fast to use!
You can use it now
I think this is exactly what you wanted
GitHub link: github.com/.../Microsoft-Dynamics-365-Advanced-Search
Hi,
Enable full text search for Quick Find by going to
Settings > Administration > System Settings > Enable full-text Search for QuickFind.
In addition If you are using on-premise,
probably no index created for full-text search.
Follow below references how to check indexes -
You might have added the ParentCustomer in Quick find view - find columns, try to remove & test it again.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (