Cascading Drop Down in Pega
Hi all, In this Post we will see how to create Cascading Drop down using Report Definition in pega.
Below is the list of rule I created to implement this.
- Local Data Table
- Two Report Definition
- Flow
- Flow Action
- Section
- Two Property in Data Class and Two Property in Work Class.
I created a Class Named Teky-PeopleNe-Data-ProductInfo . In this class I created two property named ProductName and ProductPrice .
I created ProductName as Key for this table and added some sample data.
Now our concept is on choosing the ProductName the corresponding ProductPrice we have to display in next drop down. So I created two Report Definition in Teky-PeopleNe-Data-ProductInfo class.
In the below report definition we get all ProductName which is not null.
In the below Report Definition we get the ProductPrice which corresponding to the ProductName
I created a flow in Work Class.
I created a section with two fields one for ProductName and another one for ProductPrice. Source for this property is a report definition.
ProductName property is mapped to source ReportDefinition named GetProductName
Add event for ProductName property as OnChange -> Post Value, if we are not using this event then changed value will not update to clipboard. So we are using Post value to update the changed value to clipboard. So we can pass Changed Property value to Next ReportDefinition named "GetProductPrice"
ProdPrice property is mapped to source ReportDefinition named GetProductPrice . Parameter for this report definition is ProductName.
Now lets check drop down value by running the flow.
Now price Corresponding to Samsung Lite is displaying in ProductPrice drop down.
Lets change another one value and check in Product Price.
Now you can see the value is changed in Product Price also.
I hope you understand this post😊
ReplyDeleteEnjoyed reading the article above, really explains everything in detail, the article is very interesting and effective. Thank you and good luck for the upcoming articles pega certification
thanks for giving good information we can thought your websitepega online traning
ReplyDeleteyou forgot screenshots of how to edit parameters tab, please add it, otherwise super article.
ReplyDeleteYeah i forget to add that screenshot. Without specifying the parameter in parameter tab also the report definition will work in that scenario. Incase paramter value is not passed dynamically then we can add that parameter in report definition. Thank u.
DeleteHi Bharathan,
ReplyDeleteThanks for giving cascading example information.
will you post same cascading example by using data pages which is going to select Multiple parameters? (As per your example Replace Product Name as Countries, Product Price as States then While it selected India as a country and it has to show all the states that belongs to India)
Thanks in Advance
Hi Vijay Bhaskar,
DeleteI think With Data Page alone we can't able to achieve this.
We have to create 2 Data Page, Assume
D_GetCountryList
Inside this data page we have to map a report definition
to get the distinct Country in table.
In Work class section , we have to use a country drop down
property for this property we have to provide the created
data page as source.
D_GetStateList
Inside this data page we have to map a report definition
to get distinct state.
We can use Keyed Data Page concept to get the list of
State based on selected country.
Let me know if you want to create this as a post.
Thanks,
Bharathan.
Hi Bharathan,
DeleteThanks for the information,
If possible please create this as a post as you mentioned earlier
Thanks in advance,
Palle Vijay Bhaskar Reddy
Hey Bharathan,
DeleteA post would be really helpful, I love your content!