Part of story #35104 Milestones below Backlog To retrieve milestones and their sub-milestones, there is already several methods to do this. But it makes several queries to database and too much overhead time. Instead we choose to craft a single query which retrieves all we need. We first retrieve the top milestone tracker of project with a pre-existing query, then the new query find all opened artifacts of this tracker. It also finds opened artifact links to the first ones with type '_is_child'. The backend then gets the result of this query and filter it by checking timeframe, title and count (limit 5). *Testing:* In a project with Backlog service enabled 1. **Normal case** Create some releases and sprints in it (more than 5). Set timeframes with different values (past, present, future) both for releases and sprints. Shuffle status (open and close) Result: Sidebar should display at most 5 items, all should be opened and in current timeframe. Note: An opened release can be displayed even if all its sprints are closed 2. **Limit cases** - Link a bug to a current opened release with type '_is_child' - Add a third planning level (under sprints) with artifacts Result: None of added artifacts should be displayed Change-Id: I19a19aa7c537dcf0d6afa36b136a415b927f829d

+1626 −250

Author

Kevin Traini (ktraini) 2023-12-05 11:09

Committer

Kevin Traini (ktraini) 2023-12-13 11:19

Hash 7c9278469714efce056ee358518f27792a37114e

Parent fb0ba9ef76a7ff0d3a9ef065f60712ca302703bf

Reference git #tuleap/stable/7c9278469714efce056ee358518f27792a37114e