Cmis Query Fails with Double Order by Clause in Content Presenter Task Flow

(Doc ID 1356261.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle WebCenter - Version: 11.1.1.5.0 and later   [Release: 11g 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://<host>:<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://<host>:<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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms