topic Re: Populating selectmany.ftl from a data list or database in Alfresco Archive

Populating selectmany.ftl from a data list or database

csamgreene — Wed, 09 May 2012 17:37:39 GMT

I would like to populate a selectmany control with data from either an Alfresco data list or from a database. Here is an XML stanza that currently uses a hard coded list. . <field id="lxrimary_company" label-id="prop.lx_primary_company"> <control template=

Re: Populating selectmany.ftl from a data list or database

jpotts — Sat, 02 Jun 2012 00:23:58 GMT

The control used for a given field is freemarker, and you can provide your own freemarker to render a control.

You can also provide your own client-side JavaScript that knows how to find and populate that control.

So one approach for doing what you are trying to do is to specify a custom control that includes a client-side JavaScript component that issues an AJAX call against a web service somewhere (could be an Alfresco web script running on either the Share tier or the Repository tier) that retrieves the values and populates the dropdown.

I don't know of an example of this off the top of my head and I'm sorry I don't have time to provide more details at the moment, but know that it is possible and hopefully this extremely high-level description will give you something to go on.

Jeff

Re: Populating selectmany.ftl from a data list or database

erikwinlof — Tue, 05 Jun 2012 06:47:42 GMT

Hi,

You can find some of the sample code you need for this in the following reply:
https://forums.alfresco.com/en/viewtopic.php?f=48&t=43659#p130790

Cheers, Erik