My Oracle Support Banner

WebCenter Content (WCC) Search Results are not Sorted Correctly after a Metadata Field (Sort Field) has been Updated (Doc ID 2168953.1)

Last updated on DECEMBER 18, 2023

Applies to:

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

Symptoms

Search results are not sorted as expected.  A custom metadata field (e.g., xSequence) is used to sort content.  After the metadata field was updated, the search results was not sorted to reflect new values unless the search cache entry for the search was cleared.

Changes

Performed the following to use a custom metadata field that can be used for sorting:

1.Add Sequence metadata field

2. Check-in content items with the following metadata values

3. Change Layout to Top Menus in user profile page so we can specify xSequence as the sort field in GET_SEARCH_RESULTS

4. Run a search. In the URL, change the SortField parameter to use the new custom metadata field.  Example shown below.
http://<host>:<port>/cs/idcplg?IdcService=GET_SEARCH_RESULTS&QueryText=dDocTitle+<starts>+`wiki`&searchFormType=standard&SearchQueryFormat=UNIVERSAL&ftx=&AdvSearch=True&folderChildren=&ResultCount=20&SortField=xSequence&SortOrder=Asc

5. Update the sequence metadata field and run searches. The searches aren't sorted to reflect new values.

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
Changes
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.