Siebel Query – Case Insensitive

 

Vanilla Functionality

By default, Siebel queries are case sensitive.

For example – Suppose in Siebel database two contacts exist with Last Name as ‘TEST’ and ‘Test’.

 

Then on querying for ‘Test’, only one record will be returned. Contact record with Last Name as ‘TEST’ will not be filtered in the query.

 

Required Functionality

To make query on Contact’s Last Name list column case-insensitive. Therefore both the records specified above should be returned in the result.

 

Steps to be followed

  • Log in to Siebel Tools
  • Select Table in object explorer window and search for S_CONTACT table in the Name property. Lock this item.
  • Select Column in object explorer and search for LAST_NAME column in the Name property.
  • Verify that the value of Default Insensitivity property is set to None at present. This specifies that search on this column would be case sensitive. (Highlighted in BLUE)
  • Right-click on the record and select Case Insensitivity menu option. (Highlighted in RED)
  • This will open Case & Accent Insensitivity (CIAI) wizard.
  • Click Next and then Finish.
  • Go to the Table in object explorer. Apply and Activate S_CONTACT table.
  • Compile the changes.

 

 

3 responses to this post.

  1. Posted by Kaustubh on February 21, 2013 at 11:03 AM

    Hi, Thanks for updates. Is there any provision to query from UI without case incensitivity?

    Reply

    • Dear Kaustubh

      To query in case-insensitive mode within Siebel UI without above SRF changes, you can use ~LIKE() operator.

      For example mentioned in above article, you can search as ~LIKE(‘test’) and it will return both the records.

      Please note that use of ~LIKE() operator may lead to performance hit.

      Regards
      Suansh

      Reply

  2. Posted by Johng209 on September 10, 2014 at 9:08 AM

    I like the helpful information you provide for your articles. Ill bookmark your blog and check again right here frequently. I am quite certain Ill be informed many new stuff proper right here! Best of luck for the next! bbedaebbegkk

    Reply

Appreciate your feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: