Filter epic work items by unified award emoji association
What does this MR do and why?
Follow-up of !155316 (merged) which unified award emoji association with epic work item and legacy epic. Introduces filtering for the unified association
related to #443543 (closed)
SQL queries
From epics side
Queries are using gitlab-org group id and an existing user id. These were extracted from the performance bar when filtering epics by emoji on the UI.
- By emoji name https://postgres.ai/console/gitlab/gitlab-production-main/sessions/29542/commands/91741
- Negated emoji name https://postgres.ai/console/gitlab/gitlab-production-main/sessions/29542/commands/91746
From work item side
There is still no way to filter epic work items using the UI, so I extracted these directly from logs generated by WorkItemsFinder
on specs.
- By emoji name https://postgres.ai/console/gitlab/gitlab-production-main/sessions/29542/commands/91747
- By negated emoji name https://postgres.ai/console/gitlab/gitlab-production-main/sessions/29542/commands/91749
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Screenshots or screen recordings
No change in the behavior.
How to set up and validate locally
- Make sure to be on ultimate license
- Enable
:epic_and_work_item_associations_unification
feature flag - Go to any Group and create a new epic A and add
🚀 emoji - Visit its work item counterpart by changing
epics
bywork_items
in the url - Add
😄 to the work item - Go to epics list page and filter by
😄 emoji present on the work item
Epic A should appear in the list, same should happen from work item side, but filtering by emoji is still not implemented on group work items list.