Query Event List from Database

[Victoria]

Is there a SQL query I can run to generate a list of the events and their start end times from the database (to put in a spreadsheet)?

It would be easy if it werent for the meta key/value pairs in the wp_postmeta table :/

I need a list combining post_title from wp_post along with the _EventStartDate and _EventEndDate meta values from wp_postmeta

Thanks!

[Victoria]

And the crowd goes silent……?

[Gustavo Bordoni]

Hi Raymond,

Sorry for the delay on my answer.

Yes it’s possible but it’s not an easy task to be done with SQL. I would say that your best bet is to create a Page with PHP and WP_Query with the CSV format (text) and save it, then you would be able to open on a Spreadsheet like Excel.

It’s not as fast as doing it from the database but it requires less knowledge.

This might be an example that could help you: https://gist.github.com/robinnorth/5466824

And you also can use <b>get_post_meta()</b> to grab the <b>_EventStartDate</b> value.

My Best Regards,

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts