topic Re: Loading a database table in a combobox in Alfresco Archive

Loading a database table in a combobox

prpontes — Tue, 20 Mar 2012 17:25:57 GMT

Hello I would like to help on a one questions related to content creation. I am creating new content and with the content, new aspects. So far so good. My question is how do you add a metadata field as the type combobox in it to load data from a table Client? I need to create some Action javascript?

Re: Loading a database table in a combobox

erikwinlof — Wed, 21 Mar 2012 08:46:48 GMT

Hi Prpontes,

Unfortunately I don't follow exactly what you want to do, right now I'm guessing you are trying to create a form that shall appear in Share when you create new content of your custom model, and that that form shall contain a custom control shall be a combo box that shall load data from a "database table" in the repository?

If so please make sure you have read the forms documentation on how to create a custom form "control":
http://wiki.alfresco.com/wiki/Forms

Then make sure there is a json webscript available in the repo that can make the table data available through the proxy. Then use the Alfresco.util.Ajax.jsonGet javascript method from your custom form control to load the table data from the repo.

Hope this is at least close to what your looking for, If not you have to be a bit more specific, providing some of the code you already have might help.

Cheers, Erik

Re: Loading a database table in a combobox

prpontes — Wed, 21 Mar 2012 12:21:18 GMT

Hi Erik thanks for your reply, that's exactly what I want to do.

sorry for my english, is that I'm using google translator, so maybe you do not understand me.

then that's it I want to:
Create a form that contains a custom control (combo box) that has on it a table to show all my registered clients.

thanks for the help.

Re: Loading a database table in a combobox

erikwinlof — Wed, 21 Mar 2012 12:42:53 GMT

Great! Then you should get a good start using that link.

Cheers, Erik

Re: Loading a database table in a combobox

prpontes — Wed, 21 Mar 2012 15:01:31 GMT

Hi Erik I can export a resultset to xml and display the values inside a control selectone? Because I think it would be easier to do a direct query to a table. Is there something I could do in alfresco?

thank you

Re: Loading a database table in a combobox

erikwinlof — Wed, 21 Mar 2012 15:24:16 GMT

Alfresco does not let you query its database table directly from the browser and export the result as xml.
Instead take a look at the following link on how to create a repository web script coded in java. I would suggest you return json instead of xml since that is slightly easier to handle in the browser using javascript, but if you want to use xml that is fine too.

http://wiki.alfresco.com/wiki/Java-backed_Web_Scripts_Samples

Then you will be able to access that web script form your browser using javascript, i.e. using the Alfresco.util.Ajax.request method.

Cheers, Erik

Re: Loading a database table in a combobox

zlu — Fri, 04 May 2012 21:16:00 GMT

Hi Prpontes,

Unfortunately I don't follow exactly what you want to do, right now I'm guessing you are trying to create a form that shall appear in Share when you create new content of your custom model, and that that form shall contain a custom control shall be a combo box that shall load data from a "database table" in the repository?

If so please make sure you have read the forms documentation on how to create a custom form "control":
http://wiki.alfresco.com/wiki/Forms

Then make sure there is a json webscript available in the repo that can make the table data available through the proxy. Then use the Alfresco.util.Ajax.jsonGet javascript method from your custom form control to load the table data from the repo.

Hope this is at least close to what your looking for, If not you have to be a bit more specific, providing some of the code you already have might help.

Cheers, Erik

Hi Erik,

Can you tell me more detail in how to call the Alfresco.util.Ajax.jsonGet in the control? In the control's template file or what?

I have the working web script but don't know how to call it and add the return jason items to the control.

Re: Loading a database table in a combobox

erikwinlof — Mon, 07 May 2012 06:50:30 GMT

Hi,

If your new to this its probably easiest to start by creating it inline, inside the template just to get it working…

First create a combobox and assign it the unique guid that the forms runtime gives you, i.e.:

<select id="${fieldHtmlId}"></select>‍

Then inside a <script> tag do something like this:

var getSelectFieldData = function(fieldId)
{
   // First make sure the select element is found in the dom…
   YAHOO.util.Event.onContentReady(fieldId, function()
   {
      // …found it, now ask your custom repo webscript for the data…
      var selectEl = YAHOO.util.Dom.get(fieldId);
      Alfresco.util.Ajax.jsonGet(
      {
         url: Alfresco.constants.PROXY_URI + '/your/custom/webscript',
         successCallback:
         {
            fn: function loadWebscript_successCallback(response, config)
            {
               // …data is now received, now populate the select element 
               // todo: Add <option> elements to "selectEl".
            }
      });
   });
}

// Call your function
getSelectFieldData("${fieldHtmlId}");
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Once it works move the code to a separate .js file in which you can create a proper javascript class so it can be documented and reused etc.

Re: Loading a database table in a combobox

zlu — Mon, 07 May 2012 19:09:01 GMT

Thanks Erik,

It works well. Great help from you.

Cheers,
Daniel

<select id="${fieldHtmlId}"></select>‍

Then inside a <script> tag do something like this:

var getSelectFieldData = function(fieldId)
{
   // First make sure the select element is found in the dom…
   YAHOO.util.Event.onContentReady(fieldId, function()
   {
      // …found it, now ask your custom repo webscript for the data…
      var selectEl = YAHOO.util.Dom.get(fieldId);
      Alfresco.util.Ajax.jsonGet(
      {
         url: Alfresco.constants.PROXY_URI + '/your/custom/webscript',
         successCallback:
         {
            fn: function loadWebscript_successCallback(response, config)
            {
               // …data is now received, now populate the select element 
               // todo: Add <option> elements to "selectEl".
            }
      });
   });
}

// Call your function
getSelectFieldData("${fieldHtmlId}");
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Once it works move the code to a separate .js file in which you can create a proper javascript class so it can be documented and reused etc.

Re: Loading a database table in a combobox

sharifu — Mon, 08 Oct 2012 16:06:50 GMT

Hi I am trying to do what you have done, can you please shed some light and talk me through it as I am stuck.

I want to populate textfield from database as I type on the form

what files did you create and what did you edit and add?

So far I have an empty file here
shared/classes/alfresco/web-extension/site-webscripts/org/alfresco/components/form/controls/populate.ftl

Re: Loading a database table in a combobox

sgangapa — Wed, 13 Mar 2013 11:16:59 GMT

Could you pls. share the integrated sample code?..

Re: Loading a database table in a combobox

zladuric — Fri, 15 Mar 2013 22:10:27 GMT

Hi,

This might be a little bit outdated, but it should be easy enough to follow:

http://code.google.com/p/alfresco-share-datatable-property-type/