Question
Cognizant Technology
IN
Last activity: 23 Dec 2021 1:02 EST
How to Remove repeating values in dropdown by using Data page source is report definationHi
Hi Team ,
Please find the attachment for document reference
I have configured data page in drop down and data page source is report definition ,how to remove repeating values in ui. could you please help do you any solution.
My requirement is like when we select region next drop down we will populated region All states under region
|
Region |
State |
|
South |
Ap |
|
South |
Ts |
|
North |
Mr |
|
North |
UT |
First drop down we will select South next dropdown will populate AP and Ts , but I do not want to repeat region values in first dropdown.
.
Accepted Solution
Updated: 23 Dec 2021 1:02 EST
Lventur
IN
Have 2 data page to achieve this requirement.
- Data Page Name = D_FetchRegionInfo. For this data page have report definition as source and in report definition column just have Region alone and make sure you have enable remove duplicate option in report definition. If you enable remove duplicates option then pega will not display duplicate region values in drop-down.
- Data Page Name = D_FetchStateInfo. For this data page have report definition as source and have input parameter as Region. Pass the region value which user selecting in first drop-down as input to second data page sourced drop-down field, then pega will fetch the display the state which belongs to the selected region.
Please try with this configuration, it should work..
TCS
US
@sudhakarj3480 simple way would be passing region as parameter to the next state drop down source d page. 2 drop down field source with d page.
Cognizant Technology
IN
But first dropdown all region values come ,so i do not want to populate all region and i want to populate south and next dropdown state will populate Ap and Ts
ex:
First drop down -- South
second drop down - Ap,Ts like ......
how to configure drop downs.
Accepted Solution
Updated: 23 Dec 2021 1:02 EST
Lventur
IN
Have 2 data page to achieve this requirement.
- Data Page Name = D_FetchRegionInfo. For this data page have report definition as source and in report definition column just have Region alone and make sure you have enable remove duplicate option in report definition. If you enable remove duplicates option then pega will not display duplicate region values in drop-down.
- Data Page Name = D_FetchStateInfo. For this data page have report definition as source and have input parameter as Region. Pass the region value which user selecting in first drop-down as input to second data page sourced drop-down field, then pega will fetch the display the state which belongs to the selected region.
Please try with this configuration, it should work..
Updated: 23 Dec 2021 1:02 EST
Cognizant Technology
IN
@Gunasekaran Baskaran Thanks .