[DMS-1688] CBATS : Performance for Status Summary API - Workterra Jira

Details

Type: Maintenance
Status: Done
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: Between Fall and Winter 2019
Labels:
None

Company:
All Clients/Multiple Clients
Epic Link:
DMS Architecture

Description

Currently API Scan all documents and all routing / status to get latest status. Which is very time consuming.
To make it fast we can add new column into document table which will contain latest status and Updated Date.

Once document status set to Completed & Rejected after that if user viewed document then no need to update status as Viewed.

So we can get latest status of document of document and no need to join with document routing.

Attachments

Activity

Transition	Time In Source Status	Execution Times

Rohan J Khandave (Inactive) made transition - 05/Aug/19 09:50 PM

To Do

In Progress

10d 23h 5m

Akash Thakur (Inactive) made transition - 07/Aug/19 12:20 AM

In Progress

1d 2h 30m

Akash Thakur (Inactive) made transition - 12/Aug/19 12:08 AM

In Progress

Code Review

4d 23h 47m

Raj Hawaldar (Inactive) made transition - 12/Aug/19 11:23 PM

Code Review

In QA Testing

23h 15m

Raj Hawaldar (Inactive) made transition - 27/Aug/19 11:18 PM

Done

In QA Testing

6d 17h 53m

Priya Dhamande (Inactive) made transition - 19/Sep/19 05:25 AM

In QA Testing

Done

30d 12h 7m

People

Assignee:: Priya Dhamande (Inactive)

Reporter:: Rohan J Khandave (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 25/Jul/19 10:45 PM

Updated:: 19/Sep/19 05:25 AM

Resolved:: 21/Aug/19 05:24 AM

Time Tracking

Estimated:

28h

Remaining:

1.8h

Logged:

26.2h