Custom Load Method RECORD CAP

jennifer-foster

I have a custom load method that retrieves all of the customer ship-to records that do not have corresponding customer document profiles.  We have a large amount of ship-to records - almost 10,000.  All of my load collections are set with a 0 so that all records are returned.  What I have noticed, is that it will only iterate through the number of records set in the Process Default > User Preferences Max Record Cap  which was set at 5000 so I end up not getting results for any ship-tos past this 5000 limit.  To verify this, I changed the User Preferences Max Record Cap  to 10,000 and now I get results past the 5000 limit. 

The 5000 is not the limit of the records that are actually displayed in my data table (there are less than 2000) but it limits the records it will process to see if they should show in the data table to 5000.  There is no indication this happens, you just have to know that the records returned are not what you expect!  I can understand setting a record cap on users, but a CLM generated from a script should not have this limit.  Has anyone found a way around this?

raviteja

Hello Jennifer,

You have to enableBookmark option.

 Boolean enableBookmark = true; 

// true - to get more records, false - to get only first set of records (No. of records was setup in From : "Process defaults" - User Preferences Max Record Cap)

Below is the sample code that is working for us. Modify as per your business requirement

//#001 - Use this method to fetch all rows eventhough there is process default settings.(Process defaults - User Preferences Max Record Cap)
public DataTable GetIDOCollection(string idoName, string returnProperties, string filter, string orderBy, int recordCap, Boolean enableBookmark)
{
DataTable idoCollection = new DataTable(idoName);

// To fetch first set of records...
LoadCollectionRequestData request = new LoadCollectionRequestData()
{
IDOName = idoName,
PropertyList = new PropertyList(returnProperties),
Filter = filter,
OrderBy = orderBy,
RecordCap = recordCap,
LoadType = LoadCollectionType.First,
EnableBookmark = enableBookmark
};
LoadCollectionResponseData response = Context.Commands.LoadCollection(request);

// Add Column Names...
foreach (string listItem in request.PropertyList.List)
{
idoCollection.Columns.Add(listItem);
}

// Add collection to return datatable
response.Fill(idoCollection);

// return if there is no data.
if (response.Items.Count == 0)
return idoCollection;

//If we have more rows, repeat until we no longer do
while (response.MoreItems)
{
request.Bookmark = response.Bookmark;
request.LoadType = LoadCollectionType.Next;
response = Context.Commands.LoadCollection(request);
//Add more rows to return datatable
response.Fill(idoCollection);
}
return idoCollection;
}