You could build a query to do a JOIN on the _esp_datetime. table to get the last DTT_EVT_end for that event, then if it’s past, set it to skip. The only trouble I’m seeing with this is how to make this query efficient so it doesn’t really slow down the site when that query runs.
The way the code works in the Jetpack site maps script is it checks for posts with the “Published” post status. So if an event is set to be in trash (or any other post status that’s not “Published”) it will be removed from the site map the next time the site map is generated.
Viewing 5 reply threads
The support post ‘Sitemaps (again)’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.
Support forum for Event Espresso 3 and Event Espresso 4.