Record limit on Queries

Jhstephenson

I have a query where I am Grouping records from a Case File, by Case Type, filtered on the Case Closed date being Null.

There should end up being about 15 groups that show up on the query and around 1300 to 1500 total records.

When I run it, even though I have the page size set to Unlimited, it only shows gets 1000 records.

Is there a way around that limit?

Jim

ACDC

I think you need to use IN BATCHES OF 1000, I seem to recall AIM will not find more than 1000 records at a time unless you use IN BATCHES OF

johntalbott

The size of the batch is 1000 by default, but the default value may be overridden by
specifying the size explicitly in the FIND action.

FIND BO IN BATCHES OF 2000

Jhstephenson

I have already tried adding IN BATCHES OF 2000 and even IN BATCHES OF 10000, but it still only gets the first 1000 records.

ACDC

did you try BATCHES OF 1000 :o

Jhstephenson

Yes. Same result.

ACDC

Are you starting the Query from a Process

Jhstephenson

ACDC

Try this Process:
FIND ... IN BATCHES OF 1000
DISPLAY 'Query Name'

johntalbott

Yes .. it's not working the way I would expect either. After adding IN BATCHES OF XXXX to a query and saving, the IN BATCHES part gets removed. Maybe it's only intended to be used in a process?

Taking "IN BATCHES OF" out of the picture, the limiting factor is the paging configuration of the grid. There doesn't seem to be a way in the config tool to set up the query to get what you are looking for. Maybe a bug?

At any rate, you can override the config tool settings with an Init Script something like this:

config.dataSource.pageSize = 1500
config.dataSource.pageable.pageSizes = [1000, 1500, 2000, "all"]

I'm not sure if you want it, but the second line provides the page size drop down with whatever custom values you want. At the very least it's an easy way for you tinker with page sizes for testing purposes.