[Reports] Add column to see the next SLA due date for a process item

• Type: Story
• Status: Closed
• Priority: Minor
• Resolution: Completed
• Affects Version/s: None
• Fix Version/s: 7.4.1 CE GA2, 7.4.13 DXP GA1, Master
• Component/s: Workflow
• Labels:
  • 7.4-ce-ga2
  • qa_test_mapped
• Epic Link: Workflow Metrics

As a process manager, I want to be able to see the next SLA due date for a process item;

Process item = process instance

Acceptance Criteria

• The table should have the following columns:
  • ID: numeric key unique to each process instance;
  • Due Date: display the due date of the SLA that is closest to expire or, in case there are SLAs overdue, display the due date for the SLA that has expired for the longest time;
    • The Due Date should be displayed in different colors, depending on the SLA status: red for overdue and green for on time (as specified on Figma mockups);

• If there are multiple SLAs for an item, with different deadline statuses, the table should display the most critical SLA due date:
  • In case there are multiple SLAs overdue it should display the one that has expired for the longest time;
  • In case there are SLAs overdue and on time, it should display the one that has expired for the longest time;
  • In case there are multiple SLAs on time, it should display the one that is closest to expire;

• If an SLA is paused, the respective due date should not be displayed. If null replace with hyphen "-";
• If the SLA trigger didn't start counting, the respective due date should not be displayed. If null replace with hyphen "-";
• The table should only bring information from SLAs that are open (meaning the SLA target is still active), so once the SLA stop parameter is triggered, the data for this SLA should not be displayed on the table. If null replace with hyphen "-";

Definitions of Done

• Related tests created and passed successfully;
• All Acceptance Criteria were passed;
• Make sure that all system documentation were updated (if necessary);
• Validated by QA, Product Designer and/or PM;
• No critical issue related to Story scope (ex.: similar of a FP4, FP5 bug);
• Code with peer review completed.

Design Deliverable

• Mockup: https://www.figma.com/file/ylDhTl4YXFu33HYQLiGBWh/14-view-item-SLA-due-date?node-id=219%3A0
• Component: https://www.figma.com/file/ylDhTl4YXFu33HYQLiGBWh/14-view-item-SLA-due-date?node-id=196%3A817