Catalog Search doesn't support the search criteria on CATALOG_CREATE (Doc ID 2578827.1)

Last updated on MAY 02, 2023

Applies to:

Symptoms

1. Run the following code:
   
   Calendar cal = Calendar.getInstance();
   cal.add(Calendar.DAY_OF_MONTH, -7);
   
   CatalogService catService = client.getService(CatalogService.class);
   SearchCriteria cs1 = new SearchCriteria(CatalogConstants.CATALOG_CREATE, cal.getTime(), Operator.GREATER_EQUAL);
   SearchCriteria cs2 = new
   SearchCriteria(CatalogConstants.CATALOG_ENTITY_TYPE, "Entitlement", Operator.EQUAL);
   SearchCriteria cs3 = new SearchCriteria(cs1, cs2, Operator.AND);
   List<Catalog> cats = catService.findCatalog(cs3, 0, 100, CatalogConstants.CATALOG_ENTITY_NAME, SortCriteria.ASCENDING);
2. It returns all the Entitlements without the consideration of the CATALOG_CREATE search criteria.

Changes

Cause

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