GeeKs Blogging @ dotCOM

Siebel – Looping multiple records – Query and Process

by Nitin Jain

---

In my last post, I discussed as to how we can query and update multiple records in Siebel Database. You can find it in the link below:
Siebel – Looping multiple records – Update.

Today, let’s see if there are some good ways to loop through multiple records in Siebel in Query mode, and process the data in each of the records one by one. Let’s assume the requirement statement is, “To query for these multiple records and send them to external interface one by one”.

One of the easiest solutions, use scripts! I am extending the example I used in the previous post:

var bo_Order = TheApplication().GetBusObject ( “Order Entry (Sales)” );
var bc_Order = bo_Order.GetBusComp ( “Order Entry – Orders” );

with (bc_Order)
{
ClearToQuery();
SetViewMode(AllView);
ActivateField ( “Status” );
SetSearchSpec ( “Account”, “Nitin Test Account” );
ExecuteQuery ( ForwardOnly );

var IsRecord = FirstRecord();

while (IsRecord)
{

// Call another workflow / BS to process the data.. send to external interface in this case..

IsRecord = NextRecord();
}
}
return (CancelOperation);

Anybody who can possibly think of a better solution?

Related posts:

1. Siebel – Looping multiple records – Update records Hi, We often come across a requirement where we need...
2. Siebel – Looping Multiple Records – III Looping through multiple records is a requirement we come across...
3. Siebel – EAI Siebel Adapter – Looping Multiple Records This is a follow-up post on the post, Siebel –...
4. Siebel – SIA BC Utility Service – Loop multiple records This is a vanilla business service which provides an extensive...
5. Query on the Long Column or Field A typical problem in any EAI project. Others too!! One...
6. Siebel – FINS Industry XML Query Service “Extracting values from a tag deep down in the Hierarchy.”...
7. Siebel – Merge Records – Checklist I call this Part III, and concluding part of a...