ListProducts Endpoint Filtering And Sorting Issues with Q Filter Specified

(Doc ID 2312804.1)

Last updated on OCTOBER 13, 2017

Applies to:

Oracle Commerce Cloud Service - Version N/A and later
Information in this document applies to any platform.


Two issues have been observed with the behavior of the listProducts endpoint:

Q filter issue

In 17.2, the listProducts endpoint with the q filter and category ID parameter included in the URL will return results that are not filtered, and the count of query results is incorrect. For instance, with q=status='A' (as used in the following URL) will return items whose status value is not equal to 'A':

Sorting issue

The listProducts endpoint with q filter applied returns results that are not sorted in the order specified by users of the Admin user interface.




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