Support

January 22, 2014 at 5:31 pm

The orderby attribute in the shortcode goes directly into the sql query as an orderby clause. Since the meta key – value pairs are stored as a serialized array in the database in a single sql field, sql cannot use a meta value in the orderby clause. You would need to customize the function event_espresso_get_event_details in the event_list.php template file. Add a new order_by_meta attribute. Then after the events are fetched from the DB (line 185) run a foreach to go through each event, unserialize it’s event meta, grab the value from the key that is in your new order_by_meta attribute, and use that value as the key to build a new array of events. Replace the old array of events that came from the DB with your new array of events, and when the rest of the code goes to loop over the events, it should do so in the new order.