Technical Articles
Using SQL to display Product Messages
In this blog post , I will demonstrate how to use SQL to display messages in Product. In order to use this feature I have imported a Custom table in CPQ and named it Processor_Mktshare.
I am using the same Product that I defined in my earlier blog post.
https://blogs.sap.com/2020/03/10/a-guide-to-set-up-configurable-products-in-sap-calliduscloud-cpq/
Our scenario is that when attribute value of Processor is selected in the Product Configuration Page in Catalog it should be able to display Marketshare of the Processor as a Message as shown below–
In order to achieve the above shown functionality we will write a SQL query which will fetch the value of Market share from the Custom Table for the Attribute value of Processor.
We will define this query in Product Messages under Rules and Messages Tab of Product as shown below–:
We will define Condition and Message as below–:
The above shown Condition returns the value of Attribute Chipset that we choose in Config Page of Product.
As a result of above query we can display Marketshare percentages in Product Config page based on our selection of Processor–:
Hope this helps.