Sending email from eScript

Sending email updates from Siebel is quite easy, we just have to call Outbound Communication Manager, an OOB Business Service to trigger emails.

Automatic login to Siebel thin client

While in development, I used to get bugged up by entering credentials every time application needs to be accessed. Out of frustration I have found way to bookmark the credentials in IE favorites so that it directly takes the user to application home screen.

Generate Random Number (Cont..)

In continuation of my earlier post , I am sharing another way of generating random number in siebel using  vanilla SIS OM PC Service.

SIS OM PC Service is a vanilla service which provides a method to get new system generated row id as output.
The output can be utilised to generate random number by calling RowIdToRowIdNum() in expression.

Workflow:

Step 1 : Service :SIS OM PC Service Method: Get Next RowId
Output: Next Row Id

Step 2: Service: Workflow Utilities
Output : Random Num [Type Expression] : RowIdToRowIdNum([&Next Row Id])


Thanks to Sebestian for sharing this.

How to see the SADMIN / SIEBEL password un-encrypted!

Today i have seen a very strange data in Siebel database that actually shouldn't be there just as a un-encrypted free text. I think people from Siebel Admin would know that which table i am talking about.

How to change default location of logs on Siebel Server !

Location of Siebel Server logs is set while installation of the server. And most of the time Administrator keeps it to the default location i.e.. sea77\siebsrvr\logs directory. But sometimes the installation location of siebel server is kept on very small and faster disk drives to improve performance, thus there is no or very less space is left on the drive for the extended log levels.

Date functions in Siebel eScript

If you have worked on any date field then you would be knowing that some of the standard date functions are not available in Siebel escript, like converting date from one format to another, adding number of business days to a particular date, comparing two dates etc.,

Here are some methods built in eScript that perform these operations.

Case Insensitive Query in Siebel by using LIKE operator !

I think most of the readers would know how to perform an case insensitive search/query in Siebel. Those who don't read on!

Case insensitive query in Siebel means to query the database records using the LIKE operator in SQL. This type of SQL tends to be slow as they return more records than the equal (=) operator.

Get Workflow Instance Id from the process property value!

Workflow Instance monitor is one of the best out of the box debugging techniques available in Siebel. But this also lacks in some aspects.

As most of developer would know that there is no way in instance monitor view to identify the workflow instance for specific object id or process property value.

Alternate use of List Of Values

Most common use of list of values comes in implementation of multilingual siebel applications. But its global presence all over the applications objects makes them extremely useful for writing switches in codes/workflows. I saw one great use in creating the stubs for the real time interfaces in Siebel EAI.