Sorting calendar events search page results by start date

coolwebs · 2016-02-02 00:49:56 UTC

Perhaps I'm missing something here folks - I really hope I am.

But I am working with a Calendar Events Search Page and I am trying to sort the results page so that they are listed in order by the date of the event. I cannot see that sorting option on the 'asset sorting' screen. I see options to sort by name, date created, date last updated, last published - but no native feature to sort by the actual start time of the event??

These are native options on all of the event asset types (single, recurring, multi-date). Ther must be an options to sort by these parameters otherwise I can't really see it's usefulness. Sure I could create extra metadata fields and have it sort by that but that's just extra work for the people who create the events.

Bart · 2016-02-02 06:26:47 UTC

On the assert sorting screen, find the Sorting by Asset Attribute Value section (see attached) and choose the event asset and enter a sort name, then pick start date as the attribute name, and then scroll down to the bottom Default Sorting section and select that sort value as the default.

Does that work? Capture.JPG (16.4 KB)

coolwebs · 2016-02-03 02:54:59 UTC

Tried what you suggested Bart and the dates are still not in any logical order (descending or ascending).

I did a search for February and the order came back was 20 Feb, 4 Feb, 16 Feb , 14 Feb.

Is there another setting I need to play with?

nnhubbard · 2016-02-03 16:33:26 UTC

Tried what you suggested Bart and the dates are still not in any logical order (descending or ascending).

I did a search for February and the order came back was 20 Feb, 4 Feb, 16 Feb , 14 Feb.

Is there another setting I need to play with?

Trust me, it works. Are you sure you set the Default Sorting to the sorting you just created?

coolwebs · 2016-02-03 22:36:16 UTC

@Nic, yeppp....

I've set the listing back to go descending and it still does not work completely. Some events seem to list in order but then they all go out again. I have a feeling that bringing in recurring and single events in the same results page is throwing this search calendar asset of.

Here are the settings attached as images.

The search calendar page is located here, try it out yourself and search for 'anzac' events happening this month and leave all the other form settings default. Check out the results page it brings up.

http://www.slq.qld.gov.au/whats-on/calendar/advanced-event-search asset-sorting-1.png (301 KB) asset-sorting-2.png (182 KB)

nnhubbard · 2016-02-03 23:05:34 UTC

@Nic, yeppp....

I've set the listing back to go descending and it still does not work completely. Some events seem to list in order but then they all go out again. I have a feeling that bringing in recurring and single events in the same results page is throwing this search calendar asset of.

Here are the settings attached as images.

The search calendar page is located here, try it out yourself and search for 'anzac' events happening this month and leave all the other form settings default. Check out the results page it brings up.

http://www.slq.qld.gov.au/whats-on/calendar/advanced-event-search

Strange. That isn't returning anything:

http://www.slq.qld.gov.au/whats-on/calendar/advanced-event-search?queries_includeall_query=anzac&category_agegroups=&queries_eventdates_fquery=none&queries_feeorfree_query_posted=1&queries_feeorfree_query=&page_calendar_events_search_273987_submit_button=Search&current_result_page=1&results_per_page=25&submitted_search_category=&mode=

coolwebs · 2016-02-04 01:24:01 UTC

Sorry @Nic. Not really following you. How did you come up with that URL? Did you manually construct the search query URL? http://www.slq.qld.gov.au/whats-on/calendar/advanced-event-search/- this page is available publicly and it does pull back search results.

nnhubbard · 2016-02-04 16:54:43 UTC

Sorry @Nic. Not really following you. How did you come up with that URL? Did you manually construct the search query URL? http://www.slq.qld.gov.au/whats-on/calendar/advanced-event-search/- this page is available publicly and it does pull back search results.

You told me to search for anzac, but there were no results found. That that URL is the search query URL that is shown in your browser when you perform a search. So, I still don't know what to search for as anzac brings back no results found.

coolwebs · 2016-02-05 00:06:59 UTC

@Nice, is this what your screen looks like? (image attached). I just did the search from my personal computer on a public wifi network (not from behind a firewall) and it worked fine with two pages of results returned.

If that does not work, try keyword like 'family', 'children', 'kids', 'indigenous' or something pretty generic you would see in a library event. Advanced event search.png (50 KB)

nnhubbard · 2016-02-05 00:32:14 UTC

Nope. I get no search results for any terms I try.

coolwebs · 2016-02-10 02:24:41 UTC

dunno, maybe because you are in the USA or something. The content on the website is really their to service Australian clients. Weird...

@Bart, can you try and give it a go? Just weird this is.

PeterM · 2016-02-10 05:30:03 UTC

Hi

I get no results either when I search for anzac (I’m Aus based).

What about your settings that relate to permissions in the search settings and for the events, could these be affecting it?

There is another search form I saw linked on your site at: http://www.slq.qld.gov.au/whats-on/calendar/search - that returns quite a few results for anzac though - these didnt seem to be sorted cronologically or by title?

Thanks

Peter

Bart · 2016-02-11 05:36:25 UTC

This is what I get (see attached).

Are you searching as a logged in user that maybe has read access to more things? Capture.JPG (75.5 KB)

coolwebs · 2016-02-23 23:28:27 UTC

I think I get it. You need to be more specific with the search parameters.

Try this:

search for: ANZAC

Audience: you can leave blank or choose general

What date/time period? - Choose 1 month

Most importantly, you must choose a date/time period. I did a search without specifying this and I got no results also.

Pono · 2016-02-25 03:30:46 UTC

Looks at though its something specific to recurring events.

The events are being sorted by the start date of the recurring event, then its just dumping the rest of event occurrences at once.

I will take a deeper look into this and get back to you, however i think this was an issue that has been solved previously.

Pono · 2016-02-25 03:58:13 UTC

What you have to do is to set up Sorting by Asset Keyword Value in the Asset Sorting section of the Calendar Events Search Page.

Create a new field with instance_start_datetime as the keyword and then move this option to the top of the sort list.

coolwebs · 2016-02-26 04:15:13 UTC

Oh yeah! That works swell.

Now you think their would be a way to group recurring events so we could like have a header saying 'Peace and Quiet' and list all the recurring events under it and also do the same for others such as 'Peace and Love'??

Be so awesome if there was some time of 'in-page' navigation to get through the instances too. Perhaps even have the recurring events hidden by default and then they slide out when you click on the heading (like using jQuery slideToggle).

Pono · 2016-02-26 04:23:38 UTC

You could do something with the Recurring Event Type Format some JS and CSS.