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

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Enterprise Case Management	64-bit Enabled Solaris	6.3_M1		9.4 TS1M3
		64-bit Enabled AIX	6.3_M1		9.4 TS1M3
		Microsoft® Windows® for x64	6.3_M1		9.4 TS1M3
		Linux for x64	6.3_M1		9.4 TS1M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

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

https://tshf.sas.com/techsup/download/hotfix/HF2/B1Y.html#61944

---

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

https://tshf.sas.com/techsup/download/hotfix/HF2/T72.html#61944

---

A new metadata property, ECM.ClassicSearch.UseImplicitWildcard, improves search performance by disabling the implicit wildcard for searches.

Type:	Problem Note
Priority:	high

Date Modified:	2018-04-06 08:53:40
Date Created:	2018-03-08 17:08:27