[Resolved] Query filter for showing events for the next 30 days

[Author]

Posts

[jozsefG]

Hello

I need help with this project again. I create Events with the EventOn plugin, and I show them on a toolset map as markers. In this ticket I'd got help how to convert the non-types date field and show the date as marker info: https://toolset.com/forums/topic/convert-non-types-date-field-timestamp-to-date/

Now I need to limit the events to show only one month. It would be great to show 30 days of events from the actual date on but I couldn't find this option in date filters so I tried current month. But the problem is that it shows no map if I set this in the query filter of the parent view for the events. I guess this can't be this simple because the "srow" field is a timestamps.

Maybe it would be easier if I give access to the site admin because it starts to be a little too complex to explain every detail in text here...

You can look at the map on the homepage: hidden link

[Luo Yang]

Hello,

I assume the custom field "srow" is storing value in timestamp format, and field "srow" is registered to post type "Event", and you are using Views to query the "Event" posts, you are going to filter the result by field "srow" is no more than future 30 days.

If it is, it is possible within Views plugin, you just need to setup a custom field filter on field "srow", for example:
Select items with field:
srow is a UNSIGNED lower than or equal FUTURE_DAY(30)

See our document:
https://toolset.com/documentation/user-guides/date-filters/

[jozsefG]

Thank you, I tried it. Unfortunately it is not working, the map is not showing at all.

[Luo Yang]

Pleas provide a test site with the same problem, also point out the problem page URL and view URL, I need a live website to test and debug.

[jozsefG]

Soooory, I messed up something, and it is working!! Mea culpa...
Thank you Luo Yang for your help!