Document Management SystemProject Type: software

Document Management System

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

DMS transaction history

    Details

    • Type: New Feature
    • Status: Done
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: Enhancements - Fall
    • Labels:
      None

      Description

      DMS History: Maintaining history of all transaction tables

        Attachments

          Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. DMS-1663 DMS transaction history : Dynamic trigger generation for history table

          • Medium - Has the potential to affect progress.
          • Done

          New Feature - A new feature of the product, which has yet to be developed. DMS-1671 DMS - Transaction History : Additional Columns and History tables creation

          • Medium - Has the potential to affect progress.
          • Done

          New Feature - A new feature of the product, which has yet to be developed. DMS-344 UI to display changes done from History tables

          • High - Serious problem that could block progress.
          • Done

          New Feature - A new feature of the product, which has yet to be developed. DMS-347 Web page for displaying history

          • High - Serious problem that could block progress.
          • Done

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 27/Dec/18 05:10 AM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 11/Jul/19 06:28 AM
            • Time Spent:
              7h
               
              • Analysis of triggering in mysql
              • Discussion with Rohan and Nandu regarding implementation approach
              • Created sample trigger for insert, update and delete record of table
            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 11/Jul/19 09:24 PM
            • Time Spent:
              7h
               

              Trigger analysis

              Table identification for history table

              Discussion with Rohan regarding approch

            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 14/Jul/19 09:14 PM
            • Time Spent:
              7.5h
               
              • Discussion with Rohan
              • SP writing for trigger generation
            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 15/Jul/19 10:25 PM
            • Time Spent:
              7.5h
               

              Changes done in following stored procedures for History tables

              1. DMS_SP_Add_Column
              2. DMS_SP_Drop_Column
              3. DMS_SP_Modify_Column_DataType
              4. DMS_SP_Modify_Column_Rename
              5. HistoryTableCreation
            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 17/Jul/19 06:40 AM
            • Time Spent:
              6.5h
               
              • Updates in SP HistoryTableCreation
              • Analysis for dynamic trigger generation
              • Discussion with Ramya and Rohan for dynamic trigger generation
            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 17/Jul/19 01:54 PM - edited
            • Time Spent:
              7.5h
               

              Created History tables

              Done analysis of remaining tables

            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 18/Jul/19 10:42 PM
            • Time Spent:
              7.5h
               
              <No comment>
            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 22/Jul/19 06:45 AM
            • Time Spent:
              1h
               

              Code review suggestions and check ins

            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 22/Jul/19 08:57 PM - edited
            • Time Spent:
              0.5h
               

              Build issue resolve

              People

              Assignee:
              priya.dhamande Priya Dhamande (Inactive)
              Reporter:
              samir Samir
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 56h Original Estimate - 56h
                  56h
                  Remaining:
                  Time Spent - 70h Remaining Estimate - 2h
                  2h
                  Logged:
                  Time Spent - 70h Remaining Estimate - 2h
                  70h