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

Avatar

Avatar

tc94524330

Avatar

tc94524330

tc94524330

19-01-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K
smacdonald2008

19-01-2017

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. 

Answers (3)

Answers (3)

Avatar

Avatar

workflowuser

Employee

Avatar

workflowuser

Employee

workflowuser
Employee

24-01-2017

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

Avatar

Avatar

kautuk_sahni

Community Manager

Total Posts

5.6K

Likes

961

Correct Answer

1.1K

Avatar

kautuk_sahni

Community Manager

Total Posts

5.6K

Likes

961

Correct Answer

1.1K
kautuk_sahni
Community Manager

20-01-2017

Hi 

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

~kautuk

Avatar

Avatar

tc94524330

Avatar

tc94524330

tc94524330

19-01-2017

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.