Skip to content

Refactored Issue Analytics counts query builder

Rudy Crespo requested to merge 424268-refactor-issue-analytics-query-builder into master

What does this MR do and why?

Upon attempting to add newly supported filters to Enhanced Issue Analytics, the chart refused to load with the default 12 month date range due to a Query too large error (for more details, see #424268 (comment 1619156321)). As the first of two MRs to address #424268 (closed), this MR tries to solve that issue by refactoring the query builder used by the chart to make it more dynamic then splitting the queries for Issues opened and Issues created into two separate queries.

Task Status
Refactor Issue Analytics counts query builder ⬅
Add missing filters to Enhanced Issue Analytics ( !135160 (merged)) workflowin review

Known Issues

  • iteration filter is currently not working; to be fixed in #419743 (closed)
  • Wildcard values for milestone and assignee filters currently not working; to be fixed in #428478 (closed)

Screenshots or screen recordings

No visual changes.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

  1. Make sure you have a GitLab Ultimate license
  2. Feature.enable(:issues_completed_analytics_feature_flag)
  3. Go to a group/project with issues: http://{LOCAL_INSTANCE}/groups/{GROUP_PATH}/-/issues_analytics or http://{LOCAL_INSTANCE}/{GROUP_PATH}/{PROJECT_PATH}/-/analytics/issues_analytics
  4. Verify that the chart loads and is working correctly.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #424268 (closed)

Edited by Rudy Crespo

Merge request reports