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
- Go to Load Quote page;
- Click on Filter button;
- On Quote Name field, set a search string;
- 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;
- 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%';
- 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