Skip to Content (Press Enter)
2021-04-17 17-51-40
George Jeffcock
126Views
3Comments
Solved
Max. Records
Question
Training
I am getting the following warning:

Coherence Suggestion
SQL1 'Max. Records' should be set to 'TableRecords2.LineCount' to match the number of records presented by TableRecords2.

I know what is creating the warning but need clarification how Outsystems handles max records.
1. You set in the UI (surely a no no)
2. You set it in the agregate or SQL but you get the warning.

A UI should not control the number of records retrieved, the DB should do this hence I set the SQL object to have Max records to be 5 and not as intructed the table widget to be 5. You dont want a UI going to a data base with millions of records and query all of them only to use 5 so you make the DB object return only 5 and if the ui needs more it pages.

I am hoping the max records on the aggregate or SQL object adds the limits or top or approiate clauses to make efficent queries?
0
0
17 May 2016
Copy Link
2016-03-23 19-42-07
Miguel Domingues
Staff
Hi George,

You can check in the aggregate properties the SQL query that is generated for that aggregate. When you change the Max. Records property, the Executed SQL is changed accordingly.
Here is an example: 


Regards,
Miguel Domingues
1
0
17 May 2016
Copy Link
2021-04-17 17-51-40
George Jeffcock
nice tip Miguel. Thank you. 
0
0
17 May 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.