Howdy All!
This is a bit of a complex one - so thanks in advance if you take the time to read through this -
Our installation has events, which have 1 to many "dates" (they shouldn't be published if no dates are present - so these should be irrelevant here) so our list that we are outputting should have the following (ordered as we wish to have it ordered):
- Course 1
- Course 2
- 15 July 2016
- 15 August 2016
- 15 September 2016
- 5 July 2017
- Course 3
Each occurance of a date is stored as an instance of the group x (each date has several fields like date, ID and some Meta info - mostly to be passed to our booking system) and each Course is an Article (Content type: event - a number of fields, not relevant to the sorting though)
Currently we rely on Manual ordering - which for 35 events with a ~80 sittings between them isn't very managable - we are looking to set a list & search type up that will order the Courses by the first (soonest/next) date of an event - which is where we've ran into a snag...
How would we set up a list & search type to be ordred by the lowest timestamp stored in the introtext?
Thanks in advance for any help! :)