Share via


Specify and use full-text search indexes on table fields

Important

This content is archived and is not being updated. For the latest documentation, go to What's new or changed in Business Central. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically - Oct 1, 2024

Business value

With the new full-text search metadata on table fields, AL developers can significantly enhance data search features, making them easier and faster for users. This feature improves user satisfaction and productivity by providing more precise and relevant search results.

Feature details

As an AL developer, you can now specify which table fields are included in full-text search indexes on the database. By doing this, the following search features will be faster and provide better search capabilities:

  • Companywide search (data search)
  • List page search
  • Lookup search

To specify full-text search, you set the OptimizeForTextSearch property on fields in tables or table extensions.

In AL code, you can also use a new && filter syntax in the SetFilter() method. For example:

FieldRef.SetFilter('&&' + SearchString + '*')

The new syntax supports a subset of SQL Server’s CONTAINS operator.

You can also use new OptimizedForTextSearch property on the Field virtual table and IsOptimizedForTextSearch on variables of the FieldRef data type.

Additional resources

Enable optimized text search on table fields (docs)