i2b2 Sponsored Project/s:
Developer Notes:
Code changes were done by Mike Mendis
Testing Notes:
verified the statuses are now updated correctly. When a query finishes running the BATCH_MODE is now set to FINISHED and the timeline will be automatically generated.
The BATCH_MODE in the QT_QUERY_INSTANCE table is not getting set to the correct status when a query finishes running. Currently it is getting set to PROCESSING and it should be FINISHED.
As a result the wrong status for the <batch_mode> is sent in the xml message that is returned to the client. If the result type of TIMELINE is checked when running a query the client will automatically generate the timeline when the query has finished running. The workbench uses the <batch_mode> sent in the response message to determine whether or not a query has finished. Since the <batch_mode> is being sent as PROCESSING, the Workbench determines it should not generate the timeline. As a result, users have to take the added steps of going to Previous Queries and manually dragging the query to the Timeline view to generate the timeline.
{"report":{"fcp":1056,"ttfb":283.5,"pageVisibility":"visible","entityId":11069,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"600d10cb-4673-4970-ae22-26774b683a00","navigationType":0,"readyForUser":1137.8999999999069,"redirectCount":0,"resourceLoadedEnd":1227.5,"resourceLoadedStart":290.89999999990687,"resourceTiming":[{"duration":28.899999999906868,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":290.89999999990687,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":290.89999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":319.79999999981374,"responseStart":0,"secureConnectionStart":0},{"duration":28.699999999720603,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true","startTime":291.10000000009313,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":291.10000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":319.79999999981374,"responseStart":0,"secureConnectionStart":0},{"duration":433.59999999962747,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":291.20000000018626,"connectEnd":580.1000000000931,"connectStart":555.6000000000931,"domainLookupEnd":291.20000000018626,"domainLookupStart":291.20000000018626,"fetchStart":291.20000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":580.2000000001863,"responseEnd":724.7999999998137,"responseStart":627.8999999999069,"secureConnectionStart":568},{"duration":434.60000000009313,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":291.29999999981374,"connectEnd":643.5,"connectStart":618.2000000001863,"domainLookupEnd":291.29999999981374,"domainLookupStart":291.29999999981374,"fetchStart":291.29999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":643.5,"responseEnd":725.8999999999069,"responseStart":663,"secureConnectionStart":631.1000000000931},{"duration":364.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":291.39999999990687,"connectEnd":640.8999999999069,"connectStart":614.1000000000931,"domainLookupEnd":291.39999999990687,"domainLookupStart":291.39999999990687,"fetchStart":291.39999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":640.8999999999069,"responseEnd":655.8999999999069,"responseStart":655,"secureConnectionStart":629},{"duration":375,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":291.79999999981374,"connectEnd":643.5,"connectStart":618.5,"domainLookupEnd":291.79999999981374,"domainLookupStart":291.79999999981374,"fetchStart":291.79999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":643.7000000001863,"responseEnd":666.7999999998137,"responseStart":665.8999999999069,"secureConnectionStart":631.3999999999069},{"duration":32.10000000009313,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":292.10000000009313,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":292.10000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":324.20000000018626,"responseStart":0,"secureConnectionStart":0},{"duration":406.1999999997206,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":292.10000000009313,"connectEnd":683.6000000000931,"connectStart":655.7000000001863,"domainLookupEnd":292.10000000009313,"domainLookupStart":292.10000000009313,"fetchStart":292.10000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":683.7000000001863,"responseEnd":698.2999999998137,"responseStart":697.2000000001863,"secureConnectionStart":671.6000000000931},{"duration":422.1999999997206,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":292.20000000018626,"connectEnd":691.2999999998137,"connectStart":666.7000000001863,"domainLookupEnd":292.20000000018626,"domainLookupStart":292.20000000018626,"fetchStart":292.20000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":691.2999999998137,"responseEnd":714.3999999999069,"responseStart":712.6000000000931,"secureConnectionStart":678.6000000000931},{"duration":188.39999999990687,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/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":400.70000000018626,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":400.70000000018626,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":589.1000000000931,"responseStart":0,"secureConnectionStart":0},{"duration":516.2000000001863,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/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":400.79999999981374,"connectEnd":896.7000000001863,"connectStart":867.6000000000931,"domainLookupEnd":400.79999999981374,"domainLookupStart":400.79999999981374,"fetchStart":400.79999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":898,"responseEnd":917,"responseStart":915.7000000001863,"secureConnectionStart":879.7999999998137},{"duration":620.8000000002794,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":420.39999999990687,"connectEnd":1006.7000000001863,"connectStart":962.2999999998137,"domainLookupEnd":420.39999999990687,"domainLookupStart":420.39999999990687,"fetchStart":420.39999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":1013.6000000000931,"responseEnd":1041.2000000001863,"responseStart":1035.2000000001863,"secureConnectionStart":989.8999999999069},{"duration":548.2999999998137,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":679.2000000001863,"connectEnd":1213.2999999998137,"connectStart":1189.2999999998137,"domainLookupEnd":679.2000000001863,"domainLookupStart":679.2000000001863,"fetchStart":679.2000000001863,"redirectEnd":0,"redirectStart":0,"requestStart":1213.2999999998137,"responseEnd":1227.5,"responseStart":1226.7999999998137,"secureConnectionStart":1201.3999999999069}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":82,"connectEnd":227,"secureConnectionStart":201,"requestStart":227,"responseStart":283,"responseEnd":680,"domLoading":290,"domInteractive":1253,"domContentLoadedEventStart":1254,"domContentLoadedEventEnd":1293,"domComplete":2016,"loadEventStart":2016,"loadEventEnd":2016,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1229.3999999999069},{"name":"bigPipe.sidebar-id.end","time":1231.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1231.6000000000931},{"name":"bigPipe.activity-panel-pipe-id.end","time":1234},{"name":"activityTabFullyLoaded","time":1303.8999999999069}],"measures":[],"correlationId":"730cfc763f8233","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":439,"dbReadsTimeInMs":52,"dbConnsTimeInMs":69,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}