[WEBCLIENT-292] Cannot use single quote in Find Terms Created: 13/Aug/19 Updated: 02/Oct/19 Resolved: 02/Oct/19 |
|
Status: | Closed |
Project: | i2b2 Web Client |
Component/s: | None |
Affects Version/s: | None |
Fix Version/s: | 1.7.12 |
Type: | Bug | Priority: | Minor |
Reporter: | Stacy Thorson | Assignee: | Reeta Metta |
Resolution: | Fixed | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Sprint: | v1712.1 |
i2b2 Feature/s: |
Find by Name
|
Participant/s: |
Description |
In the web client, in Find Terms, trying to search for a term that contains a single quote (such as Crohn's Disease) results in a long delay then an eventual error message, "ERROR: Error message delivered from the remote server You may wish to retry your last action"
|
Comments |
Comment by Jeffrey Klann [ 05/Sep/19 ] |
This was an issue only if searching for multiple words where one had a single quote, due to the way parameters were being passed to SQL. |
Comment by Jeffrey Klann [ 05/Sep/19 ] |
This has been fixed. Tested in MSSQL. Needs testing on other dbs. |
Comment by Reeta Metta [ 13/Sep/19 ] |
doesn't seem to work on postgressSQL |
Comment by Jeffrey Klann [ 19/Sep/19 ] |
Single word crohn's doesn't work in postgres, two words does now |
Comment by Jeffrey Klann [ 24/Sep/19 ] |
Please retest crohn's in postgres (one word with a single quote). |
Comment by Reeta Metta [ 27/Sep/19 ] |
postgres issue |
Comment by Jeffrey Klann [ 01/Oct/19 ] |
This is finally fixed in Postgres. Containing, Exact, Starting, Ending should all work in Find Terms with a single quote. |