My Oracle Support Banner

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

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle WebCenter Portal - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms


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



oracle.webcenter.content.integration.UnsupportedRepositoryOperationException: Jul 25, 2011 9:16:34 AM oracle.webcenter.content.integration.spi.ucm.search.SearchOpUtils processSortCriteria
SEVERE: Only one sort criteria is supported.
...


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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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