Filtered By Custom Property Using Nr property On The Search Endpoint Did Not Work. (Doc ID 2588609.1)

Last updated on JUNE 15, 2022

Applies to:

Symptoms

On : NA version, Store Administration

Filtered by Custom Property using Nr property on the Search Endpoint did not work.

Filtered by custom property product.msiItemBackendStatus using Nr property on search endpoint did not work.

Following the current configuration on gsadmin/v1/cloud/attributes/system:

"product.msiItemBackendStatus": {
  "ecr:lastModifiedBy": "occ_xxx@test2.com",
  "isRecordFilterable": true,
  "propertyDataType": "ALPHA",
  "ecr:lastModified": "2019-09-02T19:45:32.842Z",
  "mergeAction": "UPDATE",
  "ecr:createDate": "2019-09-02T13:45:32.846-06:00",
  "isRecordSearchEnabled": true,
  "ecr:type": "property"
}

After updating the configuration, ran the index baseline.

Using Nr property for filter on search, below are all options tried:

https://<DOMAIN>/ccstoreui/v1/search?Nr=product.msiItemBackendStatus:04C
https://<DOMAIN>/ccstoreui/v1/search?Nr=FILTER(product.msiItemBackendStatus:04C)
https://<DOMAIN>/ccstoreui/v1/search?Nr=OR(product.msiItemBackendStatus:04C)
https://<DOMAIN>/ccstoreui/v1/search?Nr=AND(product.msiItemBackendStatus:04C)

Made these changes based on this Oracle Community documentation:

https://community.oracle.com/groups/oracle-commerce-cloud-group/blog/2017/03/23/search-configuration-advanced-topics-review?customTheme=mosc

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.