Support

Home Forums Event Espresso Premium Column Sorting Problems

Column Sorting Problems

Posted: June 30, 2014 at 4:05 pm

Viewing 5 reply threads


Tony O’Keefe

June 30, 2014 at 4:05 pm

I have two column sorting issues on my EE3 admin pages.

1. The event date columns only sort correctly if I force the date format to Y/m/d. For user convenience I would like the global format to be l, F jS, Y but when I set this format in WP/General Setting this the column will not sort in date order.

2. The Payment Status icon columns in the admin pages generated by both event_list_attendees.php and event_list.php are set to sortable however the results are inconsistent. I am certainly not getting all Completed, Pending or Cancelled icons grouped together for example.

Any ideas?

Thanks,

Tony

———————————
Event Espresso version 3.1.36.5.P
WordPress version WP 3.9.1
———————————


Tony O’Keefe

June 30, 2014 at 4:56 pm

Update to this post.

1. Found this page https://eventespresso.com/wiki/supported-date-formats/ so I’ve learned that some date formats are not supported. That’s fine.

2. The Payment Status column only appears in event_list_attendees.php. My bad.


Dean

July 1, 2014 at 2:18 am

Hi Tony,

Do you need assistance with anything else?


Tony O’Keefe

July 1, 2014 at 3:11 am

Hi Dean,

Yes I still do need some assistance with this topic.

I’ve sorted the date issue but I am still not getting correct sorting of the Payment Status columns on the event_list_attendees page.

I have tinkered with the status settings a bit so it might help me to know which field the Payment Status sorts on.


Dean

July 1, 2014 at 4:33 am

Hi,

I think the issue here is that the jQuery doesn’t know how to sort the column because the column only contains images.

I think the following edit to /wp-content/plugins/event-espresso/includes/admin-reports/event_list_attendees.php might fix it (line 273)

<p style="padding-left:17px"><span style="display:none;"><?php echo $payment_status ?></span><?php echo event_espresso_paid_status_icon($payment_status) ?></p>

All this does is add the status as text, which allows the jQuery to then sort it.

Let me know if that works for you. If so, then I’ll make a request to add it (or something similar) into core as updates will over write that change.


Tony O’Keefe

July 5, 2014 at 6:27 am

Brilliant!

That works like a charm.

Thanks again Dean.

Viewing 5 reply threads

The support post ‘Column Sorting Problems’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso