Type:
Bug
Status:
Closed
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
i2b2 Sponsored Project/s:
Testing Notes:
Hide
03/18/2015: Tested with the latest Web Client build and it is now working correctly. I am able to do a search when the category is defined as "Any Category" which is the default.
Browsers Tested: Chrome, Firefox, Internet Explorer, Safari
Show
03/18/2015: Tested with the latest Web Client build and it is now working correctly. I am able to do a search when the category is defined as "Any Category" which is the default.
Browsers Tested: Chrome, Firefox, Internet Explorer, Safari
In the new Find for Previous Queries you are not able to do a search if "Any Category" is selected. The following error is returned in the XML message received from the CRC.
<condition type="ERROR">PreparedStatementCallback; invalid ResultSet access for SQL [select * from ( select query_master_id,name,user_id,group_id,create_date,delete_date,null as request_xml,delete_flag,generated_sql, null as i2b2_request_xml, master_type_cd, null as plugin_id from i2b2demodata.qt_query_master where LOWER(name) like ? and delete_flag = ? order by create_date desc ) where rownum <= 20]; nested exception is java.sql.SQLException: Invalid column index</condition>
If the user must select a category to perform a search then Any Category should not be available for selection. It can appear as a label so users know they need to select something.
A separate issue will be submitted to address the fact that the user never receives an error message. The only way to know there is an error is to look at the xml messages.
related to
WEBCLIENT-80
New view: Find Previous Queries
Closed
{"report":{"fcp":2239.300000000745,"ttfb":764.2000000029802,"pageVisibility":"visible","entityId":10389,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"6d6dfbf5-05b0-43a6-b28c-4f01b91805ff","navigationType":0,"readyForUser":2332.400000002235,"redirectCount":0,"resourceLoadedEnd":2521.2000000029802,"resourceLoadedStart":773.1000000014901,"resourceTiming":[{"duration":924.1999999992549,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":773.1000000014901,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":773.1000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1697.300000000745,"responseStart":0,"secureConnectionStart":0},{"duration":926.3999999985099,"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":773.4000000022352,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":773.4000000022352,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1699.800000000745,"responseStart":0,"secureConnectionStart":0},{"duration":1095,"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":773.5,"connectEnd":1760.1000000014901,"connectStart":1732,"domainLookupEnd":773.5,"domainLookupStart":773.5,"fetchStart":773.5,"redirectEnd":0,"redirectStart":0,"requestStart":1760.300000000745,"responseEnd":1868.5,"responseStart":1783.5,"secureConnectionStart":1747.300000000745},{"duration":1092.800000000745,"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":773.6000000014901,"connectEnd":1761.6000000014901,"connectStart":1736,"domainLookupEnd":773.6000000014901,"domainLookupStart":773.6000000014901,"fetchStart":773.6000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":1761.6000000014901,"responseEnd":1866.4000000022352,"responseStart":1784.7000000029802,"secureConnectionStart":1749},{"duration":1019,"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":773.9000000022352,"connectEnd":1773.300000000745,"connectStart":1742.9000000022352,"domainLookupEnd":773.9000000022352,"domainLookupStart":773.9000000022352,"fetchStart":773.9000000022352,"redirectEnd":0,"redirectStart":0,"requestStart":1773.300000000745,"responseEnd":1792.9000000022352,"responseStart":1790.6000000014901,"secureConnectionStart":1758.800000000745},{"duration":1042.4000000022352,"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":774,"connectEnd":1784.6000000014901,"connectStart":1754.2000000029802,"domainLookupEnd":774,"domainLookupStart":774,"fetchStart":774,"redirectEnd":0,"redirectStart":0,"requestStart":1792.2000000029802,"responseEnd":1816.4000000022352,"responseStart":1813.2000000029802,"secureConnectionStart":1769.300000000745},{"duration":1072.199999999255,"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":774.1000000014901,"connectEnd":1821.5,"connectStart":1792.800000000745,"domainLookupEnd":774.1000000014901,"domainLookupStart":774.1000000014901,"fetchStart":774.1000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":1823.5,"responseEnd":1846.300000000745,"responseStart":1844.4000000022352,"secureConnectionStart":1807.7000000029802},{"duration":947.5999999977648,"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":774.2000000029802,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":774.2000000029802,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1721.800000000745,"responseStart":0,"secureConnectionStart":0},{"duration":1092.6000000014901,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":774.3000000007451,"connectEnd":1845.1000000014901,"connectStart":1815,"domainLookupEnd":774.3000000007451,"domainLookupStart":774.3000000007451,"fetchStart":774.3000000007451,"redirectEnd":0,"redirectStart":0,"requestStart":1848,"responseEnd":1866.9000000022352,"responseStart":1864.6000000014901,"secureConnectionStart":1828.2000000029802},{"duration":919.6999999992549,"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":809.3000000007451,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":809.3000000007451,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1729,"responseStart":0,"secureConnectionStart":0},{"duration":1063.800000000745,"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":809.5,"connectEnd":1857,"connectStart":1822.4000000022352,"domainLookupEnd":809.5,"domainLookupStart":809.5,"fetchStart":809.5,"redirectEnd":0,"redirectStart":0,"requestStart":1857.4000000022352,"responseEnd":1873.300000000745,"responseStart":1872.1000000014901,"secureConnectionStart":1843.9000000022352},{"duration":1525.699999999255,"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":818.9000000022352,"connectEnd":2327.800000000745,"connectStart":2301.2000000029802,"domainLookupEnd":818.9000000022352,"domainLookupStart":818.9000000022352,"fetchStart":818.9000000022352,"redirectEnd":0,"redirectStart":0,"requestStart":2328.60000000149,"responseEnd":2344.60000000149,"responseStart":2343.900000002235,"secureConnectionStart":2314.2000000029802},{"duration":1697.6000000014901,"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":823.6000000014901,"connectEnd":2504.400000002235,"connectStart":2474.800000000745,"domainLookupEnd":823.6000000014901,"domainLookupStart":823.6000000014901,"fetchStart":823.6000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":2504.400000002235,"responseEnd":2521.2000000029802,"responseStart":2520.2000000029802,"secureConnectionStart":2489.60000000149},{"duration":390.8999999985099,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":2129.10000000149,"connectEnd":2499.900000002235,"connectStart":2473.900000002235,"domainLookupEnd":2129.10000000149,"domainLookupStart":2129.10000000149,"fetchStart":2129.10000000149,"redirectEnd":0,"redirectStart":0,"requestStart":2500,"responseEnd":2520,"responseStart":2519.300000000745,"secureConnectionStart":2487.10000000149}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":696,"connectEnd":726,"secureConnectionStart":711,"requestStart":726,"responseStart":765,"responseEnd":823,"domLoading":771,"domInteractive":2563,"domContentLoadedEventStart":2564,"domContentLoadedEventEnd":2625,"domComplete":3045,"loadEventStart":3045,"loadEventEnd":3046,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2532.300000000745},{"name":"bigPipe.sidebar-id.end","time":2533.400000002235},{"name":"bigPipe.activity-panel-pipe-id.start","time":2533.60000000149},{"name":"bigPipe.activity-panel-pipe-id.end","time":2534.7000000029802},{"name":"activityTabFullyLoaded","time":2639.900000002235}],"measures":[],"correlationId":"4df942e04c298f","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":82,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}