Posts Tagged ‘siebel query’

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.

 

 

Utility Tool – Column To Query

 

Hi All,

Please have a look at new utility – ColumnToSQL.

It is used to convert data from MS Excel columns to below formats:

  • SQL Query. For example – select * from S_org_ext where row_id IN (‘a’,’b’,’c’,’d’……)
  • Siebel Query. For example – In Last Name column, you may query as “= ‘a’ Or =’b’ OR =’c’ OR …….”

 

Origin Of The Tool

In data migration phase, while loading data for various entities we had fallout records (i.e. Records that failed to load successfully). We needed to re-extract these records. These count of fallout records was generally in hunderds and it used to take huge amount of time to put those Records Ids in the below shown format. Thus I designed ColumnToQuery macro tool.

 

Presentation and User Guide

For detailed insight and user guide, please download Powerpoint presentation here >> ColumnToQuery – Presentation

 

Tool Setup

Please download the setup of ColumnToQuery tool here >> ColumnToQuery – Setup