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