History panel won't sort by Due Date for Cases #3169

New issue

Open

opened 2026-02-20 16:01:47 -05:00 by deekerman · 3 comments

deekerman commented

2026-02-20 16:01:47 -05:00

Owner

Originally created by @TheLimey on GitHub (Jun 15, 2018).

Expected Behavior

I expect the Case's historic items to sort chronologically in ascending/descending order on alternate clicks of the Due Date field header.

Actual Behavior

It doesn't sort. It also does not reverse the order every click of the header.
NOTE: Sometimes it appears to be sorting by one of the other date fields, but I this is a coincidence, because that doesn't always happen. I have attached a screenshot showing this.

Possible Fix

Add the sort to the SQL?

Steps to Reproduce

Create a case
Add 4 or 5 meetings and held calls (not in chronological order for a true test) to the case, with the same person as the contact for each.
View the case
Open the the History sub-panel
Click the Due Date column title.
Clicking that column title a few more times, the sorting doesn't change.
View the contact that the calls/meetings are with and repeat the above steps. It works here.

Context

I want to see the order my historic events happened. (Although even this isn't actually correct because it uses the end dates for meetings, not the start dates, so calls that happened during meetings appear before the meeting not after, but it's close enough for most cases.)

Your Environment

I had the issue in 7.10.4, and just upgraded to 7.10.6 (Sugar Version 6.5.25 (Build 344)), and it's still happening. I also tried your demo and got the same outcome (using Vivaldi).

My SuiteCRM is running on a fresh LAMP stack on Ubuntu server 18.04 64bit.

I get the same results with each of the following browsers running on Xubuntu 18.04 64bit:

Vivaldi 1.15.1147.42 (Stable channel) (64-bit)
Firefox 60.0.1 (64bit)
Chrome Version 67.0.3396.79 (Official Build) (64-bit)

Originally created by @TheLimey on GitHub (Jun 15, 2018). #### Expected Behavior I expect the Case's historic items to sort chronologically in ascending/descending order on alternate clicks of the Due Date field header. #### Actual Behavior It doesn't sort. It also does **not** reverse the order every click of the header. NOTE: Sometimes it appears to be sorting by one of the other date fields, but I this is a coincidence, because that doesn't always happen. I have attached a screenshot showing this. ![suitecrm case history due date not sorted](https://user-images.githubusercontent.com/7304320/41474052-d67710d2-706f-11e8-92b3-314d812785dc.png) #### Possible Fix Add the sort to the SQL? #### Steps to Reproduce 1) Create a case 2) Add 4 or 5 meetings and held calls (not in chronological order for a true test) to the case, with the same person as the contact for each. 3) View the case 4) Open the the History sub-panel 5) Click the Due Date column title. 6) Clicking that column title a few more times, the sorting doesn't change. 7) View the contact that the calls/meetings are with and repeat the above steps. It works here. #### Context I want to see the order my historic events happened. (Although even this isn't actually correct because it uses the end dates for meetings, not the start dates, so calls that happened during meetings appear before the meeting not after, but it's close enough for most cases.) #### Your Environment I had the issue in 7.10.4, and just upgraded to 7.10.6 (Sugar Version 6.5.25 (Build 344)), and it's still happening. I also tried your demo and got the same outcome (using Vivaldi). My SuiteCRM is running on a fresh LAMP stack on Ubuntu server 18.04 64bit. I get the same results with each of the following browsers running on Xubuntu 18.04 64bit: - Vivaldi 1.15.1147.42 (Stable channel) (64-bit) - Firefox 60.0.1 (64bit) - Chrome Version 67.0.3396.79 (Official Build) (64-bit)