Searches Fail Using the SortSpec Parameter After Indexer Changed From Verity To Database.Fulltext (Doc ID 1240203.1)

Last updated on MAY 10, 2023

Applies to:

Oracle WebCenter Content - Version 10.0 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)

	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

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