Make upcoming milestone work across projects
Merged
requested to merge 17227-upcoming-milestone-is-confusing-when-projects-have-different-milestones into master
Before: we took the next milestone due across all projects in the search and found issues whose milestone title matched that one. Problems:
- The milestone could be closed.
- Different projects have milestones with different schedules.
- Different projects have milestones with different titles.
- Different projects can have milestones with different schedules, but the same title. That means we could show issues from a past milestone, or one that's far in the future.
After: gather the ID of the next milestone on each project we're looking at, and find issues with those milestone IDs. Problems:
- For a lot of projects, this can return a lot of IDs.
- The SQL query has to be different between Postgres and MySQL, because MySQL is much more lenient with HAVING: as well as the columns appearing in GROUP BY or in aggregate clauses, MySQL allows them to appear in the SELECT list (un-aggregated).
Closes #17227 (closed).
Merge request reports
Activity
Please register or sign in to reply