How to Remove repeating values in dropdown by using Data page source is report definationHi

User Experience
,
1

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.

.

I have insert the below records.docx (355 KB)

2

@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.

3

@Niladri

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.

4

@sudhakarj3480

Have 2 data page to achieve this requirement.

  1. 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.
  2. 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..

5

@GunaSekaran_B Thanks .