2. PHPRunner General questions
  3. Limit Export Rows
This topic is locked

Limit Export Rows

 		6/1/2023 8:47:49 AM
PHPRunner General questions
D
 DRCR Dev author

Hi
The Export feature ignores any limits placed on the MYSQL database query setup in the query tab. I have a page that limits results to 100 rows but the Excel export wants to export everything.
I can see there is a 100,000 line limit as the export fails on the 100,000th row.
How do I force the Excel export to respect the row limit in the MYSQL query?
Cecil
D
 		DRCR Dev author 6/1/2023

Solution: use the built in row limiter and not the mysql LIMIT command.
K
 		KM 9/2/2023

Hi DRCR Dev,
Where can we locate this built in row limiter?
Thank you in advance.
K
 		KM 9/3/2023

Hi DRCR Dev,
Please ignore the message above. Sorry for the trouble.
Thanks again.