How are Calendar objects sorted?

tford · Post by **tford** » Tue Mar 20, 2007 3:16 am

The User Guide does not mention how Calendar Form of Query Results are sorted. Sort order is also not an option on the screen where you define the Calendar query.

How are they sorted?

Thanks,
Tom

aware_support · Post by **aware_support** » Tue Mar 20, 2007 10:02 am

They are sorted by their dates.

tford · Post by **tford** » Tue Mar 20, 2007 10:43 am

Within 1 date how are they sorted?

If there are 2 items have the same time, how will they be sorted?

Thanks,
Tom

aware_support · Post by **aware_support** » Tue Mar 20, 2007 11:42 am

By definition they will occupy the same place in the calendar. Calendar view ONLY sorts by date and time. It doesn't make sense to sort by anything else. If you want to sort by something else use different view.

tford · Post by **tford** » Thu Mar 22, 2007 10:06 pm

Thanks for your note. I can undertand why you thought that it "doesn't make sense to sort by anything else" for 'normal' calendar items.

What I failed to say was that I was working on my 2 uses of calendar functions that 100% use All Day Events. (see my post at http://www.awareim.com/forum/viewtopic.php?t=1428 ) With All Day Events, sorting by time really has no meaning. If you have a few different All Day Events on 1 day, they are sorting by SOMETHING.

If you look at Common Controls Scheduler Sample 901 (http://www.common-controls.com/cc2/sche ... heduler.do) you will notice that if you edit an All Day Event (http://www.common-controls.com/cc2/sche ... 2611838684), the Starts At and End At only have date info -- all times are 00:00:00 for All Day Events. Even though you might see Start and End times when you first create an Add Day Event, the Common Controls example replaces them with 00:00:00 times.

In my 2 Aware IM calendars that use 100% All Day Events, I am using a rule to set the All Day Event attribute to "yes" (and not displaying it on the Form). I am also entering the dates in mm/dd/yy formats (no times).

Through experimenting, I have found that multiple All Day Events on 1 day seem to sort by the order they were entered.

I don't have any remaining questions. I just thought I'd share my learnings with anyone that might be interested.

Tom