Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 | - | ![]() |
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.