Filtering pages by upcoming or past dates in panel

The CMS Questions
1

Hi community,

I’m somewhat unsure how to achieve this, I made a two pages sections with events, every event has a date field. This is what blueprint looks like:

    sections:
      future-events:
        label: Aktuelle Veranstaltungen
        type: pages
        layout: table
        sortBy: date desc
        columns:
          date:
            label: Datum
            value: "{{ page.date.toDate('Y.m.d') }}"
        template:
          - event_single

      past-events:
        label: Vergangene Veranstaltungen
        type: pages
        layout: table
        sortBy: date desc
        columns:
          date:
            label: Datum
            value: "{{ page.date.toDate('Y.m.d') }}"
        template:
          - event_single

Now what I want to achieve, i want first section to show all events which are in future (or today) which the past-events should display events older than today. It should compare date field of event.

Probably it can be filtered though query, but how to do that?

Thanks in advance!

2

you can use the query option.

query: page.children.filterBy('date', 'date >', 'today')
1 Like
3

Thanks, that worked!