By default, SAS Enterprise Case Management uses an implicit wildcard search. A wildcard search usually produces more search results, but it can lead to longer than expected search times. A new metadata property provides the option to remove the implicit wildcard search functionality. When you specify the following property, the web application uses an index on the searched column to decrease search times:

This metadata property is set to true by default. To change the value, you can add the property in SAS^® Management Console. Navigate to Plug-ins ►Application Management ► Configuration Manager ► SAS Application Infrastructure ► Ent Case Mgmt Mid-Tier 6.3. Right-click Ent Case Mgmt Mid-Tier 6.3, and select Properties. On the Advanced tab, click the Add button. Specify the ECM.ClassicSearch.UseImplicitWildcard property with a value of false. After you add the property, you must clear the cache in SAS Enterprise Case Management in order to pick up the new value in the web application.

After you turn off the implicit wildcard search, you can still perform a wildcard search by specifying the wildcard prefix in your search string.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Enterprise Case Management 6.3_M1 is available at:

A fix for this issue for SAS Enterprise Case Management 6.3 is available at: