Custom Load Methods and Bookmarks or How to get get around the Record Cap

I'm working with Custom Load Methods in C# on 9.01.01. I'm able to make them work correctly, but I'm running into the Record Cap. I'm looking in the "IDO Custom Assemblies" documentation from Info but it's completely useless. It just gives a generic explanation of a Bookmark and then a weird example with XML.

Does anyone know how Bookmarks work, or have a link to some useful reference material?

Find more posts tagged with

Accepted answers

Legacy Contributor

You are dealing with two different caps - user and system. System is an absolute cap, user is a subset of the system cap. CLMs, for the reasons I stated, typically don't work with the more rows functionality. You can verify that with vendor default forms that use CLMs. Only normal IDO collections utilize the more rows functionality, but only up to the system cap.

All comments

Yao Jiang

Are you referring to record cap for loading IDOs via Mongoose rest service?

And using the bookmark to do batch loading?

Stephen Cena

Not so much from the Web Service, but yes. I'm writing an IDO Custom Assembly to load in data that I (ultimately) want to put in a Mongoose report. If I dump my output to a grid, I'm hitting the record cap.

I'm trying to find documentation that explains the LoadCollectionRequestData.Bookmark, .EnableBookmark, etc. so I can implement it properly.

Yao Jiang

Shouldn't you be able to just override the recordcap value in your LoadCollectionRequestData?

LoadCollectionRequestData Load = new LoadCollectionRequestData();
Load.RecordCap = ""; //the number you want

Stephen Cena

Yes and no. You can set the record cap, but (if I remember correctly) even if you set it larger than the system cap, the system cap takes precedence. I currently have my RecordCap set to 0 (no cap). I can try using a large cap and see if that works.

Legacy Contributor

What if you set the RecordCap to -1? If it allows you.

Stephen Cena

-1 still gives me 200 records

Yao Jiang

I have used the bookmark with the web service for batch loading but not with the LoadCollectionRequestData.

The idea should be the same though. My first GET call returns a set of records and a bookmark value for the next set of records.

I can't find any code snippet of it being used in LoadCollectionRequestData though

Stephen Cena

So did a little more testing & whatever the solution is, it's definitely more intricate than I first thought. To see if the issue was related to the LoadCollectionRequestData I was executing, I ditched it for a "for loop" with garbage data (all my IDO fields are unbound Strings). I filled a table with 1,000 values & only got 200 back.

So if I'm interpreting this correctly, there should be two pieces: Form side and IDO Custom Assembly side. Help still appreciated.

Legacy Contributor

RecordCap should be 0. But what does Process Defaults say for "WinStudio max record cap" and "Report max record cap". Those are the system settings that would control how many records you can get back.

Stephen Cena

WinStudio max is 200. I don't see a "Report max record cap". I typically set my Record Cap to 0, unless I'm trying to defend against a possible incorrect filter, then I'll set it to 1.

Even if I'm forced to live w the cap, I'm ok with it. I just need to know how to get CSI to grab the next batch of records.

Legacy Contributor

Report max record cap may be a CSI 10 only feature. The WinStudio Max is your problem. With it set to 200 you won't get more than 200 records, so there won't be more records to get. You set that to 5000 and then you can use Bookmarks to only grab 200 at a time.

Legacy Contributor

I think the premise of your question is wrong. CLMs are meant to pull a limited set of data based on parameters and procedural logic. Typically you would want any record that matches the parameters and logic, unrestricted. If you are getting too many records back, you need more parameters to better filter the results.

Stephen Cena

That may be true. Perhaps the issue I'm trying to resolve might make more sense than the original question:

There are a few reports users are looking for that would require data from lots of different IDO's. The thought was, if I create an IDO with the report fields I want (unbound), I can write a CLM to pull all the "disjoint" data together and send that to the report. It is working, but as indicated I hit the record cap.

So if you needed to get more data than your data cap, it must be in a Primary Collection? I want to be sure I'm understanding the system correctly & not overcomplicating things (like I sometimes do).

Legacy Contributor

Copyright © 2025 Infor. All rights reserved.