Cmis Query Fails with Double Order by Clause in Content Presenter Task Flow (Doc ID 1356261.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Symptoms

The following exception is raised when specifying multiple sort parameters as the datasource value for a Content Presenter task flow:

The following task flow parameters can be used as an example:


datasourceType=${'dsTypeQueryExpression'}
datasource=${'SELECT * FROM cmis:document WHERE cmis:name LIKE \'a\' ORDER BY cmis:objectId,cmis:creationDate'}
templateCategory=${'oracle.webcenter.content.templates.default.list.simple'}


The same problem can be easily reproduced with CMIS Browser. The following query with a single sort parameter works fine:

http://<HOSTNAME>:<PORT>/rest/api/cmis/query/q/ucm?q=SELECT%20*%20FROM%20cmis:document%20WHERE%20cmis:name%20LIKE%20%27a%%27%20ORDER%20BY%20cmis:creationDate

but the following query with 2 sort parameter fails:

http://<HOSTNAME>:<PORT>/rest/api/cmis/query/q/ucm?q=SELECT%20*%20FROM%20cmis:document%20WHERE%20cmis:name%20LIKE%20%27a%%27%20ORDER%20BY%20cmis:creationDate,cmis:name

Steps to reproduce
==================
1- Open JDeveloper
2- Create a Webcenter Portal App using the template
3- Add Content Repository (UCM) connection to the project
4- Add content presenter task flow to the home.jspx
5- Set this taskflow parameters:

datasourceType=${'dsTypeQueryExpression'}
datasource=${'SELECT * FROM cmis:document WHERE cmis:name LIKE \'a\' ORDER BY cmis:objectId,cmis:creationDate'}
templateCategory=${'oracle.webcenter.content.templates.default.list.simple'}
6- Run the project and you will see an error stack trace at your Weblogic console on JDeveloper

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.