Cannot Sort on factorQuantitySold30d or quantitySold30d Using the /search Endpoints and ns Param (Doc ID 2802505.1)

Last updated on SEPTEMBER 12, 2021

Applies to:

Symptoms

A customer may be attempting to sort using product.analytics.quantitySold30d or quantitySold30d, as part of the 'Ns' parameter, but results are not being sorted as expected in the results from the /search endpoint.

Examples: (Both of these requests, would return the same sorted results, even though the fields to sort on are different fields, and the values in these fields varied during this testing (Meaning it should produce different results, as you sort on these different fields but it will not appear to be doing so correctly)

       https://www.<CUSTOMER-SITE>.com.br/ccstoreui/v1/search?N=2994084186&searchType=simple&No=0&Nrpp=12&Ns=product.analytics.factorQuantitySold30d|1&visitorId=null&visitId=null&language=pt_BR
       https://www.<CUSTOMER-SITE>.com.br/ccstoreui/v1/search?N=2994084186&searchType=simple&No=0&Nrpp=12&Ns=product.analytics.quantitySold30d|1&visitorId=null&visitId=null&language=pt_BR

Changes

 N/A

Cause

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