Dynamics 365 Business Central: How to add custom tables to Search in company data

Dynamics 365 Business Central

Hi, Readers.
Today I would like to briefly share what I learned from Business Central Forum yesterday, how to add custom tables to Search in company data. More details: Can I search extention table data from “Search in company data”? and How to customize to search custome table from Search in company data.
Search in company data feature was first released in Dynamics 365 Business Central 2022 wave 2 (BC21), and then integrated with Tell Me in Business Central 2023 wave 2 (BC23). More details: Dynamics 365 Business Central: Search for Specific Data (Search in company data) and Business Central 2023 wave 2 (BC23): Get to data search from anywhere (Search data in Tell Me)
For example,

We also briefly discussed how to use it. More details: Dynamics 365 Business Central: Search data from multiple tables simultaneously (No Customization)

So here’s the question, does this support custom tables/pages?

I did a simple test.

This custom page can be found in Page Metadata table, but not in Enable lists for searching.

Why? I first checked the standard code of this page and found that some filtering would be performed when the page was opened, but my page met this condition.

After Mohana Krishna‘s reminder, I found that it has another control. PageNo displays the page set in the LookupPageID property in the table.

So the solution is very simple, just add the LookupPageID property to the custom table. For example,

Then you can find you custom table in Enable lists for searching.

Enable Search:

Great.

Very simple, give it a try!!!😁

PS:
1. Other experts have also discussed this, so you can refer to it directly.
Why My Custom Table/Page Isn’t Appearing in “Search Company Data” in Business Central – And How to Fix It?
Dynamics 365 Business Central: Enabling Custom and Default Tables in the “Search Company Data” Feature

2. The Data Search extension is preinstalled in Business Central. If you prefer to use a third-party app to search your company data, you can uninstall Data Search. On the Extension Management page, search for Data Search, and then choose Uninstall.

3. If you need to refer to the standard code of this feature, you need to add the dependencies setting in app.json and download the symbol file.

  "dependencies": [
    {
      "id": "ac14293f-1eb7-4a7b-9936-b280da31970b",
      "name": "Data Search",
      "publisher": "Microsoft",
      "version": "25.0.0.0"
    }
  ],

END

Hope this will help.

Thanks for reading.

ZHU

コメント

Copied title and URL