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":412.80000019073486,"ttfb":59.39999961853027,"pageVisibility":"visible","entityId":11173,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":1,"journeyId":"12d33e52-da0a-4535-8d12-5cee2647471e","navigationType":0,"readyForUser":474.69999980926514,"redirectCount":0,"resourceLoadedEnd":471.8999996185303,"resourceLoadedStart":67.69999980926514,"resourceTiming":[{"duration":18.699999809265137,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":67.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":67.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":86.39999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":18.800000190734863,"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":68,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":68,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":86.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":50.19999980926514,"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":68.19999980926514,"connectEnd":68.19999980926514,"connectStart":68.19999980926514,"domainLookupEnd":68.19999980926514,"domainLookupStart":68.19999980926514,"fetchStart":68.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":68.19999980926514,"responseEnd":118.39999961853027,"responseStart":118.39999961853027,"secureConnectionStart":68.19999980926514},{"duration":78.10000038146973,"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":68.39999961853027,"connectEnd":68.39999961853027,"connectStart":68.39999961853027,"domainLookupEnd":68.39999961853027,"domainLookupStart":68.39999961853027,"fetchStart":68.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":68.39999961853027,"responseEnd":146.5,"responseStart":146.5,"secureConnectionStart":68.39999961853027},{"duration":79.89999961853027,"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":68.60000038146973,"connectEnd":68.60000038146973,"connectStart":68.60000038146973,"domainLookupEnd":68.60000038146973,"domainLookupStart":68.60000038146973,"fetchStart":68.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":68.60000038146973,"responseEnd":148.5,"responseStart":148.5,"secureConnectionStart":68.60000038146973},{"duration":80.5,"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":68.69999980926514,"connectEnd":68.69999980926514,"connectStart":68.69999980926514,"domainLookupEnd":68.69999980926514,"domainLookupStart":68.69999980926514,"fetchStart":68.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":68.69999980926514,"responseEnd":149.19999980926514,"responseStart":149.19999980926514,"secureConnectionStart":68.69999980926514},{"duration":80.70000076293945,"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":68.89999961853027,"connectEnd":68.89999961853027,"connectStart":68.89999961853027,"domainLookupEnd":68.89999961853027,"domainLookupStart":68.89999961853027,"fetchStart":68.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":68.89999961853027,"responseEnd":149.60000038146973,"responseStart":149.60000038146973,"secureConnectionStart":68.89999961853027},{"duration":81.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":69,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":69,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":150.60000038146973,"responseStart":0,"secureConnectionStart":0},{"duration":81,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":69.19999980926514,"connectEnd":69.19999980926514,"connectStart":69.19999980926514,"domainLookupEnd":69.19999980926514,"domainLookupStart":69.19999980926514,"fetchStart":69.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":69.19999980926514,"responseEnd":150.19999980926514,"responseStart":150.19999980926514,"secureConnectionStart":69.19999980926514},{"duration":156.80000019073486,"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":111.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":111.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":268.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":74.89999961853027,"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":111.60000038146973,"connectEnd":111.60000038146973,"connectStart":111.60000038146973,"domainLookupEnd":111.60000038146973,"domainLookupStart":111.60000038146973,"fetchStart":111.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":111.60000038146973,"responseEnd":186.5,"responseStart":186.5,"secureConnectionStart":111.60000038146973},{"duration":144.69999980926514,"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":127.5,"connectEnd":127.5,"connectStart":127.5,"domainLookupEnd":127.5,"domainLookupStart":127.5,"fetchStart":127.5,"redirectEnd":0,"redirectStart":0,"requestStart":127.5,"responseEnd":272.19999980926514,"responseStart":272.19999980926514,"secureConnectionStart":127.5},{"duration":33.69999980926514,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":332.69999980926514,"connectEnd":332.69999980926514,"connectStart":332.69999980926514,"domainLookupEnd":332.69999980926514,"domainLookupStart":332.69999980926514,"fetchStart":332.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":332.69999980926514,"responseEnd":366.3999996185303,"responseStart":366.3999996185303,"secureConnectionStart":332.69999980926514},{"duration":18.300000190734863,"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":348.69999980926514,"connectEnd":348.69999980926514,"connectStart":348.69999980926514,"domainLookupEnd":348.69999980926514,"domainLookupStart":348.69999980926514,"fetchStart":348.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":348.69999980926514,"responseEnd":367,"responseStart":367,"secureConnectionStart":348.69999980926514},{"duration":45.79999923706055,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-atl.general/batch.js","startTime":426.1000003814697,"connectEnd":426.1000003814697,"connectStart":426.1000003814697,"domainLookupEnd":426.1000003814697,"domainLookupStart":426.1000003814697,"fetchStart":426.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":426.1000003814697,"responseEnd":471.8999996185303,"responseStart":471.8999996185303,"secureConnectionStart":426.1000003814697}],"fetchStart":0,"domainLookupStart":14,"domainLookupEnd":14,"connectStart":14,"connectEnd":34,"secureConnectionStart":24,"requestStart":34,"responseStart":59,"responseEnd":160,"domLoading":66,"domInteractive":525,"domContentLoadedEventStart":525,"domContentLoadedEventEnd":558,"domComplete":840,"loadEventStart":840,"loadEventEnd":840,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":500.8999996185303},{"name":"bigPipe.sidebar-id.end","time":501.69999980926514},{"name":"bigPipe.activity-panel-pipe-id.start","time":501.8999996185303},{"name":"bigPipe.activity-panel-pipe-id.end","time":504.80000019073486},{"name":"activityTabFullyLoaded","time":578.8000001907349}],"measures":[],"correlationId":"56fa0af7d43a13","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":115,"dbReadsTimeInMs":15,"dbConnsTimeInMs":18,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Bug
Major