Aggregate wrong count value

Aggregate wrong count value

  
I am trying to execute  aggregate function but the query is not returning me correct no or records in the UI. When I debugged it, I found that the No of records that is being fetched by query and the count is different. And in the UI container of table records the no of records that is being shown is equal to the count value. Am I doing anything wrong in the implementation?
Hi Suman,

The optimizer doesn't fetch more records than needed for the display in the Table Records. Is that what you are seeing?
Based on what logic the optimizer is working. BTW, I think I solved it setting the max record count property to the <Table_Name>.LineCount. But I need to test it using different condition.
Hi Suman,

That won't work of you do that in the preperation. Since the screen isn't rendered, the LineCount of the Table Records will always be the default of 50, iirc. But if you set a record list as input for a the Table Records, the optimizer will fetch the number of lines needed for display.