רשומות

Changing Font and Color

"Mere color, unspoiled by meaning, and unallied with definite form, can speak in thousand different ways." -- Oscar Wilde Status bar is a common feature in siebel where color encoding depicts the status of record. I recently encountered similar scenario where i had to display different coloured text based on certain conditions on Form Applet. Browser script clicked me first. But finally this was achieved using configuration. As i struggle to achieve similar result in List applet we will discuss how on Form applet desired could be done. Lets take Service Request entity as an example (offlately this is becoming my favourite entity). Problem Statement : If SR has some related SR then it should display some text in Red else alternate text in green. Solution: a) Go to SR buscomp. Create following fields Name: PastSRRed Calculated: True Calculated Value: " < font color='red' > "+"This SR has related SR." + " < font > " Name: PastSR...

Explicit Write in Standard Interactivity

Offlately i am working on SI application and being bombarded by lot of user acceptance issues. I am not sure whether God is really happy or its just a clearance sale that most of the time we are able to find the fix. Recently we were being asked to implement explicit write sort of scenario in standard interactivity portal. In the detail applet for service request user didn't want to click Save button to save the record instead it was required as soon as details in the Description are filled record should auto save. Again browser script comes to party. As browser script on standard events of Applet/BC doesn't work under SI architecture, only control level events are supported. Ever friendly Alex has beautifully explained the browser script architecture in his recent post . So idea here is to explicitly call the click event for "Save" button on the applet for OnChange event of Description column. Fortunately for us most of the fields on the applet were auto popula...

Illusion in Standard Interactivity

תמונה
Whenever I am asked to work on siebel standard interactivity it feels like harry potter stranded in those wild mazes. But i can tell you if you play in Java/HTML you can really unearth hidden gems in SI application. Recenty while working on Siebel eSales portal we were asked to implement  typical requirement to control button's visibility conditionally.  For the Open status button should be visible on list applet and for other status values it should be hidden. Once again "WebApplet_ShowControl" server event is  critical to its implementation as other browser events of applet are not supported in SI architecture. The idea is to modify the HTML generated at run time to  achieve conditional visibility. Below steps are required for ultimate illusion. 1 - In the HTML attribute of the Button Control which we want to make conditionally visible add below property style='visibility:hidden' By default button will be hidden and we will only make it visible when ...

User Keys & Blind Insert

If ignorance is bliss, why aren't there more happy developers? Recently I found something strange in our inbound integration. For Upsert scenario we received XML data in all Upper Case format. Despite having CaseInsensitive setting set to TRUE for EAI Object Manager the integration was failing. It was because of the fact that user keys are always case sensitive irrespective of setting at OM level. As a workaround for this we can either use "Force Case" field property at BC level or we can have numeric user keys.  Another interesting user property we came across insert unique-user-key scenario is "SuppressQueryOnInsert" at IC level to do blind insert. This is real performance boost in scenarios when you are sure incoming user keys will always be unique. Without this user property Siebel first generates SELECT statement which queries for the record with given user key across the table. This user property helps in suppressing this SELECT stateme...

How to Create a Parent with Multi Child Tabs on Aggregate Views

תמונה
As the quote goes, "You cannot NOT have a user experience". User experience is one of the most important things in product design. I personally feel that Siebel's User Interface could be a lot better than what it is (but thanks to the new Innovation pack for 2012, with the Open UI I think Siebel is getting there). Most users do not like drilling down on a record which then takes them to the detail view of a record and then navigating back to the parent record. What they usually ask for is, if they could have the tabs right on the main view of the screen. Something like this -   Some thought this was not possible but actually it is and requires just a web template change for the Aggregate views. Change the Web Template of the view to either one of the following - 1. View Parent Multi Child With Tabs 2. View Parent List With Tabs Cheers!

Generate Quote using Narrative Reports in CRM On Demand

תמונה
Hey Guys, One thing we all think about is how to design a simple solution to a complicated requirement and so today lets see how to create a Narrative report for a 1:M relation. As you may know Narrative Report can be used only on one record. But, using a combination of reports, we can do the a LOT more! All we need to do is create 2 reports linked to each other and add them to a Dashboard. let me show you how. Step 1: Create a Opportunity Parent Report Using Opportunities Subject Area (Reporting  or Real-Time) Add the fields you would like to use on the Opportunity Information Section of the Quote report. In Step 2: Create Layout , Add a Narrative View and use the this code Opportunity Parent Narrative View Code . Make sure you use the @"Number" symbol in the right places, or the values would display against the wrong columns. You'll notice that the values are not correct in this preview, don't worry. since this report is not being filtered from the Prompt yet, the...

Automate Siebel EIM Mapping using SQL

תמונה
Hey Everybody, Hope you all are doing Great! It's been a long time since my last post, apologies for that! Anyway, I have decided to make up for that time and give you some great stuff! Recently, I had a LOT of people asking for a way to Automatically generate EIM Mappings. I have written a post previously called Generate EIM mapping using SQL Script . However I made some new changes that will give you more information than before. So here are the updated versions for Oracle and MS SQL Output Preview Document Links : Do what the document tells you are you're good! Automate Siebel EIM Mapping using SQL_MSSQL Automate Siebel EIM Mapping using SQL_Oracle Watch out for more interesting Stuff! Cheers! Ryan