As a CIF Administrator, I want to filter milestones by status (late, complete...) on the projects page, so that I can identify projects which need work

[pbastia]

Description:

Ideally, a drop-down filter similar to project status, but for the 'lateness' status

Acceptance Criteria:

Given I am a CIF admin
When I am on the page with the projects table
Then I see a filter for the "Milestone Due" column
and when I filter by milestone (late, completed, etc.) status, only the projects with the chosen status appear in the table

Development Checklist:

• see the project status filter for a (simplified) example
• add a filter for milestone status to the graphql query
• This likely needs a new custom filter. I don't think we can use the SearchableDropdownFilter here because it relies on the item in the dropdown mapping to values in the the database. The statuses of {Late, Completed, On Track} are synthetically applied on the front-end based on temporal data returned by the query. "Late" does not map to a database value, it applies to a range of time where the dueDate is before now() and where submittedDate is null.
• We probably need a computed column too.
• Meets the DOD

Definition of Ready (Note: If any of these points are not applicable, mark N/A)

• User story is included
• User role and type are identified
• Acceptance criteria are included
• Wireframes are included (if required)
• Design / Solution is accepted by Product Owner
• Dependencies are identified (technical, business, regulatory/policy)
• Story has been estimated (under 13 pts)

·Definition of Done (Note: If any of these points are not applicable, mark N/A)

• Acceptance criteria are tested by the CI pipeline
• UI meets accessibility requirements
• Configuration changes are documented, documentation and designs are updated
• Passes code peer-review
• Passes QA of Acceptance Criteria with verification in Dev and Test
• Ticket is ready to be merged to main branch
• Can be demoed in Sprint Review
• Bugs or future work cards are identified and created
• Reviewed and approved by Product Owner

Notes:

[BCerki]

Hey team! Please add your planning poker estimate with Zenhub @dleard @gurjmatharu @JoshLarouche @sam-warren @Sepehr-Sobhani

[dleard]

This likely needs a new custom filter. I don't think we can use the SearchableDropdownFilter here because it relies on the item in the dropdown mapping to values in the the database. The statuses of {Late, Completed, On Track} are synthetically applied on the front-end based on temporal data returned by the query. "Late" does not map to a database value, it applies to a range of time where the dueDate is before now() and where submittedDate is null.

[Sepehr-Sobhani]

I second what Dylan said. We probably need a computed column too.

[patriciarussellCAS]

Initial testing of the filter didn't work properly but when I navigated away and came back it did. @BCerki @Sepehr-Sobhani are you able to have a look?

[patriciarussellCAS]

Working now :)