Testing Notes:
Hide
Tested in both the Web Client and Workbench and appears to be working correctly. Ran several queries in which Encounter set was selected as on of the result types (both alone and with other result types).
Show
Tested in both the Web Client and Workbench and appears to be working correctly. Ran several queries in which Encounter set was selected as on of the result types (both alone and with other result types).
Environment: Tested with the latest PostgreSQL database (bamboo)
The following error occurs when running an i2b2 Query against a PostgreSQL database:
{"report":{"fcp":1957.5,"ttfb":302.19999999925494,"pageVisibility":"visible","entityId":10256,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"819db5a5-dc44-4081-b17e-4d2903e21ee5","navigationType":0,"readyForUser":2034.7999999988824,"redirectCount":0,"resourceLoadedEnd":2349.199999999255,"resourceLoadedStart":308,"resourceTiming":[{"duration":1248.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":308,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":308,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1556.5,"responseStart":0,"secureConnectionStart":0},{"duration":1248.7999999988824,"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":308.40000000037253,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":308.40000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1557.199999999255,"responseStart":0,"secureConnectionStart":0},{"duration":1357.7999999988824,"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":308.5,"connectEnd":1587.5,"connectStart":1560.4000000003725,"domainLookupEnd":308.5,"domainLookupStart":308.5,"fetchStart":308.5,"redirectEnd":0,"redirectStart":0,"requestStart":1588.9000000003725,"responseEnd":1666.2999999988824,"responseStart":1608.7999999988824,"secureConnectionStart":1574.5999999996275},{"duration":1364.199999999255,"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":308.5,"connectEnd":1588.0999999996275,"connectStart":1560.2999999988824,"domainLookupEnd":308.5,"domainLookupStart":308.5,"fetchStart":308.5,"redirectEnd":0,"redirectStart":0,"requestStart":1589.5,"responseEnd":1672.699999999255,"responseStart":1613.9000000003725,"secureConnectionStart":1574.4000000003725},{"duration":1302.300000000745,"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":308.59999999962747,"connectEnd":1588.7999999988824,"connectStart":1561.699999999255,"domainLookupEnd":308.59999999962747,"domainLookupStart":308.59999999962747,"fetchStart":308.59999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":1589.5999999996275,"responseEnd":1610.9000000003725,"responseStart":1609.5,"secureConnectionStart":1575.2999999988824},{"duration":1304.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":308.69999999925494,"connectEnd":1589.4000000003725,"connectStart":1562,"domainLookupEnd":308.69999999925494,"domainLookupStart":308.69999999925494,"fetchStart":308.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":1589.9000000003725,"responseEnd":1613.199999999255,"responseStart":1611.9000000003725,"secureConnectionStart":1575.5999999996275},{"duration":1253.5,"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":308.7999999988824,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":308.7999999988824,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1562.2999999988824,"responseStart":0,"secureConnectionStart":0},{"duration":1304.1000000014901,"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":308.7999999988824,"connectEnd":1594.4000000003725,"connectStart":1565.5,"domainLookupEnd":308.7999999988824,"domainLookupStart":308.7999999988824,"fetchStart":308.7999999988824,"redirectEnd":0,"redirectStart":0,"requestStart":1594.4000000003725,"responseEnd":1612.9000000003725,"responseStart":1611.0999999996275,"secureConnectionStart":1581.5999999996275},{"duration":1320.699999999255,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":308.90000000037253,"connectEnd":1610.699999999255,"connectStart":1583.2999999988824,"domainLookupEnd":308.90000000037253,"domainLookupStart":308.90000000037253,"fetchStart":308.90000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":1613.5,"responseEnd":1629.5999999996275,"responseStart":1628.9000000003725,"secureConnectionStart":1597.0999999996275},{"duration":1227.9000000003725,"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":338.59999999962747,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":338.59999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1566.5,"responseStart":0,"secureConnectionStart":0},{"duration":1316.5999999996275,"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":338.69999999925494,"connectEnd":1638,"connectStart":1610.7999999988824,"domainLookupEnd":338.69999999925494,"domainLookupStart":338.69999999925494,"fetchStart":338.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":1638.0999999996275,"responseEnd":1655.2999999988824,"responseStart":1654,"secureConnectionStart":1625.199999999255},{"duration":1620.5,"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":352.69999999925494,"connectEnd":1958.4000000003725,"connectStart":1931.699999999255,"domainLookupEnd":352.69999999925494,"domainLookupStart":352.69999999925494,"fetchStart":352.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":1958.4000000003725,"responseEnd":1973.199999999255,"responseStart":1972.5,"secureConnectionStart":1945.5},{"duration":1995.2999999988824,"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":353.90000000037253,"connectEnd":2331.0999999996275,"connectStart":2303,"domainLookupEnd":353.90000000037253,"domainLookupStart":353.90000000037253,"fetchStart":353.90000000037253,"redirectEnd":0,"redirectStart":0,"requestStart":2331.0999999996275,"responseEnd":2349.199999999255,"responseStart":2348.699999999255,"secureConnectionStart":2317},{"duration":478.8999999985099,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1868.9000000003725,"connectEnd":2329,"connectStart":2302.2999999988824,"domainLookupEnd":1868.9000000003725,"domainLookupStart":1868.9000000003725,"fetchStart":1868.9000000003725,"redirectEnd":0,"redirectStart":0,"requestStart":2329.0999999996275,"responseEnd":2347.7999999988824,"responseStart":2347.199999999255,"secureConnectionStart":2316.0999999996275}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":186,"connectEnd":274,"secureConnectionStart":259,"requestStart":274,"responseStart":302,"responseEnd":354,"domLoading":307,"domInteractive":2388,"domContentLoadedEventStart":2388,"domContentLoadedEventEnd":2430,"domComplete":3186,"loadEventStart":3186,"loadEventEnd":3186,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2361.2999999988824},{"name":"bigPipe.sidebar-id.end","time":2364.9000000003725},{"name":"bigPipe.activity-panel-pipe-id.start","time":2365},{"name":"bigPipe.activity-panel-pipe-id.end","time":2366.0999999996275},{"name":"activityTabFullyLoaded","time":2448.2999999988824}],"measures":[],"correlationId":"88592c8bdda87f","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":66,"dbReadsTimeInMs":8,"dbConnsTimeInMs":10,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Major