web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... I would like to know h...

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

Answered

I would like to know how "Search in company data" works.

(8) Share

Report

Report

Posted on by CU08052056-0

1,187

I would like to know how "Search in company data" works.

In the case of searching "SARO20250401,SARO20250402,SARO20250403". I can not search by ""SARO20250401,SARO20250403". If I change the delimiter "," to "space", I can search that.

"," = NG

"space" = NG

Can I use some wildcards instead of "space"?

Does "Search in company data" use some kind of full text search mechanism? Full-Text Search - SQL Server | Microsoft Learn
If so, can I specify columns when searching?

Look forward to your suggestions.
Nobuhara

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Suggested answer

YUN ZHU 95,640 Super User 2025 Season 2 on at

Like (5)

Report

Hi, hope the following helps.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-search-data?wt.mc_id=DX-MVP-5004336

If you want to know more details, you can refer to the standard code.

For example,

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

yossy55 234 on at

Like (5)

Report

Hi,

Did you try "*" like SARO*

Below is searching "Ada*".

Was this reply helpful? Yes No
Suggested answer

Noha Mbi 317 on at

Like (4)

Report

Hello, have a good day

It literally gives you any table name/ any record any accessable single value found anywhere in the database.

this might help: https://www.kristenhosman.com/2023/12/search-company-data-within-business.html

Regards,

Noha - BC Developer

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (4)

Report

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

Get to data search from anywhere in Business Central. - YouTube

What’s new: Data search improvements (for developers)

The Business Central “Data Search” app (under the hood)

Search in Company Data: A Game-Changer in Dynamics 365 Business Central (Preview) — matalino

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,441 Super User 2025 Season 2 on at

Like (4)

Report

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

https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave1/smb/dynamics365-business-central/search-company-data

https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave2/smb/dynamics365-business-central/get-data-search-anywhere-business-central

https://www.prisma-informatik.com/newsroom/2023/09/business-central-advanced-search-in-company-data/#:~:text=A%20search%20can%20be%20started,which%20the%20user%20has%20access.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,577

#2

YUN ZHU 888 Super User 2025 Season 2

#3

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans