Uploaded image for project: 'Periscope'
  1. Periscope
  2. MGNLPER-217

Can not search with single quote '

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Neutral
    • None
    • None
    • None

    Description

      Description:
      We are not able to search for "Daniela D'Andrea" via search bar.
      some variant like "D'Andrea", DAndrea also returns no result.

      AC: search result should return if query includes single quote '

      Dev Note:
      Node saved as:
      /ROMDAA_/ROMDAA/lastName=D'Andrea
      /ROMDAA_/ROMDAA/firstName=Daniela

      generated query below returning no result (from JcrSearchResultSupplier.sanitizeQueryString:

      SELECT * FROM [mgnl:internalProfile] AS t WHERE t.[jcr:primaryType] = 'mgnl:internalProfile' AND (LOWER(LOCALNAME(t)) LIKE '%d\''andrea%' OR CONTAINS(t.*, 'd\''andrea'))
      

      I found workaround by removing \

      SELECT * FROM [mgnl:internalProfile] AS t WHERE t.[jcr:primaryType] = 'mgnl:internalProfile' AND (LOWER(LOCALNAME(t)) LIKE '%d''andrea%' OR CONTAINS(t.*, 'd''andrea'))
      


      Checklists

        Acceptance criteria

        Attachments

          Activity

            People

              Unassigned Unassigned
              minh.nguyen Minh Nguyen
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Checklists

                  Bug DoR
                  Task DoD