Order posts of a custom post type by the event date using FT Calendar Plugin

Question

I am using the FT Calendar Plugin. My question is how can I order posts of a custom post type by the event calendar date?

So for instance I have a CPT named "Events" and for each event post a calendar date is added. Problem is that the page that lists the event posts doesn't order the posts by event calendar date, but the standard wordpress ordering. Is there a way to order them in my query instead by the FT Calendar event date?

The data for the event dates are stored in their own table "rfw_ftcalendar_events".

id | calendar_id | post_parent | start_datetime      | end_datetime

1  | 2           | 210         | 2013-04-05 15:00:00 | 2013-04-05 16:00:00

Answer 1

My guess is that the calendar date is some sort of meta field for the custom post type. I'd find that out and add that as a variable for my query.

You might be able to use something like this

<?php $loop = new WP_Query( array( 'post_type' => 'events', 'meta_key'=>'start_datetime',  'orderby' => 'meta_value', 'order' => ASC) ); while ( $loop->have_posts() ) : $loop->the_post(); ?>