Siebel Search Specification (Search Spec) – What about it?

This article has been submitted by Nidhi Puri having Siebel experience of 2+ years and right now working as Project Lead.

A Search Spec is nothing but a filter on the returned set of records and if we we look atc it from database point it acts as where clause in the SQL that is formed which restricts the number of records that will be retruned from database.

In Siebel we can apply search spec to

  • Applet
  • Business Component
  • Link
  • Picklist

1. For an Applet, a search spec filters the records that are displayed on UI. The underlying BC brings back a set of records and before they can be displayed, the applet search spec applies the filter on them and displays only a subset of records.

2. For a Business Component, a search spec filters all records that would be returned from the underlying base table. This would also result in the filtering of records on the applet tied to this BC. However, the search spec in 1 above works only for that particular applet while on a BC, the search spec is inherently applied to all applets that are based on this BC.

3. A search spec on a Link will filter all child records from the destination BC.

For Example
Account/Address link. Search spec looks something like this: [City] = ‘London’, this will bring back all address records for the account where the City = London.

4. A search spec on a Picklist will filter the data that the picklist points to. For static picklist, the data exists on the List of values, so the search spec for a static picklist would look something like this:

[Value] ‘Corporate’. This would show all values other than “Corporate” when you click on the dropdown. For dynamic picklists, the search spec would something look like this: [Active Flag] = ‘Y’, this would bring back all records from the destination BC (on which the picklist is based on) where the Active Flag = Y

13 Responses to Siebel Search Specification (Search Spec) – What about it?

  1. What about if there is a Searc spec both at Applet and BC level ? which will take the prefernce or the both will be executed having “OR” or “AND” logical operator ?

  2. What about if there is a Searc spec both at Applet and BC level ? which will take the prefernce or the both will be executed having “OR” or “AND” logical operator ?

  3. It is always AND when there are searchspecs on both bc and applet.

    There is a popular interview question based on this. will be putting it up with a proper explanation soon. Just watch out for Interview Question section

  4. It is always AND when there are searchspecs on both bc and applet.

    There is a popular interview question based on this. will be putting it up with a proper explanation soon. Just watch out for Interview Question section

  5. hi neel…i would like to know some thing more about applet search specifications….i would like to know whether we can override the applet level search specifications dynamically using script? i suppose we can override bc level search specifications using cleartoquery()….can u throw some light on this regard?? Thanx 🙂

  6. hi neel…i would like to know some thing more about applet search specifications….i would like to know whether we can override the applet level search specifications dynamically using script? i suppose we can override bc level search specifications using cleartoquery()….can u throw some light on this regard?? Thanx 🙂

  7. Hi,

    I had a requirement to display the records of the current year in the applet based on a date field. Say for example, the date field is “Final Date”, I need to diaply records which is of this current year – 2009.

  8. Hi,

    I had a requirement to display the records of the current year in the applet based on a date field. Say for example, the date field is “Final Date”, I need to diaply records which is of this current year – 2009.

  9. Is there any implicit search specs on applets? I.e. an [id] search spec from a link (whether or not there is an explicit search spec on the link) when the applet use a linked BC in the BO?

  10. Hi,

    Have you got the solution for the requirment that you posted. If you have the solution plz share the same with me as i also have the same kind of requirement.

  11. hi i need some help,i need to add a filter in pick applet field which will filter the data i required..can any one know how to do that?i hard coded in search specification but i need it dynamically..

Leave a Reply

Contribute