SAP Knowledge Base Article - Public

2732255 - Filtering Accounts by City Using a Semicolon (Format A;B) Does not Return the Expected Results

Symptom

When filtering Accounts, it is possible use the format "A;B" for the columns of the Object Worklist.

However this method is not working for the field City: the query returned is empty.

Environment

SAP HYBRIS CLOUD FOR CUSTOMER

Reproducing the Issue

For example, you wish to filter Accounts by the cities of Hamburg and Berlin:

  1. Go to the Customers workcenter.
  2. Go to the Accounts view.
  3. Click on the city column header.
  4. Type "Ber;Ham" in order to return Berlin and Hamburg city.
  5. Click Enter

Results: The query does not return the corresponding Accounts.

Cause

In Accounts, City is a field of type Text. It required the suggestion of the search value or part of this value with an asterisk.

Resolution

It is the expected system behaviour.

You will need to explicitly use the asterisk, like Berl*;Ham* , to find the related Accounts.

Keywords

Search with semicolon, ";". , KBA , LOD-CRM-ACC , Account , Problem

Product

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