Support

Home Forums Event Espresso Premium Ascending order of events by date appears skewed in Sidebar Widget.

Ascending order of events by date appears skewed in Sidebar Widget.

Posted: April 25, 2019 at 2:23 am


Atma

April 25, 2019 at 2:23 am

Dear,

I added a new event (Handarbeitsabend 1 (Die männliche Intimmassage) – ENTWURF). (See SCREENSHOT 51, the event in the middle.

You will notice that there are three date times. May 10, September 6 and December 6.

In the regular Event listing with the shortcode: [ESPRESSO_EVENTS category_slug=seminar] the correct listing by date seems to happen correctly. (SEE SCREENSHOT 51). The event in question shows in the timeline according to the first date-time (may 10).

However in the front page sidebar widget the order how the events are shown is off. (SCREENSHOT 53) In this case the Event shows the Date of May 10, however in the order it shows up as the last event of 2019, before the 2020 events.

Here are the settings of the widget (SCREENSHOT 54).

I hope you can help me find a solution for showing this in correct order also in the widget. Thank you for your help.

SCREENSHOT 51: https://www.dropbox.com/s/0t52fc7z6y9fc96/SCREENSHOT%2051.png?dl=0
SCREENSHOT 52:
https://www.dropbox.com/s/5fqvx6gbnoa2txt/SCREENSHOT%2052.png?dl=0
SCREENSHOT 53:
https://www.dropbox.com/s/q6i1fkq03swrnlc/SCREENSHOT%2053.png?dl=0
SCREENSHOT 54:
https://www.dropbox.com/s/61dr0r5xeqcohuj/SCREENSHOT%2054.png?dl=0


Atma

April 25, 2019 at 2:31 am

Ah and by the way on the backend the date times and tickets of the event look like this (SCREENSHOT 55)

SCREENSHOT 55:
https://www.dropbox.com/s/hcg7iz42prg96nw/SCREENSHOT%2055.png?dl=0


Tony

  • Support Staff

April 25, 2019 at 4:46 am

Hi there,

How do you want it to display on the widget?

Currently, you have the widget set to only display a single date and no date range – https://monosnap.com/file/6Jc3n4K5Nx9TaQWUQYE3CxIWNdJGyT

You have 3 datetimes on the event, but you’ve set the widget up so that it will only display 1, the widget orders the datetimes for each event based on Datetime.DTT_EVT_start so it’s the datetime start date, meaning you as it stands it correctly displays the May 10 datetime.

If you want to list all of the datetimes, increate the number of dates to display to at least 3, or enable the date range setting.


Atma

April 25, 2019 at 5:32 am

Yes, I want it to only show the first time, as it does.

The issue I am having is a different one.

The problem is that where the event is shown doesn’t fit into the timeline.
All other events show in ascending order regarding their date, which means the ones that have an earlier starting date show before and the ones with a later starting date show after.

It is displaying correctly when using this: [ESPRESSO_EVENTS category_slug=seminar]

However in the widget it shows all 2019 events, then at the end it shows the one in question. then it shows the 2020 events. So when the event is listed is showing out of order in terms of date and time.


Atma

April 26, 2019 at 2:27 am

Maybe this wasn’t clear. The event ( 1 (Die männliche Intimmassage) – ENTWURF) has three date times. May 10, September 6 and December 6.

Ideally, when showing in the widget, it should show in the order of progression of dates.
Since the first of them is may 10, it should show after the april events and before the June events.

However this isn’t the case, at least not in the widget (it shows correctly when using this : [ESPRESSO_EVENTS category_slug=seminar] ).

However in the widget it shows in december, after the last december event and before the 2020 events.

In terms of showing only one of the three date times, that’s okay, I just want it to show correctly in chronological order.

I hope i was able to explain it more clearly.
Thx for your help.


Atma

April 28, 2019 at 6:12 am

Can you help me please…


Atma

April 29, 2019 at 1:49 am

The widget is set to only display a single date and no date range – https://monosnap.com/file/6Jc3n4K5Nx9TaQWUQYE3CxIWNdJGyT

I have 3 datetimes on the event event (Handarbeitsabend 1 (Die männliche Intimmassage) – ENTWURF), but I have set the widget up so that it will only display 1 time. The widget orders the datetimes for each event based on Datetime.DTT_EVT_start so it’s the datetime start date, meaning as it stands it correctly displays the May 10 datetime.

This being said, in the front page sidebar widget the chronological order of how the events display is incorrect. (SCREENSHOT 53) As the Event shows the Date of May 10, it should show in between the April and June Events. However it is being displayed between the last December 2019 and the first January 2020 event.

This must have something to do with the fact that there are several date times existing inside this event (even though only the may 10 date time is displayed), as all the other events with only one date time are displayed within the correct chronological order.

This happens only in the widget, in the main Event page [ESPRESSO_EVENTS category_slug=seminar] it actually displays in correct chronological order. as shown in SCREENSHOT 51.

SCREENSHOT 51
https://www.dropbox.com/s/0t52fc7z6y9fc96/SCREENSHOT%2051.png?dl=0

SCREENSHOT 53:
https://www.dropbox.com/s/q6i1fkq03swrnlc/SCREENSHOT%2053.png?dl=0


Atma

April 29, 2019 at 1:53 am

I am writing again to explain my question better, since you haven’t answered my question in your last response.

Yes,the widget is set to only display a single date and no date range – https://monosnap.com/file/6Jc3n4K5Nx9TaQWUQYE3CxIWNdJGyT

I have 3 datetimes on the event event (Handarbeitsabend 1 (Die männliche Intimmassage) – ENTWURF). The widget is set up so that it will only display 1 time. The widget orders the datetimes for each event based on Datetime.DTT_EVT_start so it’s the datetime start date, meaning as it stands it correctly displays the May 10 datetime.

This being said, in the front page sidebar widget the chronological order of how the events display is incorrect. (SCREENSHOT 53) As the Event shows the Date of May 10, it should show in between the April and June Events. However it is being displayed between the last December 2019 and the first January 2020 event.

This must have something to do with the fact that there are several date times existing inside this event (even though only the may 10 date time is displayed), as all the other events with only one date time are displayed within the correct chronological order.

This happens only in the widget, in the main Event page [ESPRESSO_EVENTS category_slug=seminar] it actually displays in correct chronological order. as shown in SCREENSHOT 51.

SCREENSHOT 51
https://www.dropbox.com/s/0t52fc7z6y9fc96/SCREENSHOT%2051.png?dl=0

SCREENSHOT 53:
https://www.dropbox.com/s/q6i1fkq03swrnlc/SCREENSHOT%2053.png?dl=0

Please help resolving the issue.


Tony

  • Support Staff

April 29, 2019 at 2:30 pm

Hi there,

My apologies for the delay, this took a little tracking down and as we work through threads based on the last reply date your above replies essentially kept bumping your thread to the back of the queue for a reply.

So it looks like an issue with events that have multiple datetimes when pulled from the database and grouped by the event id, in short, it looks like the DateTime with the lowest ID that is assigned to the event is used during the query. To add to the mix you can also get different responses for that specific query depending on the MySQL version you are running… just for good measure.

With the datetimes shown in screenshot 55:

https://www.dropbox.com/s/hcg7iz42prg96nw/SCREENSHOT%2055.png?dl=0

Click the icon and view the datetime ID’s for each of those.

I’m guessing the datetime with the ‘lowest’ ID number is ‘06.12.2019’, is that correct?

If so to fix it you’ll need to alter those datetimes (and then assign the correct tickets to them) so that the datetime with the lowest ID has the ‘first’ instance of the event, meaning not only do the event starts dates go up in order, but so do the datetime ID’s.

Make sense?

If you are unsure, please click the cog icon on each of the datetimes and post a screenshot of each one, I’ll walk through what you need to change.

Weare going to investigate this further but the above should mean your events display correctly for the time being.


Atma

May 1, 2019 at 8:45 am

no problem, thank you for answering.

Yes, this works!
I essentially assigned new datetimes starting with the earliest event. I deleted the old ones, because I assumed I am not able to change the date time ID in an existing date time.

Thank you for bringing the solution!

The support post ‘Ascending order of events by date appears skewed in Sidebar Widget.’ 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