Making Search Specification Dynamic.

Homepage » Configuration » Making Search Specification Dynamic.

Making Search Specification Dynamic.

By neel January 28th, 2008

I think we all know what search specification means in Siebel. But just for introduction purposes I would like to give an overview.

Search Specification is criteria that we can apply on an Siebel object to restrict the amount of data that reaches the user.

You can apply search specification on objects like BC, Applet, Picklists etc.

Search Specification becomes a part of where clause when the query is executed on the database hence only those records are brought back those satisfy the criteria.

For quite a considerable time I thought Search Specification can only be static, meaning once you give the criteria on a particular object then you need change SRF in order to make a change in that. But I was wrong, we can have a dynamic search spec too but that can result in performance impact.

How to make search spec dynamic?

We can use

LookupValue function
GetProfileAttr function

Above said two functions can help us to create a dynamic search spec.

I will give some search specs as example to show their usage.

[Activity Id] = GetProfileAttr(”ActId”)
[Name] LIKE GetProfileAttr(”NameofUser”)
([Lead PNL] = GetProfileAttr(’LeadPnlConstrain1′) OR [Lead PNL] = GetProfileAttr(’LeadPnlConstrain2′)) AND ([Contractor Flag]<>’Y')
[Sales Tool Type] = LookupValue (’SALES_TOOL_TYPE’, ‘Component’)
(([Sales Tool Type] = LookupValue (’SALES_TOOL_TYPE’, ‘Component’)) AND [Created By]=LoginId()) OR ([Sales Tool Type] LIKE (LookupValue (’SALES_TOOL_TYPE’, ‘Sales Tool’) + “*”))

We can also use * as wild character in our Search Specification for example

[HTML Control Type] = “Field OR MiniButton*”
[Name] LIKE *Neel*

In next post I would like to share a requirement where we created a dynamic SearchSpec using LOV and Profile Attributes.

(2 votes, average: 3.5 out of 5)

Loading ...

Didn't find what you were looking for? Search Here!!

7 Comments at "Making Search Specification Dynamic."

siva February 1st, 2008 (#)

Hi neel……… this s Siva i have one query..

Hi Neel,
I am having a requirement as below.
There is a list applet with a list column “Amount”.I made the total of the “amount” in all rows displayed in footer using “total required propery” in applet.
Actually the field “amount” is the calculated field in a BC
I need to extract the total that is displayed in footer for the “amount” field to a control in form applet which using some other BC.This form applet located just below the list applet where list column “amount” is present.

Can we do this without scripting? if yes please explain me how to do?
else..please help me to write scripting for this.
Thanks in advance.
Regards,
siva __.____.

siva February 1st, 2008 (#)

Hi Neel,
>
> Thanks for the Guidance and support. I have issue where I need to filter
> LOV’s Based on position.
> LOV’S : Test1, Test2, Test3
> If a user with position : Developer1 , Developer 2 logs in he has to see
> only Test1, Test2 LOV’s
> But when a user with Position Developer 3 Logs in he has to see only
> Test3.
> I have to use the same picklist .
> Thanks
>Siva__.____._

siva February 1st, 2008 (#)

Hi Neel
> I ahve one requirement.we have one date field.But we need to display in
> three fields that date,we need to split the date and have to show
> like month in one field, and year in one field, day in one field.throufgconfiguration.
> for ex: we have 1/23/2008
> we need to show in month field 1
> we need to show in day field 23
> we need to show in year fiedl 2008
>
> it is very urgent req, please reply asap
>
> thanks
> Siva__.____._

shree April 2nd, 2008 (#)

Hi Siva/Neel,

This is shree..I am new member of this site..I have found that you have posted interesting scenerio’s related to date,picklist,…here but then am not able to view the solution provided by Neel. Could you please share it with all of us.

Thanks,
Shree

Divya April 16th, 2008 (#)

Hi Neel,

Thanks for the post…Even I thought that Search specification is static in nature you have enlightened me with this post.Please post an example so that it would give a better understanding on this post.

Thanks,
Divya