Share via

Specify and use full-text search indexes on table fields

  • Article
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.