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)
-
I've attached the screenshots. Pls review and advise.
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
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
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?
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.

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?
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!