SAP Knowledge Base Article - Public

2618065 - Hash or Pound Sign '#' not Recognized as Filter Option

Symptom

  • You create an extension field as an ID field in the Opportunity facet and enter the value '#'.
  • You search for an Opportunity that has an extension field with hash or pound sign '#'. But it is not possible to find it using the search bar in the work center Sales under the facet Opportunity.
  • You create an Odata query on the object for Opportunities, using the extension field as filter with the hash or Pound sign '#'. But the query does not find the Opportunities.

Environment

SAP Hybris Cloud for Customer Sales / Service

Reproducing the Issue

  1. Go to the Sales work center.
  2. Select the Opportunity facet.
  3. Select All Opportunities.
  4. Using the search field, search for the hash or pound sign '#'.

Cause

The hash or pound sign '#' is one of the token separators for the text indexing. Token separators are erased during the search.

Resolution

For any extension field you can use field types such as 'text' and subtype as 'short text' whose maximum length is '40'.
To enable the hash or pound sign '#', you can use 'medium text' whose maximum length is '80' or 'long text' whose maximum length is '120'.

Keywords

hash filter, Token separator, extension field, Opportunity, #, Hashtag, Pound sign, OData, ID field , KBA , such feld , BC-DWB-REP-EXT , Extensibility , HAN-DB-SCR , SAP HANA SQL Script , Problem

Product

SAP Cloud for Customer add-ins all versions