Siebel Tools >  Make a field case insensitive for search

Oracle does not recommend making field search case insensitive. This slows down the search performance.

This article shows an example how a field in a screen can be made case insensitive.

I used Siebel local database, Siebel Tools and Siebel Web Client all version 8.1.1.3.

In Web Client go to Sitemap -> Activities -> Activity List. Press the Query button. All the fields should show case sensitive values or <Case Required>.

Go to Help -> About View. We will get these values.

Screen: Activities Screen

View: Activity List View

Business Object: Action Applets: Applet[0]: Activity List Applet With Navigation; Applet[1]: Activity Form Applet;

Business Components: BusComp[0]: Action; BusComp[1]: Action;

We will want the field 'Description' to be case insensitive during search.

In Siebel Tools, go to applet. Search for Activity List Applet With Navigation Right Click on the Applet Name in Tools and select 'Edit Web Layout'.

Select ok at the next prompt. Right click on the Applet and click on 'View Properties Window' Left click on the Description field in the Applet.

In the left , you will get the Properties tab. There you can see that the Display Name= Description and Field = Description. This means that in the Business Component, this field name is Description.

Close the Properties, Columns and Applet windows, keep only the Object Explorer visible. Go to Object Explorer in Siebel Tools -> Business Component.

Search for Action.Table name is S_EVT_ACT.

Click on Business Component -> Field section. Search for Name= Description.

Confirm that Column=NAME , Join = null. This means that this field is not joined to any other table and the column name in that table should be NAME.

Go to the section Table and search for S_EVT_ACT Select Table->Column in Tools. In Column search for Name= NAME.

Lock the project. If you do not do this, you will get an error later. Right Click on NAME and select Case insensitivity.

The Configure Case Sensitivity wizard will start

Click next and finish. You should get a message saying 'The Wizard has finished making all the repository changes successfully. Click OK to exit'. In Siebel Tools, search again. select Table = S_EVT_ACT, column = NAME. The NAME column will now have Changed flag ticked. Click the Apply/DDL button.

Select Apply and press OK. You will get another popup. Fill these values Tables= Current Row Database User=sadmin Database User Password=sadmin ODBC data source = SSD Local Db default instance

Press Apply. The changes should be made successfully. After this when you log back into the Siebel Web Client and press query in the Activities -> Activity List screen, the description field should not show the <Case Required> tag.