Siebel: Disable Automatic Trailing Wildcard

In Siebel applications, whenever user runs a Query for any specific text, a wildcard automatically gets appended at the end of the text. The generated SQL uses a LIKE and a wildcard instead of searching for the exact match with the search text, This is called Automating trailing wildcard.

For example when querying for Accounts with "123" as the searchspec, it retrieves all records starting with "123" like "123siebel".

This feature can be turned off @ different levels in the application:

1.) Current Query
2.) All Queries in the Application
3.)Business Component Fields
4.)All Find Objects
5.)Selected Find Objects

Disabling Automatic Trailing Wildcard for the current Query

This feature can be disabled for the current query by including equal symbol (=)  before the searchspec.




for example if you want to query for the exact match for "123siebel", enter "=123siebel" as the searchspec.

Disabling Automatic Trailing Wildcard in the entire Application

In the Application cfg file like uagent.cfg for the Callcenter application, add the below line in [InfraUIFramework] section in Siebel version 8.x and above while do the same in the [SWE] section for all other below versions.

AutomaticTrailingWildcards = FALSE

This will work only in the Thick Client. To do the same for Thin Client, perform the below steps:

1. Navigate to Administration - Server Configuration.

2. Select Enterprises, then Component Definitions. 

3. Query for the relevant component.

4. From the menu of the middle applet, select "Start Reconfiguration".

5. In the bottom applet (Component Parameters), query for AutomaticTrailingWildcards.

6. Change the value to FALSE, then select "Commit reconfiguration" from the menu of the middle applet.

7. From the server manager, restart the component (stop component <component_name>, start component <component_name>)

Disabling Automatic Trailing Wildcard for Business Component Fields

This can be achieved by using the BC User Property "Disable Automatic Trailing Wildcard Field List".

Name = Disable Automatic Trailing Wildcard Field List
Value = <comma separated field names> 

Disabling Automatic Trailing Wildcard for all Find Objects

1.) In Siebel Tools, Query for the Business Service "Search Execution Service".
2.) Add a Business Service User Property:

Name = AppendWildcard
Value = FALSE

Disabling Automatic Trailing Wildcard for selected Find Objects

1.) In Siebel Tools, Query for the Business Service "Search Execution Service".
2.) Add a Business Service User Property:

Name = AppendWildcard <FindObjectName>  (use a space between AppendWildcard and FindObjectName)
Value = FALSE