Question


Csc
IN
Last activity: 14 Jun 2021 7:38 EDT
Dropdown values fetched from database are not loading when placing in a repeating dynamic layout.
Hi,
Dropdown values that are fetched from data base are not loading when placing in a repeating dynamic layout.
I've 2 dropdowns in my repeating layout, when I use the drop down with prompt list, I'm getting the results in the dropdown. Whereas, if I get the values from DB table using datapage I'm not getting the results and showing empty dropdown values.
Could you please help me. Attaching the screen shot contains dropdowns 1 and 2.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!


Coforge DPA
GB
Hi
Can you share. screenshots of the configuration of drop downs?
Regards
Bhavya


Csc
IN
I've attached the screenshots. Pls review and advise.


Coforge DPA
GB
Hi
Based on the screenshots ,source for the drop down should be "Clipboard Page" under "List source". You have not mentioned that so its not taking the reference.
Also it would be better if you use a Data page to get the drop down instead of getting it from activity.
Regards
Bhavya


Csc
IN
I'm not using the data/clipboard page for both states & Industry dropdowns but fetching the results properly for states.
They are fetched by using an activity that I shown.


Coforge DPA
GB
Hi
It doesnt work this way unfortunately :)
So your activity is doing an Obj-Browse and the data exists in "DisasterUWRulePage". Your value would be under pxResults of that page i.e. DisasterUWRulePage.pxResults().DisasterUWrules_industry. You can check the clipboard to confirm this.
Since your property exist in the Pagelist, you would need to give "DisasterUWRulePage.pxResults" as a Source for the drop down and then specify "Property for Value" as ".DisasterUWrules_industry".
Then your drop down will be getting populated. Also dont forget to mention the pages in Peges and Classes tab.
Hope this helps.
Regards
Bhavya
Updated: 14 Jun 2021 7:38 EDT


Pegasystems Inc.
IN
Did you check in the clipboard if the Data page has values?
Are those cascading dropdowns, based on the section of 1st dropdown, 2nd dropdown values are populated? If yes, did you configure the refresh section on the Dropdown 1, and did you check if 1st dropdown value is present on the clipboard?


Csc
IN
Updated: 14 Jun 2021 7:38 EDT


Pegasystems Inc.
IN
Are you looking for the value which is populated from the Obj-Browse for Industry, if yes I suspect that these values which are returning are not present in the local list as it does for state property.


Pegasystems Inc.
IN
Hi,
Can you try running the data page and check if the results are returned. And could you please share the screenshots of the Data page


Blue Rose Technologies
DE
Hi,
Just to get some clarity, where you are populating Industry property with list of values from Data Page?
If you are already not populating Industry property with a list of values, isn't it better we use Data page as the List Source of drop down?


Pegasystems Inc.
Hi ,
Here,source for the drop down should be "Clipboard Page" under "List source". You are not defined any one of the source.
can you please define the source for "Dropdown" as per your design.
if possible, change the "Dropdown" control to "Text Input" and check the Run time. You will get the results with "Text Input".
If you want to display the data in Read-Only format, You can continue with "Text Input".
Thank You!
-
Ravi Vellanki