Qualification Summary Report - Date Sorting

Topics brought up by the TimeTrex open source community.
Post Reply
Yajasi
Posts: 108
Joined: Wed Oct 17, 2012 4:48 pm

Qualification Summary Report - Date Sorting

Post by Yajasi »

We are trying to sort the Qualification Summary report by [Skill Expiry Date]. We've opened the report and added the field [Skill Expiry Date] to the top of the [Sort By] selection. The report is being sorted by this field, but it is not sorted correctly.

The report is sorting the field by alpha-numeric rules instead of by date sorting rules. So Feb 1, 2019 is coming before Jan 1, 2017. How do we correct this?

We are using version 9.0.4 on Ubuntu 14.04 with a PostgreSQL database.
shanec
Posts: 417
Joined: Thu Apr 25, 2013 8:22 am

Re: Qualification Summary Report - Date Sorting

Post by shanec »

In order for us to assist you please post a copy of the report if possible.
Yajasi
Posts: 108
Joined: Wed Oct 17, 2012 4:48 pm

Re: Qualification Summary Report - Date Sorting

Post by Yajasi »

In order for us to assist you please post a copy of the report if possible.
The Criteria:
TTcriteria.png
The Result NOT sorted by date:
TTsort.png
Yajasi
Posts: 108
Joined: Wed Oct 17, 2012 4:48 pm

Re: Qualification Summary Report - Date Sorting

Post by Yajasi »

Do you need any more information?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Qualification Summary Report - Date Sorting

Post by shaunw »

Please upgrade to the latest version of TimeTrex and try it again.
Yajasi
Posts: 108
Joined: Wed Oct 17, 2012 4:48 pm

Re: Qualification Summary Report - Date Sorting

Post by Yajasi »

We just upgraded to 9.0.9. No change. The report is still sorting incorrectly.
Yajasi
Posts: 108
Joined: Wed Oct 17, 2012 4:48 pm

Re: Qualification Summary Report - Date Sorting

Post by Yajasi »

Is there anything else we can try?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Qualification Summary Report - Date Sorting

Post by shaunw »

This issue will be resolved in the next version of TimeTrex, due out shortly.
Post Reply