Recent Posts

Hi Sridhar,

           what u r saying is correct but how can we configure this!

Static picklist gets value from S_LST_OF_VAL table.

Dynamic picklist gets value from any other Business component which doenst refer s_lst_of_val table.

now if you can configure a picklist which referes to any BC like Account, Contact, Opportunity...then this will become Dynamic picklist.

hope this helps in understanding.

I dont think we can configure more than one gateway server.

The gateway server manages enterprise and multiple app servers. The gateway server stores information for these enterprise and app servers. So architecture or configuration wise it wouldn't be feasible. If there would be more than one gateway server there could be potential conflict. Also an App server can connect to only one Gateway server.

Hi guys,
         
    I have a requirement where i need to show a Dynamic picklist as a Dropdown.
    how is it possible using configuration.
   please anyone help on this.



Thanks

Hi,

   I have one Interview question for u guys
   Do we have two Gateway NameServer in one environment ?
   if yes, how we configure?
   if no. why?
   please give me hands on this



thanks


 

 
    Thanks a lot!! 
                   

Hi,
    Sridhar Thanks for ur reply.
    But i didnt find from the bookshelf
    If possible, give me a detailed answer for this


Thanks&Regards
prasad

[Name = Sept_4Start Date = 04/09/2010 00:00End Date = 05/09/2010 00:00]

Hi,
I was browsing through few siebel forums and found a particular issue is being faced by many developers. I will directly jump to the requirement.
You are supposed to add 5 working days in a date, for e.g. Today, and show the output date.
I assume Today is 3-SEP-10, so the output date should be 10-SEP-10. Assume Sat/Sun as holiday.
Now i have seen many developers using different technique to implement this requirement where they assume that Saturday & Sunday are holidays. But they forget that apart from weekend there are Bank holidays and other holidays in so many country.  Even few business work on few Saturdays, so we can't assume that all saturdays are holiday. So ideally our code should be generic enough to handle all of the holidays. Hope the requirement is clear now.
Now comes the solution part.
This can be achieved using siebel OOTB functionality called "Schedules".
I'll divide this in 2 task:-
1. To configure the holidays in Calendar.(BusComp "Shift Exception Hour")
2. Write a generic BS method with Inputs as Date & Lead time(lead time is the number of working days, here 5)

Now below are the steps to configure holidays:-
1. Go to Administration - Service -> Schedules
2. Create a new Exception "Calendar_Name" in All Exception list applet.
2. Create a new Schedule in "Schedules" with Exception Name = "Calendar_Name"
3. Drill down on Exception name after creation.
4. Enter records in Exception Hours list applet. Suppose you want to make 4-SEP-2010 & 5-SEP-2010 as holiday then record will be like

Name = Sept_4
Start Date = 04/09/2010 00:00
End Date = 05/09/2010 00:00

Name = Sept_5
Start Date = 05/09/2010 00:00
End Date = 06/09/2010 00:00

Done with 1st part i.e. Calendar Configuration
Now I would like to give a pseudo code for the generic function.

function AddWorkingDays(Inputs,Outputs)
{
---variable/objects declarations----
---------------------------------
sDate = Inputs.GetProperty("Input Date");
sLeadTime = Inputs.GetProperty("Lead Time");
dtInOutDate = new Date(sDate);
boShift = TheApplication().GetBusObject("Shift");
bcShiftExp = boShift.GetBusComp("Shift Exception");
with(bcShiftExp)
{
   SetViewMode(AllView);
   ClearToQuery();
   SetSearchSpec("Name", "Calendar_Name_Configured_With_Holidays");
   ExecuteQuery(ForwardOnly);
   if(FirstRecord())
   {
      sCalendarId = bcShiftExp.GetFieldValue("Id");
      bcShiftExpHr = boShift.GetBusComp("Shift Exception Hour");
   }
}
sNextDate = dtInOutDate;
for(i = 1; i <= sLeadTime; i++)
{
   sNextDate.setDate(dtInOutDate.getDate()+1);
   dtCalcDate= new Date(sNextDate);
   sNewDate = (dtCalcDate.getMonth() + 1) + "/" + dtCalcDate.getDate() + "/" + dtCalcDate.getFullYear();

   bIsHoliday = false;
   with(bcShiftExpHr)
   {
      SetViewMode(AllView);
      ClearToQuery();
      SetSearchExpr("[Exception Id] = '" + sCalendarId + "' AND [Start Date] = '" + sNewDate + "'");
      ExecuteQuery(ForwardOnly);
      if(FirstRecord())
         bIsHoliday = true;
   }
   if(bIsHoliday)
     sLeadTime = sLeadTime + 1;
   dtInOutDate = new Date(sNewDate);
}
dtInOutDate = (dtInOutDate.getMonth() + 1) + "/" + dtInOutDate.getDate() + "/" + dtInOutDate.getFullYear();

Outputs.SetProperty("NewDate", dtInOutDate);

This is it. Use this function anywhere in siebel to get the future date. This takes care of Day-Light saving changes also.

Waiting for your views.

Cheers,
Rajeev

is there a common string that u can generalize for position? if yes than there is a way.

use picklist searchspec to achieve this. Try something like this

IIf (PositionName ()  LIKE "Manager*", [Order By]<6, [Order By]>=6)

you will have to use Pick List constrain.

but I doubt you can will be able to contrain both ways because. if you did you will not be able to pick any account or contacts.

check "Configuring Siebel Business Applications" in Bookshelf. Topic: constraining dynamic picklist.