on 10-08-2008 8:34 AM
hi
i have a script that runs in BO to audit users list, and it ran fine until it exceed 1000 rows and i get this error :
(The program failed to run and supplied the following information, crystalEnterprise 115. FW_InfoObjects.1: Item 1001 was not found in the collection.)24:4,
is there a way of increasing the limit to over a thousand or unlimited.
here is the script:
// Get user list
var IInfoStore;
var resultquery;
var users;
IInfoStore = Session.Service("", "InfoStore");
ResultQuery = "SELECT SI_NAME, SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_KIND='User'"
Users = IInfoStore.Query(ResultQuery);
var rowcount;
var i;
rowcount=Users.ResultCount;
for(i=1; i <= rowcount; i++)
{
var line;
var info;
var dquote;
info = Users.Item(i);
line = '"' + info.Title + '"';
Script.WriteLn(line);
}
Thanks
Try
ResultQuery = "SELECT TOP 10000 SI_NAME, SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_KIND='User'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.