[MGNLPER-217] Can not search with single quote ' Created: 15/Jan/24 Updated: 15/Jan/24 |
|
| Status: | Open |
| Project: | Periscope |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Neutral |
| Reporter: | Minh Nguyen | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
| Template: |
|
| Acceptance criteria: |
Empty
|
| Task DoD: |
[ ]*
Doc/release notes changes? Comment present?
[ ]*
Downstream builds green?
[ ]*
Solution information and context easily available?
[ ]*
Tests
[ ]*
FixVersion filled and not yet released
[ ] 
Architecture Decision Record (ADR)
|
| Bug DoR: |
[ ]*
Steps to reproduce, expected, and actual results filled
[ ]*
Affected version filled
|
| Description |
|
Description: AC: search result should return if query includes single quote ' Dev Note: 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')) |