Scripting often gets complicated with heavily customized applications. Not every business requirement can be met with just configuration. So developers resort to scripting. But if not properly implemented, this could cause a lot of mess. Below are some more Siebel recommended best practices.
Tip3:
Use SetSearchSpec only on Indexed column. Before we do ExecuteQuery in the script, we use SetSearchSpec to retrieve only relevant records. SetSearchSpec also limits the number of records retrieved which makes the ExecuteQuery faster. But on what type of column we do SetSearchSpec on is also very important. We should always do a SetSearchSpec on indexed column so that the records are retrieved very fast. This saves a lot of burden and time on both application and database servers. Look at the code below.
Tip4:
When we use ExecuteQuery, we need not do execute query again on child BC. ExecuteQuery on parent BC also forces a query on all active child BC defined using Links. For example in the screenshot below, consider Account Object. There is Link defined between Account and Action BC. So if a query is executed on
Also, if you need to do a use SetSearchSpec on child BC, do it before the ExecuteQuery. This way, ExecuteQuery is done only once. Again this is similar to searching in the Siebel Application UI. Below is the screenshot with a simple code to demonstrate this.
I will be posting few more tips again very soon. So do check back or subscribe to RSS.
Also, if you think that this post makes sense and is helpful, leave a comment.
Related posts(Auto Generated):
January 4th, 2008 at 5:29 am
Good One, I don’t think lot of people including myself knew that a query would be also be executed in the child BC. This is a great tip. Thanks.
January 21st, 2008 at 1:09 pm
Dear sir,
I am very happy to see this website.
This is very informative site.
I am also learning Siebel and if i will get any information sure i will share with you all.
please make this site more informative.
regards
arvind
January 22nd, 2008 at 12:33 am
Thanks for the Compliments Arvind. I am adding content everyday. I will be very happy to receive any content contribution from you. I am looking forward for it.
Regards,
Sridhar
March 31st, 2008 at 3:33 pm
Dear sir,
I am very happy to see this website.
This is very informative site.
I am also learning Siebel and if i will get any information sure i will share with you all.
please make this site more informative.
regards
Agastyan
May 15th, 2008 at 5:36 pm
Simply Superbbbbbb…:)
June 4th, 2008 at 5:34 am
Good work..!!
Cheers
Piyush
June 4th, 2008 at 4:18 pm
Thank You all for the appreciation.
As you people must be aware, I need participation from your side to bring more content on this website. I wish to make the Siebel Community stronger by bringing more content on this website. So please throw some ideas or write something that I can post it over here.
I would really appreciate that!
Regards,
Sridhar
June 12th, 2008 at 5:56 am
thanks a lot for this site it really make siebel simple
this site is very good..
its wonderfll site for siebel developers…:)
September 26th, 2008 at 10:02 am
hai i need a in formation like
function BusComp_PreNewRecord()
1.Check if GetProfileAttr(Primary Position Type != ‘Admin’) and GetProfileAttr(Organization Name) = ‘BIOGEN AUSTRIA’
a. ErrMsg (“ABM’s are not allowed to create a new Contact Market record. Please contact Administrator”
function BusComp_PreDeleteRecord()
2.Check if GetProfileAttr(Primary Position Type != ‘Admin’) and GetProfileAttr(Organization Name) = ‘BIOGEN AUSTRIA’
a. ErrMsg (“ABM’s are not allowed to delete Contact Market record. Please contact Administrator”
how do i write the script for the above senarios
can u help me plz
September 26th, 2008 at 12:04 pm
hai i need a in formation like
function BusComp_PreNewRecord()
1.Check if GetProfileAttr(Primary Position Type != ‘Admin’) and GetProfileAttr(Organization Name) = ‘BIOGEN AUSTRIA’
a. ErrMsg (“ABM’s are not allowed to create a new Contact Market record. Please contact Administrator”
function BusComp_PreDeleteRecord()
2.Check if GetProfileAttr(Primary Position Type != ‘Admin’) and GetProfileAttr(Organization Name) = ‘BIOGEN AUSTRIA’
a. ErrMsg (“ABM’s are not allowed to delete Contact Market record. Please contact Administrator”
how do i write the script for the above senarios
can u help me plz
September 26th, 2008 at 4:21 pm
Hi Zakir,
Can you please post this question in Siebel Forums section?. I will help you over there. Thanks.