Remove File Grid Limits
How Do I?
I found a little surprise today: ExpressionEngine’s File Grid Fieldtype has a 100-row limit that is not documented.
To remove the limit I had to include a ” limit=’XXX’ ” parameter in the File Grid tag pair. So my File Grid Field opening tag looks something like this now:
{file_grid_field_name orderby="file" sort="asc" limit="350"}
Per EE documentation in the File Grid Field Options I had already set the Max. Row limit to empty (unlimited) which did not work. Neither did entering a very large number in the Maximum Row area.
I’m hoping this will help others who might have this same issue.
AFAIK that limit is actually being set by the Channel class rather than by the field and is a hard-wired value that you have to over-ride using the limit= parameter.
From the file system/ee/ExpressionEngine/Addons/channel/mod.channel.php
/**
* Channel Module
*/
class Channel
{
public $limit = '100'; // Default maximum query results if not specified.
...It might be helpful to have a note of the limit in the docs (it might already be there) near to fields where it might be an issue - suggest you log it as an issue in the EE Documentation Github if you have the time / motivation.
HTH
I’ll get this added to the docs today. I know for certain this has come up before and thought we had already updated the docs.
Let me know if this covers it. https://docs.expressionengine.com/latest/fieldtypes/grid.html#limit
Andy & JCOGS, Awesome!
Thank you JCOGS for the deeper insights.
Andy, thank you for that, it reads well. I wonder if it would be helpful to also mention that in the Field Options area here: https://docs.expressionengine.com/latest/fieldtypes/grid.html#maximum-rows - That is where I would have gone to look for info related to default limits.
You guys are great. Thank you!!