[Resolved] Hide past events (The Events Calendar) by filter in toolset View

[Author]

Posts

[antond-3]

I'm trying to hide past events from plugin "The Events Calendar" in a toolset View page.
I know now Time format of an Event is stored in database as a string instead of time. How can I managed this to get it work?

Found something like this
https://toolset.com/forums/topic/filter-by-custom-date-field-based-on-todays-date/
but I can't get it to work

Thank you!

[Shane]

Hi Anton,

Thank you for getting in touch.

Can you send me a screenshot of the query filters that you are currently using on your view to setup the date filter?

From there I should be able to let you know whats wrong.

Thanks,
Shane

[antond-3]

Hi Shane,

Thanks for your reply. Hope you can figure this out.

Thanks!

[Shane]

Hi Anton,

Thank you for the screenshot. So for the most part your filter is correct, however instead of setting the filter to a string you need to set it to a number.

This is because the field is stored as a timestamp and the timestamp is a number so you will need to do the comparison logic as a number.

Please let me know if this helps.
Thanks,
Shane

[antond-3]

Hi Shane,
Thanks for your reply, but it doesn't helped.

"No items found"

Can it be something Else?

[Shane]

Hi Anton,

The solution should be changing it to a number unless Events calendar made a change.

Would you mind allowing me to have admin access to the site as well as a link to the page so that I can have a look ?

The private fields will be enabled for your next response.

Thanks,
Shane

[Shane]

Hi Anton,

Thank you for the credentials, however I need a link to the page where you are testing the view on.

Thanks,
Shane

[antond-3]

Ah yeah sorry, I've written it in the private post

[Shane]

Hi Anton,

So I went ahead and did some checks for you to see why this isn't working.

It turns out that the events calendar plugin is actually storing the values as an actual date and not a timestamp.

So in order to filter this you will need to use a custom hook. Here is an example below.
https://toolset.com/forums/topic/view-to-show-current-of-future-events-from-the-events-calendar/

The only thing you will need to change is the View ID array to just have your view's ID in it.

You can add the custom code in Toolset -> Settings -> Custom Code. Once you've done this please remember to activate the code.

Please let me know if this helps.
Thanks,
Shane

[antond-3]

Hi Shane,

Whare can I find these ID's?

[antond-3]

My issue is resolved now. Thank you!

[antond-3]

Hi Shane, one more thing I see...

What if event has an StartDate and an EndDate .. We just passed the StartDate but the EndDate is in December. I have to add a second filter but what I tried It doesn't work.

hidden link

So thereis one event starting on 30 October and ends on 30 December. But I can't see this event.