Hi,
So, if I have a million rows, does Trongate always select the entire million and then displays only 20?
Pagination question: Does Trongate always select ALL rows?
2 years ago
2 years ago
#1
2 years ago
#2
Hello and welcome!
If I understand your question correctly, yes, Trongate uses an ordinary get method, you can find it in the controller. Try putting Trongates Json method at the top of your records/manage view page to see exactly what you are getting from Trongate that may not be visually loaded.
Docs are down for construction but there are great videos on the Trongate youtube channel as well about all this stuff that is just fantasticola!
If I understand your question correctly, yes, Trongate uses an ordinary get method, you can find it in the controller. Try putting Trongates Json method at the top of your records/manage view page to see exactly what you are getting from Trongate that may not be visually loaded.
Docs are down for construction but there are great videos on the Trongate youtube channel as well about all this stuff that is just fantasticola!
2 years ago
#3
G'day stanzuliy and thank you Fin for your help on this question. However, I think stanzuliy is actually refering to the standard 'manage()' method the Desktop App creates when adding a Module to your app and the way pagenation displays rows. If so, the answer is yes, all rows are fetched and only 20 by default are displayed in the pagenation area(s) of your view file or if you change '$default_limit' to something elsethen you will get that amount of rows per page. Long story short; it would take a rewrite to correct this.
2 years ago
#4
When doing a rewrite for this, you will have to run two queries:
The first query will return the total number of records, which you will need for the pagination options (e.g. to jump to the last page).
The first query will return the total number of records, which you will need for the pagination options (e.g. to jump to the last page).