ChatMail order (in General)

QBsutekh137 October 1 2009 10:59 AM EDT

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...

blackshadowshade October 1 2009 11:04 AM EDT

You mean ordering by sent time, right?

blackshadowshade October 1 2009 11:04 AM EDT

(if not, why not?)

QBsutekh137 October 1 2009 12:15 PM EDT

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.

Cube October 1 2009 12:41 PM EDT

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

QBsutekh137 October 1 2009 12:48 PM EDT

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.)

Lord Bob October 1 2009 1:35 PM EDT

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

QBsutekh137 October 1 2009 1:37 PM EDT

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...

blackshadowshade October 1 2009 3:11 PM EDT

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

QBsutekh137 October 1 2009 3:35 PM EDT

Yeah, I finally figured that usual, most other folks are a full step ahead of me. *smile*
This thread is closed to new posts. However, you are welcome to reference it from a new thread; link this with the html <a href="/bboard/q-and-a-fetch-msg.tcl?msg_id=002tD9">ChatMail order</a>