SAP Knowledge Base Article - Public

3386150 - Quote List Filter returning only quotes that starts with search string

Symptom

Quote List Filter returning only quotes that starts with search string even though in Preview are shown Quotes that contains search string. 

Environment

SAP Sales Cloud CPQ 

Reproducing the Issue

  1. Go to Load Quote page;
  2. Click on Filter button;
  3. On Quote Name field, set a search string;
  4. Only Quotes that begin with the search string are returned, even though preview shows quotes that contains search string.

Cause

Expected Behavior.

Resolution

  • How the Filter works, using Quote Name Field as an example:
    • When search field is created (Setup -> Quotes -> Search Fields), and 'like' is selected for the operator, SQL query will be:  select * from table where columnName like 'value%';
      • It will be returned quotes that starts with *value*;
    • When using the Quote List Filter, if we use as search string '%value%', query will look like: select * from table where columnName like '%value%%' , returning quotes that contain *value* in its name;
  • Currently on CPQ there are no wildcards available to use in standard Search Field.(%, _, ^, [],-,{}, and so on).

See Also

Keywords

Quote List, Search, Wildcards, Load Quote, Filter, CPQ , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , How To

Product

SAP CPQ 2023