web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Performance issue with TableExt fields when use <Search>

(0) ShareShare
ReportReport
Posted on by 5

BC18 on-prem

Case: 
We have added several fields to the item table, and list: visible = true.

The customer used the Search field to find an item, of 30 thousen.

When then navigate into the item card we got this message (occasionally)

"Searching for rows is taking too long. Try to search or filter using different criteria."
My thoughts
I belive this is related to the extended fields. If they are visible in the list, usinge the search feature, all those extended fields will be part of the "Page filters" (by join).
When we then opens the item card, the same page filters are following.
If I remove the search criteria, and open the same item - it came up immediatly. 
Question
Is there somehow to avoid those external fields to be part of the "Page filter" when using the Search feature?
I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    Hi

    I would suggest  make those fields as Visible = false, if they are not necessary to show, user can easily show them by using Personalization features available in BC.

  • svwfr Profile Picture
    5 on at

    Yes, we have done so!

    But the customer design some of the extended fields to the list and then we got the performance issue.

  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    Ok, But then I am not sure if we have other feature available not to search specific fields, if you try Search it will search on each fields available on the page.

  • Suggested answer
    svwfr Profile Picture
    5 on at

    My first thought was to drop the "page filters" when navigate into the card, as then you have the record key and do not need the filters anymore.

    Else some propertie on the pagefiled to flag: not be part of the search criteria.

    As the architecture is now, the best pattern it not to provide extended fields to the list at all as it kills the performance.

    Any way, I appreciate your feedback and a closure that nothing more I can do.

  • Suggested answer
    Nitin Verma Profile Picture
    21,812 Moderator on at

    Hi,

    you can try to change the Page type property with PageType = ListPlus;

    Then try.

  • Suggested answer
    Avinash B Profile Picture
    1,455 on at

    I just got a thought.

    Add a customized action to search. Let the user enter the value what he want to search, you can write a code to apply the value on some limited fields to search from list. Filter the records and display only them.

    You can create another action to clear out the filters.

    May be it helps you...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 677 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 447 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans