Uploaded image for project: 'i2b2 Web Client'
  1. i2b2 Web Client
  2. WEBCLIENT-292

Cannot use single quote in Find Terms

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 1.7.12
    • None
    • None
    • Find by Name

    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"

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jklann Jeffrey Klann added a comment -
          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.
          jklann Jeffrey Klann added a comment - 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.
          jklann Jeffrey Klann added a comment -
          This has been fixed. Tested in MSSQL. Needs testing on other dbs.
          jklann Jeffrey Klann added a comment - This has been fixed. Tested in MSSQL. Needs testing on other dbs.
          rm302 Reeta Metta added a comment -
          doesn't seem to work on postgressSQL
          rm302 Reeta Metta added a comment - doesn't seem to work on postgressSQL
          jklann Jeffrey Klann added a comment -
          Single word crohn's doesn't work in postgres, two words does now
          jklann Jeffrey Klann added a comment - Single word crohn's doesn't work in postgres, two words does now
          jklann Jeffrey Klann added a comment -
          Please retest crohn's in postgres (one word with a single quote).
          jklann Jeffrey Klann added a comment - Please retest crohn's in postgres (one word with a single quote).
          rm302 Reeta Metta added a comment -
          postgres issue
          rm302 Reeta Metta added a comment - postgres issue
          jklann Jeffrey Klann added a comment -
          This is finally fixed in Postgres. Containing, Exact, Starting, Ending should all work in Find Terms with a single quote.
          jklann Jeffrey Klann added a comment - This is finally fixed in Postgres. Containing, Exact, Starting, Ending should all work in Find Terms with a single quote.

          People

            rm302 Reeta Metta
            sthorson Stacy Thorson
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: