ChatMail order (in General)

I just noticed that ChatMail, when viewing past "delivered to me" listings, orders the CMs by delivery time. Within that, earlier sent times are actually further UP the list, so it looks like someone who sent something sooner than later actually sent it later than sooner. If that makes sense.

Shouldn't CMs order by delivery time, and if delivery time is the same, within that order by sent time, descending (into the past). Seems more logical, but I'm not sure what other folks have grown used to...

You mean ordering by sent time, right?

(if not, why not?)

I think ordering by delivery time is fine, but when a bunch come in with same delivery time stamp, they should then be ordered by sent time within that group.

He means it's backwards if you receive more than one at the same time.. I think.

Correct. In SQL terms, currently the query is akin to:

SELECT * FROM MyChatMail ORDER BY [Delivery Date] DESC

when this would work better, perhaps:

SELECT * FROM MyChatMail ORDER BY [Delivery Date] DESC, [Sent Date] DESC

(or something of that nature...I don't know the actual existing queries, table names, or fiend names, obviously.)

Or couldn't we just sort by sent date and ignore the delivery date?

Yeah, duh, I guess that would work even better! It's not like delivery could be before someone sent it, so that order should work just as well... Unless there are time lords about...

... that's sorta what I meant ... :p

Yeah, I finally figured that out...as usual, most other folks are a full step ahead of me. *smile*