Type:
Status:
Closed
Priority:
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
Testing Notes:
Tested temporal queries that have an exclusion defined and it appears to be working correctly.
When you create a temporal query that includes an excluded panel, the resulting sql has an observation_fact dependency, so the SQL is invalid.
made changes -
17/Mar/17 9:32 AM
Field
Original Value
New Value
Description
When you create a temporal query that includes an excluded panel, the resulting sql has an observation_fact dependency, so the SQL is invalid.
When you create a temporal query that includes an excluded panel, the resulting sql has an observation_fact dependency, so the SQL is invalid.
made changes -
17/Mar/17 9:32 AM
Assignee
Lori Phillips
[ lcp5
]
made changes -
24/Apr/17 2:00 PM
Status
New
[ 10000
]
Open
[ 1
]
made changes -
24/Apr/17 2:00 PM
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
24/Apr/17 2:00 PM
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
made changes -
24/Apr/17 2:01 PM
Assignee
Lori Phillips
[ lcp5
]
Janice Donahoe
[ jmd86
]
made changes -
02/May/17 2:11 PM
Fix Version/s
1.7.09
[ 10306
]
made changes -
10/May/17 10:31 AM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
made changes -
13/Jun/17 10:30 AM
Testing Notes
Tested temporal queries that have an exclusion defined and it appears to be working correctly.
Status
Testing
[ 10002
]
Testing
[ 10002
]
made changes -
13/Jun/17 10:31 AM
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
made changes -
29/Jun/17 9:15 AM
Status
Resolved
[ 5
]
Closed
[ 6
]
{"report":{"fcp":1209.0999994277954,"ttfb":351.3999996185303,"pageVisibility":"visible","entityId":11173,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"1d57f67d-927e-4b69-9149-ba5037a28fb2","navigationType":0,"readyForUser":1260.1999998092651,"redirectCount":0,"resourceLoadedEnd":1085.5999994277954,"resourceLoadedStart":367.5999994277954,"resourceTiming":[{"duration":134,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":367.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":367.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":501.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":138.20000076293945,"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":368.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":368.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":506.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":507.8999996185303,"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":368.30000019073486,"connectEnd":727.5999994277954,"connectStart":708.3000001907349,"domainLookupEnd":708.3000001907349,"domainLookupStart":708.3000001907349,"fetchStart":368.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":727.8000001907349,"responseEnd":876.1999998092651,"responseStart":745.8999996185303,"secureConnectionStart":717.6999998092651},{"duration":505.79999923706055,"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":368.80000019073486,"connectEnd":761.6999998092651,"connectStart":742.1999998092651,"domainLookupEnd":742.1999998092651,"domainLookupStart":742.1999998092651,"fetchStart":368.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":761.8000001907349,"responseEnd":874.5999994277954,"responseStart":778.5,"secureConnectionStart":751.6999998092651},{"duration":486.30000019073486,"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":369,"connectEnd":834.5,"connectStart":814.6999998092651,"domainLookupEnd":814.6999998092651,"domainLookupStart":814.6999998092651,"fetchStart":369,"redirectEnd":0,"redirectStart":0,"requestStart":834.5999994277954,"responseEnd":855.3000001907349,"responseStart":851.8000001907349,"secureConnectionStart":824.1999998092651},{"duration":487,"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":369.30000019073486,"connectEnd":840.5,"connectStart":821.1999998092651,"domainLookupEnd":821.1999998092651,"domainLookupStart":821.1999998092651,"fetchStart":369.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":840.8000001907349,"responseEnd":856.3000001907349,"responseStart":853.5999994277954,"secureConnectionStart":830.5},{"duration":500.3999996185303,"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":369.5,"connectEnd":851.5999994277954,"connectStart":827.0999994277954,"domainLookupEnd":827.0999994277954,"domainLookupStart":827.0999994277954,"fetchStart":369.5,"redirectEnd":0,"redirectStart":0,"requestStart":856.6999998092651,"responseEnd":869.8999996185303,"responseStart":867.8000001907349,"secureConnectionStart":836.5},{"duration":143.60000038146973,"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":369.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":369.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":513.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":627.6999998092651,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":369.8999996185303,"connectEnd":982.5,"connectStart":948.8000001907349,"domainLookupEnd":948.8000001907349,"domainLookupStart":948.8000001907349,"fetchStart":369.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":984.8000001907349,"responseEnd":997.5999994277954,"responseStart":996.3999996185303,"secureConnectionStart":958.3000001907349},{"duration":206,"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":477,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":477,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":683,"responseStart":0,"secureConnectionStart":0},{"duration":551.8999996185303,"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":477.19999980926514,"connectEnd":1006.3000001907349,"connectStart":983,"domainLookupEnd":983,"domainLookupStart":983,"fetchStart":477.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":1006.3000001907349,"responseEnd":1029.0999994277954,"responseStart":1026.0999994277954,"secureConnectionStart":994.5},{"duration":577.3999996185303,"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":499,"connectEnd":1064.3000001907349,"connectStart":1044.5999994277954,"domainLookupEnd":1044.5999994277954,"domainLookupStart":1044.5999994277954,"fetchStart":499,"redirectEnd":0,"redirectStart":0,"requestStart":1064.5,"responseEnd":1076.3999996185303,"responseStart":1075.1999998092651,"secureConnectionStart":1054.3000001907349},{"duration":476.0999994277954,"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":609.5,"connectEnd":1071.3000001907349,"connectStart":1052.0999994277954,"domainLookupEnd":1052.0999994277954,"domainLookupStart":1052.0999994277954,"fetchStart":609.5,"redirectEnd":0,"redirectStart":0,"requestStart":1071.3000001907349,"responseEnd":1085.5999994277954,"responseStart":1082.8999996185303,"secureConnectionStart":1061.5},{"duration":221.80000019073486,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1082.5,"connectEnd":1288.8000001907349,"connectStart":1269.0999994277954,"domainLookupEnd":1269.0999994277954,"domainLookupStart":1269.0999994277954,"fetchStart":1082.5,"redirectEnd":0,"redirectStart":0,"requestStart":1288.8999996185303,"responseEnd":1304.3000001907349,"responseStart":1303.1999998092651,"secureConnectionStart":1278.6999998092651}],"fetchStart":0,"domainLookupStart":188,"domainLookupEnd":258,"connectStart":259,"connectEnd":296,"secureConnectionStart":270,"requestStart":296,"responseStart":352,"responseEnd":610,"domLoading":357,"domInteractive":1346,"domContentLoadedEventStart":1346,"domContentLoadedEventEnd":1391,"domComplete":1584,"loadEventStart":1584,"loadEventEnd":1584,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1289.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1290.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1290.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1293.6999998092651},{"name":"activityTabFullyLoaded","time":1414.0999994277954}],"measures":[],"correlationId":"4de97ac2f47e53","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":297,"dbReadsTimeInMs":55,"dbConnsTimeInMs":75,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Bug
Major