Small and medium business | Business Central, N...

Onprem BC25 Modern Search

(1) Share

Report

Posted on by mncomputerguy

Has anyone seen an issue with modern search where it does not return any results unless a wildcard is applied before and after the search term. For instance in customers I want to find acme company. If I put *acme* it works, if I put in acme and try to use modern search, no results are found?

The sql full text feature is installed and shows enabled on the bc database.

Categories:

Dynamics 365 Business Central

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 84,274 Super User 2025 Season 1 on at

Like (0)

Report

Onprem BC25 Modern Search

Hi, hope the following can give you some hints as well.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-enter-criteria-filters?wt.mc_id=d365bc_inproduct_page#searching

Thanks.

ZHU
Gerardo Rentería Ga... 19,644 Most Valuable Professional on at

Like (0)

Report

Onprem BC25 Modern Search

Hi, good day
I hope this can help you, and give you some hints.

Fine-tune the search by using filter criteria (legacy search only)

Sort, search, and filter data in lists, reports, or XMLports - Business Central | Microsoft Learn

Best Regards
Gerardo
Suggested answer

Mansi Soni 3,391 on at

Like (0)

Report

Onprem BC25 Modern Search

Hope this Resources will help you as well!

http://learn.microsoft.com/en-us/dynamics365/release-plan/2024wave2/smb/dynamics365-business-central/change-data-search-method-lists
https://learn.microsoft.com/en-us/dynamics365/business-central/ui-enter-criteria-filters#searching
https://yzhums.com/55525/
https://www.youtube.com/watch?v=lH2Z4xfdhmY

Regards,
Mansi Soni
Suggested answer

Mansi Soni 3,391 on at

Like (0)

Report

Onprem BC25 Modern Search

Hello,

Yes, this is a known behavior with Modern Search in Dynamics 365 Business Central when SQL Full-Text Search is enabled. Full-Text Search does not support partial or infix matching by default, which means searching for a term like "acme" will not return results unless it exactly matches a token stored in the index. To get results for partial matches, users need to use wildcards such as acme.

This happens because full-text indexing breaks text into individual words or tokens and searches only those, without automatically considering substrings within them. Even though the SQL Full-Text feature may be installed and enabled, it requires the correct configuration and indexing to work effectively. It's recommended to ensure that the Full-Text Search index is properly set up and populated, and users should be made aware of using wildcards when searching for partial matches.

Regards,
Mansi Soni
Suggested answer

Sohail Ahmed 3,285 on at

Like (0)

Report

Onprem BC25 Modern Search

This happens because Business Central’s modern search uses SQL Full-Text Search, which by default requires wildcards (*) around the term for partial matches. Without wildcards, it looks for exact matches only.

To fix this, you can:

Always use wildcards around your search terms, or

Customize the search setup or filters, but that requires deeper changes.

Mark the checkbox below if this answers your question.
mncomputerguy 52 on at

Like (1)

Report

Onprem BC25 Modern Search

Hi Ramesh,

To test what your saying I typed in the entire company name, both matching case and all lowercase and the search result returned nothing. The feature itself seems to not be working, no events in the server logs or anything either.
Suggested answer

Ramesh Kumar 5,058 on at

Like (1)

Report

Onprem BC25 Modern Search

I would say no. Modern search has some limitations but I would below can help you. When you type "acme", BC interprets it as “exact match starts with 'acme'” (not contains). But when you type "acme", you’re forcing a contains-style wildcard search, which works — but it's not the native behavior for Modern Search.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-search

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.