Query.List and Query.Count mis-match on refresh

  

Hi,

I'm having an issue when implementing a query refresh on an aggregate from screen a preparation. I can't understand why when refreshing the aggregate, then refreshing the part of the screen to display the updated results the incorrect data is displayed.

The issue seems to stem from the refresh aggregate returning a different amount of elements for the Query.List to what is stated in the Query.Count.  There isn't a max records specified on the aggregate in the preparation to restrict the items returned in Query.List so surely the items in the list should match the count? Am I missing something glaringly obvious here?

Any help on this would be greatly appreciated.

Mike.



Solution

afaik, the help says:


  • Count:The number of records returned by the query without considering the SQL Max Records property.

and for the max-records::

If a value is not specified, the Agile Platform uses the following as Max. Records:

  • In Widgets -> StartIndex + LineCount + 1
  • Exporting to Excel -> No limit of records



Solution

Thank you for the response. 

afaik, the help says:


  • Count:The number of records returned by the query without considering the SQL Max Records property.

and for the max-records::

If a value is not specified, the Agile Platform uses the following as Max. Records:

  • In Widgets -> StartIndex + LineCount + 1
  • Exporting to Excel -> No limit of records