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).
Environment: Tested with the latest PostgreSQL database (bamboo)
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:
Operator does not exist: integer = character varying
The above error will occur only when the result type of Encounter set is selected when running the query.
Janice Donahoe
made changes -
22/May/14 5:58 PM
Field
Original Value
New Value
Workflow
classic default workflow
[ 10256
]
i2b2 Issues
[ 10316
]
Janice Donahoe
made changes -
29/May/14 4:07 PM
Workflow
i2b2 Issues
[ 10316
]
i2b2 Issues Workflow
[ 10449
]
Mike Mendis
made changes -
03/Jun/14 10:26 AM
Status
Open
[ 1
]
In Progress
[ 3
]
Mike Mendis
made changes -
03/Jun/14 10:27 AM
Assignee
Mike Mendis
[ mem61
]
Janice Donahoe
[ jmd86
]
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
Janice Donahoe
made changes -
05/Jun/14 6:41 PM
Component/s
CRC Cell
[ 10049
]
Component/s
CRC Cell
[ 10000
]
Key
LEOPARD-158
CORE-103
Project
i2b2
[ 10000
]
i2b2 Core Project
[ 10034
]
Affects Version/s
1.7.01
[ 10154
]
Affects Version/s
1.7.00
[ 10153
]
Affects Version/s
1.7.00
[ 10081
]
Affects Version/s
1.7.01
[ 10090
]
Janice Donahoe
made changes -
06/Jun/14 11:25 AM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
Janice Donahoe
made changes -
06/Jun/14 2:34 PM
Build Number/s (Testing)
1.7.02.0005
Fix Version/s
1.7.02
[ 10155
]
Testing Notes
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).
Status
Testing
[ 10002
]
Testing
[ 10002
]
Janice Donahoe
made changes -
06/Jun/14 2:34 PM
Build Number (Fixed)
1.7.02.0005
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
Janice Donahoe
made changes -
06/Jun/14 2:35 PM
Resolution
Fixed
[ 1
]
Status
Resolved
[ 5
]
Reopened
[ 4
]
Janice Donahoe
made changes -
06/Jun/14 2:35 PM
Status
Reopened
[ 4
]
In Progress
[ 3
]
Janice Donahoe
made changes -
06/Jun/14 2:35 PM
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
Janice Donahoe
made changes -
06/Jun/14 4:05 PM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
Janice Donahoe
made changes -
09/Jun/14 11:05 AM
Testing Notes
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).
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)
i2b2 Feature/s
Queries
[ 10081
]
Status
Testing
[ 10002
]
Testing
[ 10002
]
Janice Donahoe
made changes -
09/Jun/14 11:05 AM
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
Janice Donahoe
made changes -
01/Jul/14 11:38 AM
Status
Resolved
[ 5
]
Closed
[ 6
]
{"report":{"fcp":1184.9000005722046,"ttfb":418.5,"pageVisibility":"visible","entityId":10256,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"06ee3a35-52d3-40b2-8f43-547fe73b5b8d","navigationType":0,"readyForUser":1255.5,"redirectCount":0,"resourceLoadedEnd":1512,"resourceLoadedStart":429.80000019073486,"resourceTiming":[{"duration":244.30000019073486,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":429.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":429.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":674.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":244.30000019073486,"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":430.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":430.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":674.4000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":509.0999994277954,"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":430.4000005722046,"connectEnd":855.8000001907349,"connectStart":835.1999998092651,"domainLookupEnd":835.1999998092651,"domainLookupStart":835.1999998092651,"fetchStart":430.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":855.8000001907349,"responseEnd":939.5,"responseStart":871.4000005722046,"secureConnectionStart":844.6999998092651},{"duration":538.2000007629395,"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":430.69999980926514,"connectEnd":867,"connectStart":842.1000003814697,"domainLookupEnd":842.1000003814697,"domainLookupStart":842,"fetchStart":430.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":867.5,"responseEnd":968.9000005722046,"responseStart":887.9000005722046,"secureConnectionStart":854.1000003814697},{"duration":465.9000005722046,"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":431,"connectEnd":875.8000001907349,"connectStart":850.3000001907349,"domainLookupEnd":850.3000001907349,"domainLookupStart":850.3000001907349,"fetchStart":431,"redirectEnd":0,"redirectStart":0,"requestStart":875.9000005722046,"responseEnd":896.9000005722046,"responseStart":890.5,"secureConnectionStart":865.6000003814697},{"duration":480,"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":431.1000003814697,"connectEnd":895.6999998092651,"connectStart":873.8000001907349,"domainLookupEnd":873.8000001907349,"domainLookupStart":873.8000001907349,"fetchStart":431.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":897.6999998092651,"responseEnd":911.1000003814697,"responseStart":909.1999998092651,"secureConnectionStart":883.6999998092651},{"duration":497.19999980926514,"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":431.4000005722046,"connectEnd":916.5,"connectStart":896.6999998092651,"domainLookupEnd":896.6999998092651,"domainLookupStart":896.6999998092651,"fetchStart":431.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":916.6000003814697,"responseEnd":928.6000003814697,"responseStart":927.8000001907349,"secureConnectionStart":906.4000005722046},{"duration":256.6000003814697,"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":431.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":431.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":688.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":500.80000019073486,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":431.69999980926514,"connectEnd":920,"connectStart":899.5,"domainLookupEnd":899.5,"domainLookupStart":899.5,"fetchStart":431.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":920.1000003814697,"responseEnd":932.5,"responseStart":931.4000005722046,"secureConnectionStart":909.8000001907349},{"duration":185.70000076293945,"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":568.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":568.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":753.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":470.5,"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":568.5,"connectEnd":1025.3000001907349,"connectStart":999.6000003814697,"domainLookupEnd":999.6000003814697,"domainLookupStart":999.6000003814697,"fetchStart":568.5,"redirectEnd":0,"redirectStart":0,"requestStart":1025.4000005722046,"responseEnd":1039,"responseStart":1037.6999998092651,"secureConnectionStart":1013.8000001907349},{"duration":554.7999992370605,"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":590.9000005722046,"connectEnd":1133.9000005722046,"connectStart":1112.9000005722046,"domainLookupEnd":1112.9000005722046,"domainLookupStart":1112.9000005722046,"fetchStart":590.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":1134,"responseEnd":1145.6999998092651,"responseStart":1144.8000001907349,"secureConnectionStart":1122.6999998092651},{"duration":835.5999994277954,"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":676.4000005722046,"connectEnd":1498,"connectStart":1474.5,"domainLookupEnd":1474.5,"domainLookupStart":1474.5,"fetchStart":676.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":1498,"responseEnd":1512,"responseStart":1511.1999998092651,"secureConnectionStart":1486},{"duration":371.69999980926514,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1121.5,"connectEnd":1478.1999998092651,"connectStart":1458.1999998092651,"domainLookupEnd":1458.1999998092651,"domainLookupStart":1458.1999998092651,"fetchStart":1121.5,"redirectEnd":0,"redirectStart":0,"requestStart":1478.1999998092651,"responseEnd":1493.1999998092651,"responseStart":1492.6000003814697,"secureConnectionStart":1467.9000005722046}],"fetchStart":0,"domainLookupStart":218,"domainLookupEnd":267,"connectStart":267,"connectEnd":299,"secureConnectionStart":277,"requestStart":299,"responseStart":418,"responseEnd":676,"domLoading":425,"domInteractive":1560,"domContentLoadedEventStart":1560,"domContentLoadedEventEnd":1606,"domComplete":1919,"loadEventStart":1919,"loadEventEnd":1920,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1529.5},{"name":"bigPipe.sidebar-id.end","time":1530.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1530.4000005722046},{"name":"bigPipe.activity-panel-pipe-id.end","time":1535.3000001907349},{"name":"activityTabFullyLoaded","time":1635.6999998092651}],"measures":[],"correlationId":"a4f237813f7af6","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":364,"dbReadsTimeInMs":58,"dbConnsTimeInMs":81,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}