Support

November 7, 2023 at 7:59 pm

Did try to recreat the issue from our end, but everything seems fine. https://monosnap.com/file/5LVlwsAVocJXl6lZEwHLeTtSBvmJni

Can you tell me more information about that page? how about you shoot a video using loom. There could be some information we can see there that might be helpful in our troubleshooting.

https://www.loom.com/

thanks

November 10, 2023 at 5:00 pm

I think it works fine. the first time you click it sort by DESC, it sorted. The second time you click it, it brings back to default sorting.

Can you tell us what you expect to happen when you click the button on the 2nd time?

thanks

November 13, 2023 at 5:06 pm

Hi Fran,

That’s not a simple sort although it may seem it.

The reason your not seeing the December registration in your screenshots is the query orders_by like this:

ORDER BY Event___Datetime.DTT_EVT_start desc,Registration.REG_ID desc

We add the orderby REG_ID because the results returned from the Database query can be a little… random without it.

The code for this actually has a comment referring to it:

// because there are many registrations with the same date, define
// a secondary way to order them, otherwise MySQL seems to be a bit random
if (empty($orderby['REG_ID'])) {
    $orderby['REG_ID'] = $order;
}

But, those where conditions are filtered so you can try using a snippet on your site to see if it helps:

https://gist.github.com/Pebblo/04448f9f82f55dc90d055944893da5e1

Try adding that snippet to your xee-customizations plugin.