• RSS
  • Facebook
  • Twitter
Ram
2
Comments

Date calculation in Siebel

Recently I got an opportunity to work on date field calucation in Siebel.I came to know that most of the Siebel developers are not aware of these calcualtions.

In this post I am going to list down some commonly used date calcuation's in Siebel.Most of the date calculations can be done accurately by using Julian functions in Siebel.Julian functions only take Today() or Date field name as parameter.

I am going to explain the below scenario's by taking [Birth Date] in Contact Business component as reference.

To test below scenario's go to Contact Form Applet in Siebel Call Center application and create predefined queries.
  • Scenario 1: Query to extract the contacts who celebrated their bithday in previous month.
JulianMonth([Birth Date]) = JulianMonth(Today()) - 1
  • Scenario 2: Query to extract the contacts who are going to celebrate their bithday tomorrow.
JulianDay([Birth Date]) = JulianDay(Today()) + 1
  • Scenario 3: Query to extract the contacts who celebrated their birthday in Last 6 months.
JulianMonth([Birth Date]) >= JulianMonth(Today()) - 6
  • Scenario 4: Query to extract the contacts who celebrated their birthday in current year.
JulianYear([Birth Date]) = JulianYear(Today())
  • Scenario 5: Query to retrive current month number.
currentMonth = JulianMonth(Today())-JulianYear(Today())*12

The above mentioned queries can be used in PDQ's(Pre defined queries) and in Search specification property.

Hope this helps !!!

-Ram
[...]

Categories:
Ram
3
Comments

How to display different images based on field values in Siebel


This article discusses about how to display different images based up on field values in Siebel application.

Before looking in to the example, we need to familiarize ourselves with below object types in Siebel Tools.



Bitmap Category: It provides the means to group bitmaps by function or some other relationship. The Bitmap object type is a child of Bitmap Category; therefore, every bitmap image in the repository must be found in exactly one bitmap category. Certain bitmap categories are predefined and must be used for their established purpose. For example, an applet's Background Bitmap property always checks the Applet Backgrounds bitmap category for the specified bitmap file.

Bitmap: Bitmap objects are implemented in Siebel application as references to GIF and JPG image files used by button controls and other objects in the repository.

Icon map: Defines a collection of named icon objects that are used in controls and list columns to map a field value to an icon. The field value is compared with the icon name to select the icon to be used to display the field value.

Icon: An icon uses a bitmap object to define the image for the icon.

Now, we will look in to the example.This example is tested in Siebel 8.1, Sample database.

In Opportunity Buscomp create a new calculated field Testimage






Create a new Bitmap Category Testbitmapcategory.





In Testbitmapcategory add below four Bitmap objects.








Create a new Icon Map Testiconmap.





In Testiconmap add below four Icon objects. Name value should be same as that of field value.When user chooses the field value "01-Prospecting", it will display image associated with the Bitmap ie. Bitmap1.In this way it will create link between field value and image.








Now create a List column TestimageColumn in Opportunity List Applet and expose this List Column in UI.For this List Column we need to set HTML Icon Map as "Testiconmap" and HTML Type as "ImageButton".





Now compile all objects and go to Siebel Call Center application. 
Go to Opportunities screen -> Opportunity List Applet
TestImage column will display different images based on different values in Sales Cycle field.





[...]

Categories:
Ram
1
Comments

Differences between EBC & VBC



In this post I am listing down few differences between EBC & VBC in Siebel.
[...]

Categories: