Question
TCS
IN
Last activity: 22 Mar 2017 0:21 EDT
Dynamic dropdown
We have a scenario in which two drop downs are there.
First dropdown is State (property name-State)
Second dropdown is City(property name-City). If I select one state I need to get corresponding Cities in that state. How to acheive this.
I tried to do this using report definition but I am not able to acheive this. Anyone please help me.
Here I am attaching the document.
Accepted Solution
Pegasystems Inc.
IN
Hi Vinod,
Here is a simple example. I have 2 pxDropDown controls. The first is showing a list of countries and the second a list of states / regions.
Here is the source configuration of the second drop down which is populated based on the selection in the first. I take the value from the first dropdown (actually the property is called .DropDown) and pass thjs as a parameter to the D_State data page that I am using as the source for this drop down.
Hi Vinod,
Here is a simple example. I have 2 pxDropDown controls. The first is showing a list of countries and the second a list of states / regions.
Here is the source configuration of the second drop down which is populated based on the selection in the first. I take the value from the first dropdown (actually the property is called .DropDown) and pass thjs as a parameter to the D_State data page that I am using as the source for this drop down.
The D_StateList data page has the selectedCountry parameter from above configured...
...which is in turn passed to the report defintion which is the source of my data page.
Parameter configured on report:
The report has a filter defined based on this parameter.
And the end result....
Please implement the above and let us know if face any issues.
Pegasystems Inc.
IN
The main point here is you to have to pass your parameter correctly to the second dropdown source so that it loads the correct data set accordingly.
B
IN
Hi Team,
I am getting duplicates in Country dropdown. Could you please help to remove duplicates in 1st dropdown?
Incessant Technologies
IN
Select Remove Duplicate rows check box in report definition Query Tab.
B
IN
I check that option(Remove Duplicate rows) as well in RD but still appears duplicates in Country dropdown.
Pegasystems Inc.
US
Hi Syam,
Your use case is explained in the Pega UI Specialist course in the PDN self study in the section "Common use cases for Cascading Controls". I had copied into the document and shared with you, kindly look into the use case and follow the same for your implementation.
Hope this might help you.
Regards
Mahesh
B
IN
Thank you all. I am able to get this with all your support. Thanks again!