Type:
Maintenance
Status:
Done
Priority:
Medium
Resolution:
Done
Affects Version/s:
None
Company:
All Clients/Multiple Clients
Sprint:
DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3, DMS - Gap Fall & Win Sprint 4
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 J Khandave (Inactive)
made changes -
25/Jul/19 10:54 PM
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 J Khandave (Inactive)
made changes -
25/Jul/19 10:56 PM
Sprint
DMS - Fall Sprint 8
[ 167
]
Remaining Estimate
28h
[ 100800
]
Original Estimate
28h
[ 100800
]
Samir
made changes -
29/Jul/19 09:04 PM
Assignee
Samir
[ samir
]
Rohan J Khandave
[ rohan.khandave
]
Samir
made changes -
30/Jul/19 11:32 PM
Fix Version/s
Between Fall and Winter 2019
[ 10919
]
Fix Version/s
DMS Architecture
[ 10512
]
Samir
made changes -
30/Jul/19 11:32 PM
Issue Type
New Feature
[ 2
]
Maintenance
[ 11104
]
Samir
made changes -
05/Aug/19 12:00 AM
Sprint
DMS - Fall Sprint 8
[ 167
]
DMS - Gap Fall & Win Sprint 1
[ 173
]
Rohan J Khandave (Inactive)
made changes -
07/Aug/19 12:12 AM
Assignee
Rohan J Khandave
[ rohan.khandave
]
Akash Thakur
[ akash.thakur
]
Akash Thakur (Inactive)
made changes -
07/Aug/19 05:57 AM
Remaining Estimate
28h
[ 100800
]
21h
[ 75600
]
Time Spent
7h
[ 25200
]
Worklog Id
193687
[ 193687
]
Akash Thakur (Inactive)
made changes -
08/Aug/19 07:10 AM
Remaining Estimate
21h
[ 75600
]
13h
[ 46800
]
Time Spent
7h
[ 25200
]
15h
[ 54000
]
Worklog Id
193939
[ 193939
]
Akash Thakur (Inactive)
made changes -
12/Aug/19 12:08 AM
Assignee
Akash Thakur
[ akash.thakur
]
Harshveer Singh
[ harshveer.singh
]
Akash Thakur (Inactive)
made changes -
12/Aug/19 12:09 AM
Remaining Estimate
13h
[ 46800
]
5h
[ 18000
]
Time Spent
15h
[ 54000
]
23h
[ 82800
]
Worklog Id
194367
[ 194367
]
Akash Thakur (Inactive)
made changes -
12/Aug/19 12:10 AM
Remaining Estimate
5h
[ 18000
]
3.6h
[ 12960
]
Time Spent
23h
[ 82800
]
24.4h
[ 87840
]
Worklog Id
194368
[ 194368
]
Raj Hawaldar (Inactive)
made changes -
12/Aug/19 11:23 PM
Assignee
Harshveer Singh
[ harshveer.singh
]
Priya Dhamande
[ priya.dhamande
]
Akash Thakur (Inactive)
made changes -
13/Aug/19 05:10 AM
Remaining Estimate
3.6h
[ 12960
]
3.3h
[ 11880
]
Time Spent
24.4h
[ 87840
]
24.7h
[ 88920
]
Worklog Id
194669
[ 194669
]
ShashiKant Mishra (Inactive)
made changes -
19/Aug/19 02:33 AM
Sprint
DMS - Gap Fall & Win Sprint 1
[ 173
]
DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2
[ 173, 174
]
Priya Dhamande (Inactive)
made changes -
21/Aug/19 05:24 AM
Resolution
Done
[ 10000
]
Status
In QA Testing
[ 11901
]
Done
[ 10001
]
Priya Dhamande (Inactive)
made changes -
21/Aug/19 05:24 AM
Remaining Estimate
3.3h
[ 11880
]
1.8h
[ 6480
]
Time Spent
24.7h
[ 88920
]
26.2h
[ 94320
]
Worklog Id
196007
[ 196007
]
ShashiKant Mishra (Inactive)
made changes -
30/Aug/19 09:30 PM
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 (Inactive)
made changes -
16/Sep/19 01:52 AM
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
]
Transition
Time In Source Status
Execution Times
To Do
In Progress
10d 23h 5m
1
In Progress
In Progress
1d 2h 30m
1
In Progress
Code Review
4d 23h 47m
1
Code Review
In QA Testing
23h 15m
1
Done
In QA Testing
6d 17h 53m
1
In QA Testing
Done
30d 12h 7m
2
{"report":{"apdex":1,"isInitial":true,"journeyId":"c2f975d8-b9d3-4e10-b754-9da5e212a35d","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":981.3999999910593,"redirectCount":0,"resourceLoadedEnd":1189.5,"resourceLoadedStart":415,"resourceTiming":[{"duration":114.59999999403954,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":415,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":415,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":529.5999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":114.3999999910593,"initiatorType":"link","name":"https://jira.workterra.net/s/dd6a0911920485696ac20493290df627-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":415.29999999701977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":415.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":529.6999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":114.79999999701977,"initiatorType":"link","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":415.3999999910593,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":415.3999999910593,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":530.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":114.8999999910593,"initiatorType":"link","name":"https://jira.workterra.net/s/bd548f27bbf8f278bd83b60dd3284ed8-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":415.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":415.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":530.3999999910593,"responseStart":0,"secureConnectionStart":0},{"duration":115,"initiatorType":"link","name":"https://jira.workterra.net/s/70725731a158a7140f19ddbd4201ba27-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":415.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":415.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":530.5999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":142.5,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":415.69999998807907,"connectEnd":415.69999998807907,"connectStart":415.69999998807907,"domainLookupEnd":415.69999998807907,"domainLookupStart":415.69999998807907,"fetchStart":415.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":415.69999998807907,"responseEnd":558.1999999880791,"responseStart":558.1999999880791,"secureConnectionStart":415.69999998807907},{"duration":185.20000000298023,"initiatorType":"script","name":"https://jira.workterra.net/s/6ce676f2a5bcc9651cef6e7956f05def-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":415.79999999701977,"connectEnd":415.79999999701977,"connectStart":415.79999999701977,"domainLookupEnd":415.79999999701977,"domainLookupStart":415.79999999701977,"fetchStart":415.79999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":415.79999999701977,"responseEnd":601,"responseStart":601,"secureConnectionStart":415.79999999701977},{"duration":187.5,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/4.1.5/_/download/resources/com.atlassian.plugins.atlassian-chaperone:hotspot-tour/hotspot-tour.js?batch=false&locale=en-US","startTime":416,"connectEnd":416,"connectStart":416,"domainLookupEnd":416,"domainLookupStart":416,"fetchStart":416,"redirectEnd":0,"redirectStart":0,"requestStart":416,"responseEnd":603.5,"responseStart":603.5,"secureConnectionStart":416},{"duration":188.40000000596046,"initiatorType":"script","name":"https://jira.workterra.net/s/6aa3fcf1fac5fd551eee0b69077524e6-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":416.09999999403954,"connectEnd":416.09999999403954,"connectStart":416.09999999403954,"domainLookupEnd":416.09999999403954,"domainLookupStart":416.09999999403954,"fetchStart":416.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":416.09999999403954,"responseEnd":604.5,"responseStart":604.5,"secureConnectionStart":416.09999999403954},{"duration":188.90000000596046,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":416.19999998807907,"connectEnd":416.19999998807907,"connectStart":416.19999998807907,"domainLookupEnd":416.19999998807907,"domainLookupStart":416.19999998807907,"fetchStart":416.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":416.19999998807907,"responseEnd":605.0999999940395,"responseStart":605.0999999940395,"secureConnectionStart":416.19999998807907},{"duration":189.3999999910593,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":416.29999999701977,"connectEnd":416.29999999701977,"connectStart":416.29999999701977,"domainLookupEnd":416.29999999701977,"domainLookupStart":416.29999999701977,"fetchStart":416.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":416.29999999701977,"responseEnd":605.6999999880791,"responseStart":605.6999999880791,"secureConnectionStart":416.29999999701977},{"duration":196.29999999701977,"initiatorType":"link","name":"https://jira.workterra.net/s/05c862146699bb029ceb0a489075e63b-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/bcd66e9a133a1b9f5fd14b56841e1c5b/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":416.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":416.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":612.7999999970198,"responseStart":0,"secureConnectionStart":0},{"duration":189.59999999403954,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":416.5,"connectEnd":416.5,"connectStart":416.5,"domainLookupEnd":416.5,"domainLookupStart":416.5,"fetchStart":416.5,"redirectEnd":0,"redirectStart":0,"requestStart":416.5,"responseEnd":606.0999999940395,"responseStart":606.0999999940395,"secureConnectionStart":416.5},{"duration":190.09999999403954,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/ea6f30d2bfdc99578bb23f4a5bac3ecd/shortcuts.js?context=issuenavigation&context=issueaction","startTime":416.59999999403954,"connectEnd":416.59999999403954,"connectStart":416.59999999403954,"domainLookupEnd":416.59999999403954,"domainLookupStart":416.59999999403954,"fetchStart":416.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":416.59999999403954,"responseEnd":606.6999999880791,"responseStart":606.6999999880791,"secureConnectionStart":416.59999999403954},{"duration":196.20000000298023,"initiatorType":"link","name":"https://jira.workterra.net/s/9095228fa10daa2d3e3d7d5760c95e91-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":416.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":416.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":612.8999999910593,"responseStart":0,"secureConnectionStart":0},{"duration":190.5,"initiatorType":"script","name":"https://jira.workterra.net/s/c19a1b46e985d7fb85efaf27c8febfdd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":416.79999999701977,"connectEnd":416.79999999701977,"connectStart":416.79999999701977,"domainLookupEnd":416.79999999701977,"domainLookupStart":416.79999999701977,"fetchStart":416.79999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":416.79999999701977,"responseEnd":607.2999999970198,"responseStart":607.2999999970198,"secureConnectionStart":416.79999999701977}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":253,"responseStart":408,"responseEnd":410,"domLoading":412,"domInteractive":1319,"domContentLoadedEventStart":1319,"domContentLoadedEventEnd":1393,"domComplete":1669,"loadEventStart":1669,"loadEventEnd":1672,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"a3db315f9911b","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":110,"dbReadsTimeInMs":16,"dbConnsTimeInMs":21,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
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