GeeKs Blogging @ dotCOM

Siebel – Run Case Insensitive queries

by Nitin Jain

---

This is a nice tip I ran across. All the Siebel Developers use Siebel Tools and Siebel Web Client extensively. And, each one of us run over a hundred queries daily. However, when querying for some data, for eg. a Business Service Name in Tools, Siebel generally demands we enter the correct case. To streamline the process and improve productivity, I continuously keep making minor modifications in my environment settings.

Method 1:
Open your corresponding CFG file in Edit mode (for Tools or for the Client). Navigate to the corresponding section for the Datasource, Sample, Local, Server or some other custom section. Search for the following parameter and update the value from FALSE to TRUE.

CaseInsensitive = TRUE

This parameter is available in both the Siebel Tools and the Siebel Client CFGs, both on the Local and on the Server.

Method 2:
This method will work on the Server.

In the Siebel Web Client, login with Server Admin priviledges. Navigate to the following path:
Sitemap -> Administration – Server Configuration -> Profile Configuration (tab)

Query for the ‘Profile’ with the name, “Server Datasource”.
From the bottom-most applet, search for the parameter with Alias, “DSCaseInsensitiveFlg”. The parameter would have the ‘Name’, “Database Case Insensitive Flag”. Set the value to TRUE.

And you are ready to go.

Warning:
There is a field level setting that makes the query on that particular field Case Sensitive or Insensitive. It appears as a property with the name “Use Default Sensitivity” corresponding to every Business Component field.

Siebel Help says it would work with only the Id fields, and only those Id fields which are exposed corresponding to the Business Fields. We cannot set this for eg. for the field, ‘Id’, corresponding to ROW_ID in the Database Column. However, in practice, this property seems to work for all the Varchar type fields.

Ensure the flag in this field is ticked, such that this value is always, TRUE.

Be fast, be more productive, Outperform!!

Related posts:

1. Siebel – Case Insensitivity (CIAI) Wizard CIAI stands for Case Insensitive and Accent Insensitive in Siebel....
2. Siebel – Unable to login to mobile client After long time I am writing a blog… This time...
3. Siebel – ActivateField() split wide open In Siebel, we generally tend to use the fields on...
4. Siebel – Number of rows displayed in List Applet Siebel Web Client by default shows only the first 7...
5. Siebel – InvokeServiceMethod() on Calculated Fields InvokeServiceMethod() is used to invoke Business Services and take values...
6. Siebel – Unable to check out objects I will discuss the following most prominent ways to enable...
7. Siebel – EnableServiceArgTracing – Logging Messages Hi, We have already discussed at quite a length the...