Document Management SystemProject Type: software

Document Management System

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
    • Fix Version/s: Between Fall and Winter 2019
    • 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

          Ascending order - Click to sort in descending order
          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 ]
          Permalink
          akash.thakur Akash Thakur (Inactive) logged work - 07/Aug/19 05:56 AM
          • Time Spent:
            7h
             

            analysis.

            R &D.

            KT for approach.

            etc

            development started.

          akash.thakur Akash Thakur (Inactive) made changes -
          Remaining Estimate 28h [ 100800 ] 21h [ 75600 ]
          Time Spent 7h [ 25200 ]
          Worklog Id 193687 [ 193687 ]
          Permalink
          akash.thakur Akash Thakur (Inactive) logged work - 08/Aug/19 07:09 AM
          • Time Spent:
            8h
             

            testing code changes and impacts.

          akash.thakur Akash Thakur (Inactive) made changes -
          Remaining Estimate 21h [ 75600 ] 13h [ 46800 ]
          Time Spent 7h [ 25200 ] 15h [ 54000 ]
          Worklog Id 193939 [ 193939 ]
          Permalink
          akash.thakur Akash Thakur (Inactive) logged work - 09/Aug/19 12:08 AM
          • Time Spent:
            8h
             

            API level testing.

            Re-factoring.

            re-testing changes.

            code merge.

             

             

             

          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 ]
          Permalink
          akash.thakur Akash Thakur (Inactive) logged work - 12/Aug/19 12:09 AM
          • Time Spent:
            1.4h
             

            code merge.

            code commit.

            PR creation.

            internal review.

            code merge conflicts.

            verification.

          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 ]
          Hide
          Permalink
          akash.thakur Akash Thakur (Inactive) added a comment -

          Hi All,

          We are done with code changes for this JIRA several changes were made to enhance the performance of API using our approach. we have unit tested all impact areas and have created PR for the same. Harshveer Singh please review the changes

          Thanks,

          Akash Thakur

           

          Rohan J Khandave Samir Harshveer Singh Ganesh Sadawarte 

           

          Show
          akash.thakur Akash Thakur (Inactive) added a comment - Hi All, We are done with code changes for this JIRA several changes were made to enhance the performance of API using our approach. we have unit tested all impact areas and have created PR for the same. Harshveer Singh please review the changes Thanks, Akash Thakur   Rohan J Khandave Samir Harshveer Singh Ganesh Sadawarte    
          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 ]
          Permalink
          akash.thakur Akash Thakur (Inactive) logged work - 13/Aug/19 05:10 AM
          • Time Spent:
            0.3h
             

            Data migration on Pre-prod and productiuon for DMS-1688

          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 ]
          Permalink
          priya.dhamande Priya Dhamande (Inactive) logged work - 21/Aug/19 05:24 AM
          • Time Spent:
            1.5h
             

            Preprod testing

          Hide
          Permalink
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: Preprod - OneIM
          API:
          1. Latest Status
          2. Status Summary and
          3. Status History

          Verified for count only as there are hardly 25 templates available, so performance is good.

          Count is matching. So, marking jira done.

          Samir Hrishikesh Deshpande Rohan J Khandave Akash Thakur Hrishikesh Deshpande

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Preprod - OneIM API: 1. Latest Status 2. Status Summary and 3. Status History Verified for count only as there are hardly 25 templates available, so performance is good. Count is matching. So, marking jira done. Samir Hrishikesh Deshpande Rohan J Khandave Akash Thakur Hrishikesh Deshpande
          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 ]
          Transition Time In Source Status Execution Times
          Rohan J Khandave (Inactive) made transition -
          To Do In Progress
          		10d 23h 5m 1
          Akash Thakur (Inactive) made transition -
          In Progress In Progress
          		1d 2h 30m 1
          Akash Thakur (Inactive) made transition -
          In Progress Code Review
          		4d 23h 47m 1
          Raj Hawaldar (Inactive) made transition -
          Code Review In QA Testing
          		23h 15m 1
          Raj Hawaldar (Inactive) made transition -
          Done In QA Testing
          		6d 17h 53m 1
          Priya Dhamande (Inactive) made transition -
          In QA Testing Done
          		30d 12h 7m 2

            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