SAP Knowledge Base Article - Public

2716630 - Conditions Limit For Queries In Advanced Search

Symptom

In Advanced Search of a given OWL (Object Work List) you want to do a big query adding over 1000 conditions, but when reaching the 1000th when you click on the "+" button it doesn't create new condition fields anymore.

Environment

SAP Hybris Cloud For Customer

Reproducing the Issue

Scenario 1:

  1. Go to any Work Center (e.g. Customer, Service, etc.).
  2. Click on the desired Work Center view (e.g. Accounts, Tickets, etc.).
  3. Click on the Advanced Search icon.
  4. Click on the More Options button of the field you want to query.
  5. By clicking on the "+" button add 1000 conditions.
  6. When you click to add the 1000th condition it won't create any further.

Scenario 2:

  1. Go to any Work Center (e.g. Customer, Service, etc.).
  2. Click on the desired Work Center view (e.g. Accounts, Tickets, etc.).
  3. Click on the Advanced Search icon.
  4. Using Google Chrome browser paste over 1000 values in any field which allow you to add conditions (This will automatically create 1000 conditions for each entry pasted).
  5. Click in the More Options of the desired field and you'll already have the conditions created.
  6. When you click to add the 501th condition it won't create any further.

Cause

The maximum number of conditions allowed in the Advanced Search - More Options of fields is 1000.

Resolution

This is the standard behavior of the system.


If you need this functionality urgently you may contact your implementation manager to help with such request or approach directly the SAP Cloud Service Center.


You can find more details about the services offered by Cloud Service Center on https://www.sap.com/services/application-development.html . You can contact Cloud Service Center as follows:


1. If you are a partner: please use cloudsolutionpartner@sap.com or the Partnerfinder.
2. If you are a customer: please use the little blue box “Contact Us” shown on the very right hand side of https://www.sap.com/services/application-development.html, choose “Contact Us”, choose “Services”, choose “SAP Custom Development” and complete the page.
Note: The services of the SAP Cloud Service Center will be charged as packaged services based on fixed prices.

An alternative option may be to check the SAP Customer Influencer Site to submit an idea: https://influence.sap.com/SAPCloudforCustomer

Keywords

Conditions; Advanced Search; More Options; Query; , KBA , AP-RC-MOB-UIF , Responsive UI , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions