Jeffrey's answer is great if you want to use the deafult data grid or template grid that have built in pagination. If you want something more customized, a custom widget is not the easiest option IOP.
I would suggest using a helper object with pageNo and pageSize attributes and then use retirve from database with offset and limit (see screenshot)
Hi Kriti,
If you want to use the default Mendix pagination that's normally at the top of the date grid, but place it at the bottom, please take a look at the following forum post: https://forum.mendix.com/link/questions/86750.
Kind regards,
Jeffrey