Search Results aren't sorted correctly after metadata field (sort field) has been updated (Doc ID 2168953.1)

Last updated on AUGUST 05, 2016

Applies to:

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

Symptoms

Search results aren't 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. Checkin 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

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