Dynamics 365 Business Central: Enabling Custom and Default Tables in the "Search Company Data" Feature

 Hi Colleagues,

Today, we will discuss how we can search custom table data using the "Search Company Data" feature in Business Central.

For more information regarding the "Search Company Data" feature, you can refer to the official Microsoft documentation: Search Company Data

I have added a test customer to the default customer table. 

and created three test entries in the Test Header custom table.

To search for data, enter one or more keywords in the "Tell Me" search box. Alternatively, when you run "Tell Me" in the context of an editable page, it will automatically search for the value in the currently selected field.

Click on "Search Company Data".


Here, you can see that the search results include the top results from the tables you have access to. However, custom table data is not showing in the list.

Reason: Test Header is not enabled in the list.

Now, follow below steps to add default or custom table data to the search list:

Click on the "Set up where to search" action.


The "Enable Lists for Searching" page will open. Here, you can see all the lists that are enabled for searching.


Disable "Show Only search enabled lists" to lists the all available options.


By default, only the tables relevant to specific roles are selected. However, you can browse other tables as well. You can select the tables you want to search in.

Select the table you want to add and enable the 'Enable Search' toggle.


Click on the name of the selected table. The 'Enable Fields for Searching' list page opens. You can customize the search to include fields in the selected table by turning on the 'Enable Search' toggle. By default, only indexed code and text-type fields, as well as fields used to identify the search result record, are enabled.


Refresh Business Central and search for the keyword. The list will be visible with the default tables data that we have added.

Code of the custom table and page I created for testing:

Table: 

table 50710 "Test Header"
{
    Caption = 'Test Header';
    DataClassification = CustomerContent;
    LookupPageId = "Test headers";

    fields
    {
        field(1; No; Integer)
        {
            Caption = 'No';
        }
        field(2; Name; Code[20])
        {
            Caption = 'Name';
        }
        field(3; "Type"; Code[10])
        {
            Caption = 'Type';
        }
    }
    keys
    {
        key(PK; No)
        {
            Clustered = true;
        }
    }
}

Card Page:

page 50722 "Test header"
{
    ApplicationArea = All;
    Caption = 'Test header';
    PageType = Card;
    SourceTable = "Test Header";
    layout
    {
        area(Content)
        {
            group(General)
            {
                Caption = 'General';
                field(No; Rec.No)
                {
                }
                field(Name; Rec.Name)
                {
                   
                }
                field("Type"; Rec."Type")
                {
                    
                }
            }
        }
    }
}

List Page: 

page 50704 "Test headers"
{
    ApplicationArea = All;
    Caption = 'Test headers';
    PageType = List;
    CardPageId = "Test header";
    SourceTable = "Test Header";
    UsageCategory = Lists;
    Editable = false;

    layout
    {
        area(Content)
        {
            repeater(General)
            {
                field(No; Rec.No)
                {
                }
                field(Name; Rec.Name)
                {
                }
                field("Type"; Rec."Type")
                {
                }
            }
        }
    }
}

Note: For a table to be searchable through the "Search in company data" feature, it must have the LookupPageId property set.

Hope this Helps!☺️


Regards,

Khushbu Rajvi

Comments

Post a Comment

Popular posts from this blog

Dynamic 365 Business central: How to Automatically Insert Line Breaks After a Specific Character Limit

Image
Suppose, you may have a requirement to break long text into multiple lines after a certain number of characters in Business Central. For example, when dealing with lengthy descriptions in fields like "Work Description," it's important to ensure the text wraps properly to maintain readability. In this scenario, I have implemented a solution using a tableextension to automatically insert line breaks after a specified character length (45 characters in this case). The code takes the input string, breaks it into lines, and formats it accordingly before writing it back to the "Work Description" field. This ensures that the text is displayed in a neat and user-friendly manner in the system. Code:   tableextension 50140 MyExtension extends "Sales Header" {     trigger OnInsert()     var         TypeHelper: Codeunit "Type Helper";         Crlf: Text[2];         InputString: Text[2048];       ...
Read more

Dynamic 365 Business Central : How to extend Activities Cue in Role center Page.

Image
  What is   CUE? A  Cue  provides a  visual representation of aggregated business data , like the number of open sales invoices. Cues are interactive, meaning that you can select the Cue to drill down to data or open another page, run code, and more. Cues display data that is contained in a table field. This data can be raw data or calculated data. Hi  Viewer,  To add cue extend Activities Cue(1313) table  and  Activities (1310) page Extensions. First Create a query and use it to add data in a field in the Cue table . query 50700 "Open vendor amount" {     QueryType = Normal;       elements     {         dataitem(VendorLedgerEntry; "Vendor Ledger Entry")         {             column(Remaining_Amt___LCY_LCY; "Remaining Amt. (LCY)")             {                 Method = S...
Read more