37 Posts
austenn01
8 years ago
2
Topic

Hello,

I have setup a List and Search type 'blog list'. This is showing 'events' that have been added.

I added a calendar filed called 'Event Start Date" (event_start_date). I need to filter the blog list on the frontend of the website via the event start date.

To set this up I have:

1) Created a List and Type Search called 'Events Blog. The list is showing on the frontend, but its not being ordered correctly.

2) Under the 'Ordering' tab in my Events blog, I have added my 'Event Start Date' field and set direction to 'ascending'.

3) I created a menu item, called it Events Blog, then made it a 'search type list' and choose my 'Events Blog' List that I created in no.2 above.

4) In the menu item in no.3, under the tab 'options', under the setting 'default order' i chose COM_CCK_CUSTOM_sl and then a text box appears to the right...and in this text box I entered   "Event Start Date"

Can anyone tell me what has gone wrong here? I can send logins if required. From the looks of the display on the frontend, it looks like the list is being filtered alphabetically by Event Title.

Any help would be greatly appreciated.

Thanks,

I have added some screen shots:

Frontend list view screenie:

http://www.inspire.im/seblod-frontend-list-view.jpg

Menu item screenie:

http://www.inspire.im/seblod-menu-item.jpg

List and Search type screenie:

http://www.inspire.im/seblod-list-search-type-tab-search-form.jpg

http://www.inspire.im/seblod-list-search-type-tab-ordering.jpg

http://www.inspire.im/seblod-list-search-type-tab-list.jpg

http://www.inspire.im/seblod-list-search-type-tab-item.jpg


Get a VIP membership
37 Posts
austenn01
8 years ago
0
Level 1

Hello,

I have a little more info.

To test whether the filtering was working at all, I added the 'search ordering' field to the search form tab, and then I added filter options of 'event_start_date' asc AND 'event_start_date' desc.

On the frontend when i choose either ASC or DESC the list order doesnt change at all.

So it seems that the filtering isnt working at all.

Can anyone tell me whats going wrong here?

37 Posts
austenn01
8 years ago
0
Level 1

WOW...I have spent hours testing this stuff!!!

SOOOOO.........I was wondering if there was a bug with filtering by datetime...so I decided to do a filter by a text field. In the menu item, i set 'options tab' > Default order > use global, and IT WORKED to sort via the text field.

I then went and changed the sort field in List and Search back to my 'Event Start Date' datetime field, saved it, reloaded the frontend, and IT WORKED!!!

Very strange. It seems by changing the filter field, it reset things to work. I'll see how things go.

I DO BELIEVE I HAVE FOUND A BUG HOWEVER.

In the MENU ITEM, when you go to the 'options' tab > Default order > COM_CCK_CUSTOM ....it doesnt matter what seblod field I add here, it simply wont filter by it. Whether its text, calendar, etc..it wont work. This has not worked for me in 3.5.1 and the new 3.6.0.

EDIT FYI

I did do one more thing that might be the reason why this started working to filter by the Event Start Date. 

1) Some days ago I upgraded to 3.6.0 (but filtering by event start date didnt work after the update)

2) When i was testing filtering by a text field, I set the text filtering field to be my 'Event City' text field.

3) To make sure I could visually see if the filtering order was correct in the frontend, i went into every Event i had created, and I changed the 'Event City' and then saved the Event (article)

HYPOTHESIS 1 - as per the first idea listed above

HYPOTHESIS 2 - there was a bug in version 3.5.1 for filtering by datetime calendar field, and thus when I saved the datetime it didnt save correctly. Thus, after I upgraded to 3.6.0 and then re-saved every Event (article), it saved the datetime correctly, and thus the filtering of datetime calendar field is working correctly.

Can anyone confirm any of this?

Get a VIP membership