Sorting of history sub panel?

[wjohnson]

The history subpanel has a column for Date Modified which actually lists the Date Sent of an email and not the Date Modified. We noticed because our users are archiving a lot of old emails into the system and now the sort order does not reflect the dates listed in the Date Modified column of the subpanel.

Is this a bug or is this the design as intended?

I think I'm going to try to run a query on the email table which will update the date modified to the date sent to get around this sorting issue.

[wjohnson]

Nobody has noticed this?

[brendanwalsh]

Just bumping this up - we are facing the same issue. The emails are sorting correctly but the date shown is incorrect. Any solutions?

Brendan

[wjohnson]

http://www.sugarcrm.com/wiki/index.p...Archived_Email

I now just run the following query on the first of every month:

UPDATE `emails` SET `date_modified` = CONCAT(`date_start`, ' ', `time_start`)