Implement Pagination for the Calendar Report

PHPMaker Feature Requests (PHPMaker)
1

Currently all records are loaded into the calendar report. I have reached about 800 records and it takes a really long time for the calendar report to load.

I am requesting you consider to implement pagination and allow only the records that are selected from a date picker start and end, and with the current month plus one week prior month and one week next month as default.

Many Thanks,
Carmelo

2

Please note that the Calendar Report does not obviously support pagination, since its characteristic is completely different with data in Table in List Page. When you display data in the Calendar Report, then all the data in current calendar will be displayed.

However, you may actually use Page_Selecting server event that belongs to the Calendar Report in order to filter records based on your own business-logic.

3

Thank you. Do you happen to have a simple example? I.e. display records between two dates?

4

For example, from demo2025 project, you want to display all the events only for month of September 2024:

AddFilter($filter, "Start >= '2024-09-01 00:00:00' AND Start <= '2024-09-30 23:59:59'");
5

Thank you so much. Works perfectly. Now i can build from there. Have a great day!