Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

How to load values in dropdown list component in form from external DB

tc94524330
Level 4
Level 4

Hi,

I have a dropdown list component on a page and i want to get values for the dropdown from external DB. What is the best way to achieve this?

If i write a servlet which calls database, gets data and convert in to JSON format and return that JSON, how do i load that JSON values in dropdown using Items load path?

Any help would be appreciated.

Thanks

1 Accepted Solution
smacdonald2008
Correct answer by
Level 10
Level 10

See this article - how to use a Servlet to populate a drop-down - in servlet, you can query the database: 

http://scottsdigitalcommunity.blogspot.ca/2015/06/populating-aem-component-dialog-fields.html

Hope this helps. 

View solution in original post

4 Replies
smacdonald2008
Correct answer by
Level 10
Level 10

See this article - how to use a Servlet to populate a drop-down - in servlet, you can query the database: 

http://scottsdigitalcommunity.blogspot.ca/2015/06/populating-aem-component-dialog-fields.html

Hope this helps. 

View solution in original post

tc94524330
Level 4
Level 4

Hi,

This works only if Xtype is set to select and only for dialogs. I am looking for how to do this in a drop down field component in AEM form. 

kautuk_sahni
Community Manager
Community Manager

Hi 

Moving this thread to AEM "Forms" topic so to have better contextual experts have a look at this.

~kautuk

workflowuser
Employee
Employee

there is a sample on our demo site with sample code

login using your facebook account

the 9th item in the carousel has a demo of populating drop down list. The demo name is cascading drop down list

you can download the package and try it