1,004
Hello:
We have Full-Text enabled and the entity that we are attempting to search against enabled. We have two account records with account numbers 445 & F00445. When we search for 445 I expected to see both accounts but it isn't. Does anyone know why this is happening and if there is anything that can be done to allow this kind of search?
Thank you,
Stangride
Hello,
When full-text search is enabled, the leading wildcard will not be needed and/or utilized. The full text catalogs are based on full words, so when searching for 445, it would not find F00445. If you had 445 in the middle of a sentence in a text field, and that field was enabled for search, it would find that result.
If this specifically is the type of search you would need to use as a hard requirement, you likely would want to stick with standard quick find instead of using full-text search. With this, you can use a leading wildcard, and it would return both results, though that comes with a performance hit due to the need to full scan the table to find the result. This performance hit can be reduced by forcing a Recompile of the query with a query hint, but even with that the search would still take time to complete in that format.
Thanks,
Erik Hagen
Support Escalation Engineer
Microsoft Dynamics 365
Hi partner,
Did you use On-Premise instance?
As far as I konw, now in Dynamics 365 online V9 wave 2 there is no "full-text search" option in system settings.
If you are using OP, enable "full text search" will take up to 24 hours to prepare in the sql server beacuse once you enable the "full-text search" in your instance, sql server will build the fulltext-catalog, of course, you could speed it up manually. For more details, you could refer to this blog.
Hope it helps.
Best Regards,
Leo
#1
Daivat Vartak (v-9d...
225
Super User 2025 Season 1
#2
Muhammad Shahzad Sh...
97
#3
Vahid Ghafarpour
82
Super User 2025 Season 1
Share
Report
All responses (
Answers (
