search

GhostManager / Ghostwriter

The SpecterOps project management and reporting engine
https://ghostwriter.wiki
BSD 3-Clause "New" or "Revised" License
1.3k stars 178 forks source link

Sorting Projects by Execution Window incorrect #229

Open er4z0r opened 2 years ago

er4z0r commented 2 years ago

Describe the bug The list of projects (/rolodex/projects/) does not correctly sort projects by execution window.

To Reproduce Steps to reproduce the behavior (assuming you have multiple projects with start dates in different years):

  1. Go to /rolodex/projects/
  2. Select All Projects
  3. Click Filter
  4. Click on the little triangle in the Execution Window column header

Expected Behavior Projects should be sorted consistently based on the date of the first day of the project. Irrespective of the chosen date format, the projects should be sorted based on year,month and day in that order.

Example:

We are in July 2022 now, so with the following projects

sort order for most recent to least recent should be:

Screenshots project-sorting-censored

As you can see the start dates are all over the place 2021 before 2022 , 2020 before 2021 before 2022 again.

Server Specs:

chrismaddalena commented 2 years ago

Thanks for bringing this into an issue, @er4z0r. The screenshot helps a lot. I'm now wondering if the jQuery TableSorter has an issue with the German abbreviations. With all English month abbreviations, the sorting looks good on my end. I need to do some testing with other locales.

It might be time to look for a better solution than TableSorter.

github-actions[bot] commented 2 months ago

This issue has been labeled as stale because it has been open for 30 days with no activity.

chrismaddalena commented 1 month ago

For better tracking, I'm lumping the issues with non-English dates under this issue. This is includes #193 and #282. We resolves #193, but these issues are all related to the date parsing tripping over non-English month names or abbreviations (e.g., Dec vs. Déc).

github-actions[bot] commented 4 weeks ago

This issue has been labeled as stale because it has been open for 30 days with no activity.