Calendar Component - Event handler on change of date? or server-side rendering?

App Building
1
  • Goal: I am using a Postgres DB to retrieve all events. There is around 50 events per day. I could be missing something here, but is there a mechanism to re-trigger a db query with the date range available in the calendar view?

Pulling of the events for all time will be 1000s on 1000s of records and I don't think it will be handled well without pagination of some kind.

I could be approaching this in the wrong way and would love to get some input on a better way to doing this.

2

Hi everyone, has anyone run into this situation before or have any guidance to share on how to achieve this?

3

Hey @Jeremy_DBPA,

Absolutely, you can filter your query by using the view property within the calendar which lets you know the start and end dates being shown:

image
image1169×584 62.7 KB

You can use {{calendar1.view.start}} as start date and {{calendar1.view.end}} as end date.

4

Hey @MiguelOrtiz Thanks! This worked and can't believe I missed it.

1 Like