topic Re: How to populate drop down from db in web forms? in Alfresco Archive

How to populate drop down from db in web forms?

maqsood — Fri, 15 Jul 2011 19:15:45 GMT

Hi,Is it possible to populate drop down list from external database in web forms? if yes, how to achieve it?Thanks.

Re: How to populate drop down from db in web forms?

romschn — Sat, 16 Jul 2011 07:53:07 GMT

Hi,

You may need to do some modifications in xform.js in which you can call a webscript which will get you the required data from the database and the returned data you should use to populate the text box in a web form.

I have not tried it though.

Hope it helps.

Thanks,

Re: How to populate drop down from db in web forms?

maqsood — Sat, 16 Jul 2011 08:18:19 GMT

Thanks romschn for quick reply.

Can you please elobarate the exact steps to do?

Re: How to populate drop down from db in web forms?

romschn — Mon, 18 Jul 2011 11:45:50 GMT

I have not any working example of this with me as I have not tried it but this is how you may achieve it.

You need to create your custom widget which will invoke a web script using dojo.io.bind and set the webscript returned value to your component.

Hope this helps.

Thanks,

Re: How to populate drop down from db in web forms?

venzia — Mon, 07 May 2012 17:33:33 GMT

Not for webform but to Share, but to complete this post, for those arriving now, I would like to mention that there is a component in Alfresco Addons that does this and more in a simple, intuitive and powerful way.
https://addons.alfresco.com/addons/alfresco-metadbconnector-component
I hope this helps the community.

Greetings!