This 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 Search Spec on Applets that come into picture.
Question
I have a view with two applets one list on top [Applet 1] and one form at bottom [Applet 2] based on same BC. These 2 applets have different search specification
Applet 1 search spec is [Type] = ‘1’
Applet 2 search spec is [Type] = ‘2’
When we open this view which data I will see
[poll=4]
Please Answer the poll before seeing the Answer.
Answer:
Option 3 – data with Type = 2
Reason:
This has got to do how Applets are rendered. They are rendered from Top to Bottom. So we have records on BC with Type 1 and Type 2 as both the applets are based on same BC it will result in execution of Search Spec on both applets.
So, when the Top Applet is rendered it will show records of Type 1 but as soon as SQL for Applet 2 is going to executed it will result in records to be filtered for Type 1 and only Type 2 will be displayed which means the Search Spec of Applet 1 is going to be overridden by Applet 2.
Initialy when answering this question I had thought it might result in OR condition in SQL for both applets but it doesn’t. SQL for applets are executed one at a time so the last one overrides the previous one. To, be honest I have never tried this practically but all the research I had done points towards this answer only.
So, If you try this practically and find out something more or something different do let us all know with the help of comments.
(4 votes, average: 4.5 out of 5)
Loading ...
11 Comments at "Applet Search Spec – Interview Question."
on the top applet u will see the data with type=1 and in the below u will see the data with type=2 since the applets have different search spec it will not be a problem….
and obviously there will nto be any link between the same BC’s so the upper applet will behave as standalone and below one also…………………….
The answer to this post is that no data will be visible in that view.
The 2 search specs get AND, so the data which satisfies this condition -
[Type] = ‘1’ AND [Type] = ‘2’
will be shown and practically this data will not be possible hence there will not be any result dataset.
I checked my logic by doing a practical test.
Are you sure you put search spec on Applet and not on BC???
Coz search spec on BC will give the result you are saying.
I don’t think conflicting search specs on applet make AND clause. But still will check personally to clear any doubts.
We will see only those records which are based on the Search Spec in the Applet 1.
The Search Spec on the Applet 2 which is based on the same BC as of Applet 1 won’t work.
I have tried it practically, by putting the Search Spec to shown only those records which have a Status = ‘OPEN’ in Applet 1 and to show only those records which have a Status = ‘CANCEL’ in the Applet 2.
After Compiling i am able to see only the records with Status = ‘OPEN’ in both the Applets…
The Option 3 is correct and also it is clearly documneted in the bookshelf that only one search spec will be taken. So no other answer is possible for that. I have tried it practically as well.
i have tried this in my sample, with diff conditions it is taking for type 1 search spec(List applet Search spec is working)
it will take the Type 2 search specification.
only Type 2 records will be displayed.
Source Siebel Support web
It was found that the reason the search spec which the customer put on the list applets (top applet) were not being applied, was because the entry applets ( form applets) which appear as the detail applet also all had search specs on them. The search spec on the form applet was different to those on the list applet although both applets were based on the same BC.
It was also noted that in some of the views the search spec on the form applets was being applied rather than that on the list applet.
This is what is causing the conflict as both applets are based on the same business component.
The behavior is due to the fact that only one instance of a business component is created for each view. With only one instance being created the search specification and subsequent retrieval will be linked to the first applet that the system creates.
Solution:
After the search spec on the entry applets was removed, all the data was returned according to the spec on the list applet.
A change request # 12-G5QQ76 has been raised which has asked that the way in which Siebel decides which search specification to use is documented.
Keywords: query, applet, no records, search spec
Hi All
Sorry to offend you guys but this is my humble request to all of you those have lil knowledge of Siebel that please dont post any false or misguiding comments here because for the above Question there could be only 1 correct answer not like for some users Type = 1 records will be displayed and for some Type = 2 records.
Even though we have lil knowledge of Siebel (as Stated by you) we are clear in what exactly we are saying.
I request you to first understand the question (just go through it once again). The question here is which data will i be able to see?
Its nothing like different data will be displayed for different users (as stated by you). By the way why the Users are coming into picture here…
Comment Now!