[DMS-343] DMS transaction history - Workterra Jira

Details

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

Company:
All Clients/Multiple Clients
Epic Link:
End User Portal for DMS

Description

DMS History: Maintaining history of all transaction tables

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

15July19 - DMS-343_HistoryTableAnalysis.xls
31 kB
15/Jul/19 01:50 AM
16July19 - DMS-343_HistoryTableAnalysis.xls
26 kB
16/Jul/19 06:23 AM
17July19 - DMS-343_HistoryTableAnalysis.xls
32 kB
19/Jul/19 05:29 AM
19July19 - DMS-343_HistoryTableAnalysis.xls
32 kB
19/Jul/19 05:30 AM
DMS-343_HistoryTableAnalysis.xls
23 kB
12/Jul/19 06:20 AM

Issue Links

relates to

DMS-1663 DMS transaction history : Dynamic trigger generation for history table

Done

DMS-1671 DMS - Transaction History : Additional Columns and History tables creation

Done

DMS-344 UI to display changes done from History tables

Done

DMS-347 Web page for displaying history

Done

Options

Sub-Tasks

Create SP for Generating History Triggers

DMS-345

Done

Samir

87%

Activity

Ascending order - Click to sort in descending order

Samir created issue - 20/Dec/18 01:54 AM

Nandkumar Prabhakar Karlekar (Inactive) made changes - 20/Dec/18 02:03 AM

Field	Original Value	New Value
Sprint		DMS - Sprint 6 [ 134 ]

Swapnil Pandhare (Inactive) made changes - 25/Dec/18 08:41 PM

Assignee

Samir [ samir ]

Nandkumar Prabhakar Karlekar [ satyap ]

Swapnil Pandhare (Inactive) made changes - 26/Dec/18 08:45 PM

Link

This issue relates to ~~DMS-344~~ [ ~~DMS-344~~ ]

Swapnil Pandhare (Inactive) made changes - 26/Dec/18 08:46 PM

Link

