registrant Event sort order

  • Andrew Davis
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
11 years 2 weeks ago #60181 by Andrew Davis
registrant Event sort order was created by Andrew Davis
In the Backend, when I go to Registrants, I then select the event from the dropdown box on the top right, this list appears to be in alphabetical order.

Can i get it to display in chronological order (Based on event start date) with the newest at the top. At the moment I only have 6 Events, so it is not to hard, but within a year it is going to get very difficult to find the event in amongst all the old ones.

Cheers
Andrew

Please Log in or Create an account to join the conversation.

More
11 years 2 weeks ago #60192 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic registrant Event sort order
Hi Andrew

You can edit the code abit to get it works as you want:

1. Open the file administrator/components/com_eventbooking/view/registrants/html.php

2. Find the code below:
Code:
$query->select('id, title, event_date') ->from('#__eb_events') ->where('published=1') ->order('title');

3. Change it to
Code:
$query->select('id, title, event_date') ->from('#__eb_events') ->where('published=1') ->order('event_date DESC');

After that. it should work as expected

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc