Details
-
Bug
-
Resolution: Fixed
-
Neutral
-
2.2.6
-
None
-
None
Description
Steps to reproduce
- Define a basic endpoint like the following:
class: info.magnolia.rest.delivery.jcr.v2.JcrDeliveryEndpointDefinition workspace: website bypassWorkspaceAcls: true depth: 5 nodeTypes: - mgnl:page - mgnl:area childNodeTypes: - mgnl:component
- On the website workspace, create two pages, test and Test.
- Perform the rest request
SELECT t.* FROM [nt:base] AS t WHERE ((t.[jcr:primaryType] = 'mgnl:page') OR (t.[jcr:primaryType] = 'mgnl:area')) AND (LOWER(LOCALNAME(t)) like 'Test')
- Check no results are returned
Expected results
Only the Test page is returned
Actual results
No results are returned
Workaround
N/A
Development notes
Performing the request
SELECT t.* FROM [nt:base] AS t WHERE ((t.[jcr:primaryType] = 'mgnl:page') OR (t.[jcr:primaryType] = 'mgnl:area')) AND (LOWER(LOCALNAME(t)) like 'test')
also returns incorrect values, instead of returning only the test page, it returns both, Test and test:
{
"results": [
{
"@name": "Test",
"@path": "/Test",
"@id": "093dae11-6506-4a7b-961f-3af35fcb58ac",
"@nodeType": "mgnl:page",
"title": "Test with capital",
"hideInNav": "false",
"noCache": "false",
"@nodes": []
},
{
"@name": "test",
"@path": "/test",
"@id": "ab9f7eb7-450a-41d6-9e99-98dd9b5066b6",
"@nodeType": "mgnl:page",
"title": "test in lowercase",
"hideInNav": "false",
"noCache": "false",
"@nodes": []
}
]
}
Full details and example on support ticket 12890.
Checklists
Acceptance criteria