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 » Sun Mar 13, 2016 10:25 pm

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: 382
Joined: Thu Apr 25, 2013 8:22 am

Re: Qualification Summary Report - Date Sorting

Post by shanec » Mon Mar 14, 2016 8:17 am

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 » Tue Mar 15, 2016 9:43 pm

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 » Mon Mar 21, 2016 9:30 pm

Do you need any more information?

shaunw
Posts: 7360
Joined: Tue Sep 19, 2006 2:22 pm

Re: Qualification Summary Report - Date Sorting

Post by shaunw » Tue Mar 22, 2016 7:12 am

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 » Wed Mar 23, 2016 3:44 pm

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 » Tue Apr 05, 2016 4:00 pm

Is there anything else we can try?

shaunw
Posts: 7360
Joined: Tue Sep 19, 2006 2:22 pm

Re: Qualification Summary Report - Date Sorting

Post by shaunw » Tue Apr 05, 2016 4:39 pm

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

Post Reply