Using SQL to display Product Messages

[vraoid]

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.

In the Message Text the query compares the value of Attribute Chipset and based on that Selects the value of the Column Marketshare from table Processor_Mktshare.

As a result of above query we can display Marketshare percentages in Product Config page based on our selection of Processor--:

 

 

 

 

Hope this helps.