This is a pretty popular and interesting question. I guess anybody who knows Siebel architecture (Layered Architecture not Server Architecture) properly should be able to answer it. But truth is that most of the people I have interviewed have given a wrong answer of this question. Even people have 2 years of experience have got it wrong.
The question is something like this.
I have a search spec on applet which says [Type] = “A” and I have Search Spec on BC which says [Type] =”B”. Now what records will be visible to me on UI?
Before looking at the answer of this question I would like you to have a thought on this and answer it to yourself and see if you can get it right. Having a guess is not sufficient you should also give the reason for your answer.
[poll=3]
Answer to above question is
None
Explaination:
We all know about 3 layered architecture of Siebel.
Database is going to fetch all the records which will reach business layer. Here Search Spec of the BC will filter the records with Type B and only records with Type A will be allowed to reach next layer that is UI layer. Here the search spec of applet will come into picture and records with Type A are going to get filtered which means that number of records reaching to user will be ZILCH 
In other words search spec on Applet and BC takes AND operator and the where clause in SQL is going to be Where type = ‘A’ and type = ‘B’ which will always return zero records hence no records on UI
Hope that helps
(3 votes, average: 3 out of 5)
Loading ...
10 Comments at "Search Specification on Applet and BC– Interview Question."
Hi,
This is very popular mistake done by developers. Infact Siebel Support have a well explanatory note on the above.
nice blog … do write more realted to interview question
great thoughts and sharing of knowledge keep going
pranam maalik accha likhne lage hain aap….. at least its making sure that ur next project will do good…..
[...] is the variation of the question that I had earlier posted and it is also related to Search Spec but this time it is conflicting [...]
hey good one….keep positng !!!!
Hey nice one…I was asked the same question in interview..so you can take my word surely an interview question
How can you say that after AND of serahc spec , it will return zero rows ?? It can return rows which depend on the type of search specs being given at both levels.
Example :-
Records :-
Name =Pankaj ,Age = 21
Name =Ashish ,Age = 21
BC search spec -> Age=21
Applet Search Spec -> Name =’Pankaj’
Effective Search Spec -> Name =Pankaj AND Age = 21
So 1 record will be displayed on UI !!
what you have displaying is that searchspec is on different fields. it will return case in your example. but what I am talking about is search spec on same fields. So,taking your example it would be like
Records :-
Name =Pankaj ,Age = 21
Name =Ashish ,Age = 21
BC search spec -> Age=21
Applet Search Spec -> Age =’20’
Effective search spec: Age = 20 and Age = 21
hence no records.
I hope this clears your doubt
Hi Neel and all other siebelunleashedites,
I am new to siebel so please pardon if its a very silly question. I was just working on a requirement which is
When the Opportunity Sales Stage is changed to “07 - Funded”, the Description field should be updated to “Revenue = ” .
Probably the approach would be to use the On Field Update user property in which i have to give a If condition.
Well, the point where I’m getting stuck is that the PickList “PickList Sales Stage” doesnt have a type and type value so how do i capture the sales stage value and according set the value for the description field.
Please please please ……help me with this…
Thanks in Advance
Regards.
Newbee
Comment Now!