Currently we have the QueryRangeType::FullText(queryBuildRange.rangeType(QueryRangeType::FullText)) as a query range type to use Full Text search. It will be translated to FREETEXT SQL statement. The problem is FREETEXT SQL statement does not support wildcard characters (like *).
Can you add a new element in QueryRangeType(lets say QueryRangeType::FullTextContains) that will be translated to the CONTAINS SQL statement(that allows *). This function will be very useful in Item search (for example class MCRInventSearch – executeSearch)
Comments
Do a "smart search" like Kurt Hatlevik: https://kurthatlevik.com/2020/11/29/d365-smarter-search-algorithm/
Category: Development