1204
Views
4
Comments
Aggregate default Max.Records of returned rows
Question

Hi,

I was wondering if there is a default limit for returned number of rows for aggregates? I was debugging my application and noticed that if no max.records set the aggregate returns 51 element... if I set some huge number - all rows are returned (around 200 in this case). Also If I set max.records to 0 it returns 1 row... It seems that something was changed here or I've never noticed this behavior previously.

 

2020-03-04 14-50-24
Armando Gomes

Hello Mykola,


I believe that, if you don't specify, either it will return every record or will only return a given number tied to the "display widget" - like a table records or so.


If you put 0, seems that returning 1 is "fallback" behavior since, if you don't need any record then you don't need an aggregate.


Cheers!

2021-05-05 13-05-18
Mykola (Nick) Tkachenko

Hello Armando,

I've had that thought also but in this case I have a variable with a list type that is displayed with table records widget  (with line count set to list length) and aggregate result list is assigned to this variable. 

Regarding fallback for 0 it can be used for testing purpose or another reason and as it is not mentioned in the aggregate description nor in the max.records field this behavior was unexpected (

2020-11-10 23-58-16
Raphael Ranieri
 
MVP

Hi guys, I had the exactly same behavior that Mykola described, I also use a List binded to a table with the line count set to this list length and had only 50 elements shown.

this is totally unexpected, the only work around I found was to set max records for a huge number in aggregate.

This seems like something still wrong!

2022-06-17 13-08-20
nuvemlocal

You can create there in Site Properties, a variable of type integer and put the value you wantEx: MaxRecord,and in your application call this variable, with the following writing:Site.MaxRecordIt ends up being the same thing you did, but it's good to be careful about putting high numbers, because there will be many requests that the application will have to validate. As a good practice, you can use the aggregates to search in a more consolidated way, and if you have to display the analytical data, it will be on a controlled amount and without forcing so many requests.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.