siebel

Time for another 'blast from the past'. From August 2008, the below article covers the all-time favorite query language that is SQL, but not the SQL you think of now. *** Romeo and Julia(n)? About the Siebel Query Language First of all, it abbreviates to SQL which is kind of funny, of course it has nothing to do with SQL. Just like you can get more out of a spreadsheet application like Excel when you are familiar with its internal functions and syntax, you can get much more out of Siebel CRM if you are familiar with the Siebel Query Language. Where is it used? The answer to this question is very interesting, it is used almost everywhere when you define expressions. It is available in both Siebel Tools and the Siebel Web Client and since version 8.0 both the developement environment and the Web Client (that one since 7.0) sport an expression designer. Expression Designer in the Siebel Web Client click to enlarge Expression Designer in Siebel Tools (since 8.0) Here is a probably ...

This is another oldie but goodie, written 5 years ago. Enjoy! *** It's a very embarrassing moment in the life of a Siebel guy or gal when he or she finds records in the database that shouldn't be there at all. I am talking about records like these: It happened to all of us, doesn't it? Instead of querying, you create a new record with the query criteria as data. The question is now, how can you find (and possibly eliminate) these "quericates"? Simply querying for [Name] LIKE "*" OR [Name] LIKE "?" obviously won't work. Here is the solution: Escaping wildcards using the backslash \ character. The following is a query to retrieve all accounts who have an asterisk in their name: [Name] LIKE "*\**" That is one asterisk as a wildcard for any character, then the asterisk itself (escaped with \) and another wildcard for any character. Works with other wildcards (?) too. BTW: If you have keywords like AND or OR, or parantheses in your d...