How can I order Events so the page displays Upcoming events first (startdate > now) and Ongoing events (startdate < now and enddate > now) after that?

I see the models/events.php -- should I update the query there? and how?

thanks

Hi Vlad,

WEll, this hack is bit tricky, because you need to move the ongoing toe the last, and move the upcoming to the top.

this is not the smart solution but you can try it.. In models/events.php, find this code :

case 'startdate':
                if (empty($orderBy))
                    $orderBy = ' ORDER BY a.startdate ASC';
                break;
            default:
                $orderBy = ' ORDER BY a.' . $db->quoteName('startdate') . ' ASC';
                break;

case 'startdate':
                if (empty($orderBy))
                    $orderBy = ' ORDER BY a.startdate DESC';
                break;
            default:
                $orderBy = ' ORDER BY a.' . $db->quoteName('startdate') . ' DESC';
                break;

That solution is not right -- it shows events in reverse order (basically moving events with further/latest date in the first place). any other recommendations?

Hi Vlad,

Like I said before, this is really tricky, because you need to manipulate the array result.. we cant help you too much for this one.

thank you