Configuring wildcard search in value search

You configure wildcard search during value searches in the Global Configuration Record (GCR), using either a request to the Configuration Web Service or Integrator.

Unlike the option for enabling wildcard search in text search, which is performed by editing each attribute in its PDR (which affects only a single attribute), the GCR globally affects the enablement of wildcard search in value search for all attributes.

The mdex-config_EnableValueSearchWildcard attribute in the GCR specifies whether wildcard search should be enabled or disabled for value search across all attributes in the Oracle Endeca Server data domain. The valid settings for this attribute are:
  • If set to true, wildcards are supported for value search.
  • If set to false, wildcards are not supported for value search. The default is false.

If you change this setting for the GCR on a data set with a large number of existing records, the operation can take a long time to process, due to re-indexing. Thus, it is recommended to change this setting in the data domain before you load records (after evaluating whether your application requires wildcard search on value search for all attributes).

Wildcard queries at the end of the search term (for example, gua* for the search term guarantee) are always enabled even if wildcard search is disabled for value search for the attribute.