500 records max

Legacy Contributor

Using the following in a form script;

oColl1 = IDOClient.LoadCollection("ue_qc_partspecs", "Item, Thickness, DrawTemp, WaterTemp, Weight", "", "",10000)

I can only retrieve 500 records and I need 1023 pulled in. How do I increase the number of records?

Find more posts tagged with

Accepted answers

All comments

kazuyuki-mochizuki

can you try setting the value in user preferences?

or values in Process defaults (you might need to signout singin)

Legacy Contributor

When i set the user preference User Data Record Cap and User List Record Cap to Retrieve All then it works.

Can you set this permanently, if so how?

antonio-caria

I think You can disable that change and but -1 to all users...

By script is always possible change some default values...

Legacy Contributor

We suggest that you not set all users to retrieve all, as it can have a significant degradation in performance. You can turn this on temporarily in formscript code with: Application.CollectionCap(0). Then execute your query and then on exit of the form, set it back to Application.CollectionCap(-1) so that the rest of the session is not affected getting all records.

Copyright © 2025 Infor. All rights reserved.