[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. |