Choosing "Ascending" Sort In Experience Manager or Rule Manager Spotlight Cartridge Results in a "Descending" Sort (Doc ID 1911644.1)

Last updated on NOVEMBER 12, 2015

Applies to:

Oracle Commerce Guided Search / Oracle Commerce Experience Manager - Version 11.0 to 11.1 [Release 11.x]
Information in this document applies to any platform.

Symptoms

Choosing "ascending" sort in 11.0.0 or 11.1.0 Experience Manager or Rule Manager records spotlight cartridge results in a "descending" sort instead.

Reproducible Steps:

- Go to Experience Manager/Rule Manager
- Add a spotlight cartridge
- Choose “Records selected by query”
- Click “Edit query"
- Designate a field that is sorted ascending in the “Sort by” section (ex: P_rank ascending)
- Click Save Selection
 
The query that gets saved into the Spotlight box is: P_rank descending.

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