Sample Header Ad - 728x90

Full-Text Search against serial numbers?

0 votes
1 answer
648 views
Using Dynamics 365 with MSSQL. There is an option to enable Full Text Search, however once it is enabled we cannot search by partial serial numbers. For instance, KN567228 shows in the full text catalog but trying to search for 7228 will return no results. The Stoplist is empty, so that isn't the cause. This is a unique situation for Full-Text Search because there really isn't a thesaurus or wordbreaker that could break down serial numbers in a meaningful way. But I thought the search would work for partial text (like searching for 7228 in KN567228). **Should I just not be using Full-Text Search in this scenario?**
Asked by JustinCredible (3 rep)
Jun 1, 2020, 04:58 PM
Last activity: Jun 1, 2020, 08:55 PM