2618065 - Hash or Pound sign (#) not recognized as filter option

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 are searching the opportunity that has an extension field with Hash or Pound sign. 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 (#).
  • The query does not find the opportunities either.

Environment

SAP Hybris Cloud for Customer

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 separator 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 and "LONG TEXT" whose maximum length is 120 as well.

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 Hybris Cloud for Customer all versions