Records are not filtered correctly even though I enabled the lookup feature to search by a single character and to search within alphanumeric words

Article number:0401077

There are cases where records that should have been registered are not listed as matching candidates even after enabling the "1 Character Search and Alphanumeric Substring Search" option in the Lookup settings and trying to retrieve data with Lookup.

Cause and solution

The index of the app used as master data (reference destination) might be being updated.
Please wait until the index update is complete.

Note that the time required for updating the index varies depending on the amount of data in the master app (reference destination) and the system load.

Filtering Behavior during Indexing

During the index update process, filtering by a lookup field works as follows:

  • Even if the option is selected for Enable Single-Character Search and Search within Alphanumeric Words (Recommended), this setting takes precedence and filtering is performed as if the option is disabled.
  • Even if you add or edit records in the app used as master data (reference destination), the added or edited records will not be displayed in the filtering results.

When the index update process is complete, the filtering condition will be applied based on the information of the latest record, assuming that "Search for the first character and search within alphanumeric words" is enabled.

Timing of Index Updates

When you check "Enable 1-character search and search within alphanumeric words (recommended)" in the Lookup settings and then publish or update the app, the index of the app that contains the master data (reference destination) is updated.

This process is performed once for each app that is used as master data (reference destination).
After the index update is completed, even if you disable and then re-enable "Search for a single character and alphanumeric word", or set a new lookup to get master data (reference destination) from an app, the update process will not be performed again.