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.
| 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 greatly enhance data search features. This enhancement makes search easier and faster for users. By providing more precise and relevant search results, this feature boosts user satisfaction and productivity.
Feature details
As an AL developer, you can now specify which table fields to include in full-text search indexes on the database. When you specify these fields, the search features in Dynamics 365 Business Central become faster and provide better search capabilities. These features include:
- Companywide search (data search)
- List page search
- Lookup search
To specify full-text search, set the OptimizeForTextSearch property on fields in tables or table extensions.
In AL code, use the new && filter syntax in the SetFilter() method. For example:
FieldRef.SetFilter('&&' + SearchString + '*')
This syntax supports a subset of SQL Server’s CONTAINS operator.
Use the new OptimizedForTextSearch property on the Field virtual table and IsOptimizedForTextSearch property on variables of the FieldRef data type.
Geographic areas
Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.
Language availability
Visit the Explore Feature Language report for information on this feature's availability.