This issue relates to ~~DMS-347~~ [ ~~DMS-347~~ ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 26/Dec/18 09:03 PM

Status

To Do [ 10000 ]

In Progress [ 3 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 27/Dec/18 05:10 AM

Remaining Estimate		0h [ 0 ]
Time Spent		4h [ 14400 ]
Worklog Id	152628 [ 152628 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 27/Dec/18 05:10 AM

Original Estimate

20h [ 72000 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 04/Jan/19 03:42 AM

Status

In Progress [ 3 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 04/Jan/19 03:42 AM

Status

In Progress [ 3 ]

Code Review [ 11801 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 04/Jan/19 03:43 AM

Assignee

Nandkumar Prabhakar Karlekar [ satyap ]

Samir [ samir ]

Swapnil Pandhare (Inactive) made changes - 07/Jan/19 07:59 PM

Sprint

DMS - Sprint 6 [ 134 ]

DMS - Sprint 7 [ 148 ]

Swapnil Pandhare (Inactive) made changes - 13/Jan/19 11:26 PM

Sprint

DMS - Sprint 7 [ 148 ]

DMS - Sprint 1 [ 149 ]

Samir made changes - 14/Jan/19 10:18 PM

Sprint

DMS - Sprint 1 [ 149 ]

Samir made changes - 18/Apr/19 02:31 AM

Summary

DMS History

DMS transaction history

Samir made changes - 18/Apr/19 02:31 AM

Fix Version/s

Enhancements - Fall [ 10610 ]

Samir made changes - 18/Apr/19 02:32 AM

Epic Link

DMS-9 [ 69408 ]

Samir made changes - 01/May/19 12:10 AM

Status

Code Review [ 11801 ]

To Do [ 10000 ]

Samir made changes - 01/May/19 01:08 AM

Sprint

DMS - Fall Sprint 4 [ 163 ]

Samir made changes - 27/May/19 02:34 AM

Sprint

DMS - Fall Sprint 4 [ 163 ]

DMS - Fall Sprint 8 [ 167 ]

Samir made changes - 17/Jun/19 02:30 AM

Sprint

DMS - Fall Sprint 8 [ 167 ]

DMS - Fall Sprint 6 [ 165 ]

Samir made changes - 04/Jul/19 10:09 PM

Sprint

DMS - Fall Sprint 6 [ 165 ]

DMS - Fall Sprint 7 [ 166 ]

Samir made changes - 08/Jul/19 11:02 PM

Assignee

Samir [ samir ]

Sonali Farakate [ sonali.farakate ]

Sonali Farakate (Inactive) made changes - 10/Jul/19 10:04 PM

Status

To Do [ 10000 ]

In Progress [ 3 ]

Sonali Farakate (Inactive) made changes - 11/Jul/19 06:29 AM

Time Spent	4h [ 14400 ]	11h [ 39600 ]
Worklog Id	187780 [ 187780 ]

Sonali Farakate (Inactive) made changes - 12/Jul/19 06:20 AM

Attachment

DMS-343_HistoryTableAnalysis.xls [ 112407 ]

Sonali Farakate (Inactive) made changes - 12/Jul/19 06:25 AM

Time Spent	11h [ 39600 ]	18h [ 64800 ]
Worklog Id	188089 [ 188089 ]

Rohan J Khandave (Inactive) made changes - 15/Jul/19 01:50 AM

Attachment

15July19 - DMS-343_HistoryTableAnalysis.xls [ 112509 ]

Sonali Farakate (Inactive) made changes - 15/Jul/19 01:54 AM

Remaining Estimate	0h [ 0 ]	26h [ 93600 ]
Original Estimate	20h [ 72000 ]	40h [ 144000 ]

Sonali Farakate (Inactive) made changes - 15/Jul/19 06:15 AM

Remaining Estimate	26h [ 93600 ]	18.5h [ 66600 ]
Time Spent	18h [ 64800 ]	25.5h [ 91800 ]
Worklog Id	188418 [ 188418 ]

Sonali Farakate (Inactive) made changes - 16/Jul/19 06:23 AM

Attachment

16July19 - DMS-343_HistoryTableAnalysis.xls [ 112644 ]

Sonali Farakate (Inactive) made changes - 16/Jul/19 06:26 AM

Remaining Estimate	18.5h [ 66600 ]	11h [ 39600 ]
Time Spent	25.5h [ 91800 ]	33h [ 118800 ]
Worklog Id	188686 [ 188686 ]

Sonali Farakate (Inactive) made changes - 17/Jul/19 06:15 AM

Link

This issue relates to ~~DMS-1663~~ [ ~~DMS-1663~~ ]

Sonali Farakate (Inactive) made changes - 17/Jul/19 06:41 AM

Remaining Estimate	11h [ 39600 ]	4.5h [ 16200 ]
Time Spent	33h [ 118800 ]	39.5h [ 142200 ]
Worklog Id	188962 [ 188962 ]

Sonali Farakate (Inactive) made changes - 19/Jul/19 01:55 AM

Remaining Estimate	4.5h [ 16200 ]	0h [ 0 ]
Time Spent	39.5h [ 142200 ]	47h [ 169200 ]
Worklog Id	189722 [ 189722 ]

Sonali Farakate (Inactive) made changes - 19/Jul/19 05:29 AM

Attachment

17July19 - DMS-343_HistoryTableAnalysis.xls [ 113506 ]

Sonali Farakate (Inactive) made changes - 19/Jul/19 05:30 AM

Attachment

19July19 - DMS-343_HistoryTableAnalysis.xls [ 113507 ]

Sonali Farakate (Inactive) made changes - 21/Jul/19 10:42 PM

Time Spent	47h [ 169200 ]	54.5h [ 196200 ]
Worklog Id	190007 [ 190007 ]

Sonali Farakate (Inactive) made changes - 21/Jul/19 10:44 PM

Worklog Id

189722 [ 189722 ]

Sonali Farakate (Inactive) made changes - 21/Jul/19 10:49 PM

Link

This issue relates to ~~DMS-1671~~ [ ~~DMS-1671~~ ]

Sonali Farakate (Inactive) made changes - 21/Jul/19 10:49 PM

Status

In Progress [ 3 ]

Code Review [ 11801 ]

Sonali Farakate (Inactive) made changes - 21/Jul/19 10:50 PM

Assignee

Sonali Farakate [ sonali.farakate ]

Samir [ samir ]

ShashiKant Mishra (Inactive) made changes - 22/Jul/19 03:21 AM

Sprint

DMS - Fall Sprint 7 [ 166 ]

DMS - Fall Sprint 7, DMS - Fall Sprint 8 [ 166, 167 ]

Sonali Farakate (Inactive) made changes - 22/Jul/19 06:46 AM

Time Spent	54.5h [ 196200 ]	55.5h [ 199800 ]
Worklog Id	190478 [ 190478 ]

Sonali Farakate (Inactive) made changes - 23/Jul/19 08:57 PM

Time Spent	55.5h [ 199800 ]	56h [ 201600 ]
Worklog Id	190896 [ 190896 ]

Sonali Farakate (Inactive) made changes - 23/Jul/19 08:57 PM

Worklog Id

190896 [ 190896 ]

Raj Hawaldar (Inactive) made changes - 25/Jul/19 03:13 AM

Assignee

Samir [ samir ]

Priya Dhamande [ priya.dhamande ]

Raj Hawaldar (Inactive) made changes - 25/Jul/19 03:13 AM

Status

Code Review [ 11801 ]

In QA Testing [ 11901 ]

Sonali Farakate (Inactive) made changes - 25/Jul/19 04:46 AM

Attachment

HistoryTableConsiderations.xls [ 114434 ]

Sonali Farakate (Inactive) made changes - 25/Jul/19 09:32 PM

Attachment

HistoryTableConsiderations.xls [ 114434 ]

Priya Dhamande (Inactive) made changes - 29/Jul/19 01:36 AM

Resolution		Done [ 10000 ]
Status	In QA Testing [ 11901 ]	Done [ 10001 ]

People

Assignee:: Priya Dhamande (Inactive)

Reporter:: Samir

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 20/Dec/18 01:54 AM

Updated:: 29/Jul/19 01:36 AM

Resolved:: 29/Jul/19 01:36 AM

Time Tracking

Estimated:

56h

Remaining:

Logged:

70h

Include sub-tasks