Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

Strange Behaviour of SetSearchSpec

edited Aug 28, 2013 9:54PM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 9 commentsAnswered
Hi,
Here is the code:
CSR = sActiveBO.GetBusComp("Contact SR Intersection BC");
with(CSR)
{
    SetViewMode(AllView);
    ActivateField("Contact Id");
    ClearToQuery();
    SetSearchSpec("Sr Id", "1-ABC");
    ExecuteQuery(ForwardOnly);
    sIsRecord1 = FirstRecord();
    while(sIsRecord1 == true)
    {
        sContactId = GetFieldValue("Contact Id");
        <DoSomething>
        sIsRecord1 = NextRecord();
    }
}

SQL that is generated is below:

SELECT
      T1.CONFLICT_ID,
      T1.LAST_UPD,
      T1.CREATED,
      T1.LAST_UPD_BY,
      T1.CREATED_BY,
      T1.MODIFICATION_NUM,
      T1.ROW_ID,
      T1.CONTACT_ID
   FROM
       SIEBEL.S_SR_CONTACT T1

Can someone temme why the SearchSpec is not getting applied???

Regards,
Maggi.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center