Searches Fail Using the SortSpec Parameter After Indexer Changed From Verity To Database.Fulltext

(Doc ID 1240203.1)

Last updated on FEBRUARY 08, 2018

Applies to:

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


The Content Server was originally configured to use Verity as the search indexer. Searches were done with the added SortSpec parameter:

&SortSpec=dInDate ASC dSecurityGroup ASC

The search indexing was changed to DATABASE.FULLTEXT. Now an error occurs when doing searches:

Unable to retrieve search results. csSearchInvalidOrderByClause(dInDate ASC dSecurityGroup)


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