Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1688

CBATS : Performance for Status Summary API

    Details

    • Type: Maintenance
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Labels:
      None

      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

          rohan.khandave Rohan J Khandave (Inactive) created issue -
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Field Original Value New Value
          Epic Link DMS-2 [ 69268 ]
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          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 , Resend 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.
          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.
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Sprint DMS - Fall Sprint 8 [ 167 ]
          Remaining Estimate 28h [ 100800 ]
          Original Estimate 28h [ 100800 ]
          samir Samir made changes -
          Assignee Samir [ samir ] Rohan J Khandave [ rohan.khandave ]
          samir Samir made changes -
          Fix Version/s Between Fall and Winter 2019 [ 10919 ]
          Fix Version/s DMS Architecture [ 10512 ]
          samir Samir made changes -
          Issue Type New Feature [ 2 ] Maintenance [ 11104 ]
          samir Samir made changes -
          Sprint DMS - Fall Sprint 8 [ 167 ] DMS - Gap Fall & Win Sprint 1 [ 173 ]
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Assignee Rohan J Khandave [ rohan.khandave ] Akash Thakur [ akash.thakur ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Status In Progress [ 3 ] In Progress [ 3 ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Remaining Estimate 28h [ 100800 ] 21h [ 75600 ]
          Time Spent 7h [ 25200 ]
          Worklog Id 193687 [ 193687 ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Remaining Estimate 21h [ 75600 ] 13h [ 46800 ]
          Time Spent 7h [ 25200 ] 15h [ 54000 ]
          Worklog Id 193939 [ 193939 ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Status In Progress [ 3 ] Code Review [ 11801 ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Assignee Akash Thakur [ akash.thakur ] Harshveer Singh [ harshveer.singh ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Remaining Estimate 13h [ 46800 ] 5h [ 18000 ]
          Time Spent 15h [ 54000 ] 23h [ 82800 ]
          Worklog Id 194367 [ 194367 ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Remaining Estimate 5h [ 18000 ] 3.6h [ 12960 ]
          Time Spent 23h [ 82800 ] 24.4h [ 87840 ]
          Worklog Id 194368 [ 194368 ]
          Raj.Hawaldar Raj Hawaldar (Inactive) made changes -
          Assignee Harshveer Singh [ harshveer.singh ] Priya Dhamande [ priya.dhamande ]
          Raj.Hawaldar Raj Hawaldar (Inactive) made changes -
          Status Code Review [ 11801 ] In QA Testing [ 11901 ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Remaining Estimate 3.6h [ 12960 ] 3.3h [ 11880 ]
          Time Spent 24.4h [ 87840 ] 24.7h [ 88920 ]
          Worklog Id 194669 [ 194669 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Gap Fall & Win Sprint 1 [ 173 ] DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2 [ 173, 174 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Remaining Estimate 3.3h [ 11880 ] 1.8h [ 6480 ]
          Time Spent 24.7h [ 88920 ] 26.2h [ 94320 ]
          Worklog Id 196007 [ 196007 ]
          Raj.Hawaldar Raj Hawaldar (Inactive) made changes -
          Status Done [ 10001 ] In QA Testing [ 11901 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2 [ 173, 174 ] DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3 [ 173, 174, 177 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3 [ 173, 174, 177 ] DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3, DMS - Gap Fall & Win Sprint 4 [ 173, 174, 177, 179 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status In QA Testing [ 11901 ] Done [ 10001 ]

            People

            Assignee:
            priya.dhamande Priya Dhamande (Inactive)
            Reporter:
            rohan.khandave Rohan J Khandave (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 28h
                28h
                Remaining:
                Time Spent - 26.2h Remaining Estimate - 1.8h
                1.8h
                Logged:
                Time Spent - 26.2h Remaining Estimate - 1.8h
                26.2h