topic Autocomplete custom property from LIST in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/autocomplete-custom-property-from-list/m-p/294803#M247933 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>I've made my own custom type with few custom properties and one of them is a LIST which picks values from MySQL database. Now, because the amount of values increased a lot, I decided to change it into text field with autocomplete feature which I want to keep at picking values from the same MySQL table. I'm kind of lost how I should do this. I discovered that there's some autocomplete.ftl template for this which uses some kind of data source but I have no idea how to make DataSource of my own using my MySQL database to pick values from.</SPAN><BR /><BR /><SPAN>I tried to start with something easier so I decided to try using the data source alredy included in alfresco (which i found somewhere on internet) but it doesn't seem to work neither. It should pick the users from alfresco.</SPAN><BR /><BR /><SPAN>my share-config-custom.xlm looks like this</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />…<BR />&nbsp;&nbsp;&nbsp;&lt;field id="mb:autorF" set="obecne"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;control template="/autocomplete.ftl"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;control-param name="ds"&gt;/share/service/ds/autocomplete/alfrescoperson&lt;/control-param&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/control&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/field&gt;<BR />…<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>and the autocomplete.ftl looks like this</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;#if field.control.params.ds?exists&gt;&lt;#assign ds=field.control.params.ds&gt;&lt;#else&gt;&lt;#assign ds=''&gt;&lt;/#if&gt;<BR />&lt;#if field.control.params.width?exists&gt;&lt;#assign width=field.control.params.width&gt;&lt;#else&gt;&lt;#assign width='35em'&gt;&lt;/#if&gt;<BR /><BR />&lt;style type="text/css"&gt;<BR />#${fieldHtmlId}-AutoComplete {<BR />&nbsp;&nbsp;&nbsp; width:${width}; /* set width here or else widget will expand to fit its container */<BR />&nbsp;&nbsp;&nbsp; padding-bottom:2em;<BR />}<BR />&lt;/style&gt;<BR /><BR />&lt;div class="form-field"&gt;<BR />&nbsp;&nbsp; &lt;#if form.mode == "view"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;div class="viewmode-field"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if field.mandatory &amp;&amp; !(field.value?is_number) &amp;&amp; field.value == ""&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="incomplete-warning"&gt;&lt;img src="${url.context}/components/form/images/warning-16.png" title="${msg("form.field.incomplete")}" /&gt;&lt;span&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="viewmode-label"&gt;${field.label?html}:&lt;/span&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="viewmode-value"&gt;${field.value?html}&lt;/span&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/div&gt;<BR />&nbsp;&nbsp; &lt;#else&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;label for="${fieldHtmlId}"&gt;${field.label?html}:&lt;#if field.mandatory&gt;&lt;span class="mandatory-indicator"&gt;${msg("form.required.fields.marker")}&lt;/span&gt;&lt;/#if&gt;&lt;/label&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;div id="${fieldHtmlId}-AutoComplete"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;input id="${fieldHtmlId}" type="text" name="${field.name}" <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if field.control.params.styleClass?exists&gt;class="${field.control.params.styleClass}"&lt;/#if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if field.value?is_number&gt;value="${field.value?c}"&lt;#else&gt;value="${field.value}"&lt;/#if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if field.description?exists&gt;title="${field.description}"&lt;/#if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if field.control.params.maxLength?exists&gt;maxlength="${field.control.params.maxLength}"&lt;/#if&gt; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if field.control.params.size?exists&gt;size="${field.control.params.size}"&lt;/#if&gt; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if field.disabled&gt;disabled="true"&lt;/#if&gt; /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;div id="${fieldHtmlId}-Container"&gt;&lt;/div&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp; &lt;/div&gt;<BR />&nbsp;&nbsp; &lt;/#if&gt;<BR />&lt;/div&gt;<BR /><BR />&lt;script type="text/javascript"&gt;//&lt;![CDATA[<BR />(function()<BR />{<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Use an XHRDataSource<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var oDS = new YAHOO.util.XHRDataSource("${ds}");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Set the responseType<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;oDS.responseType = YAHOO.util.XHRDataSource.TYPE_JSON;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Define the schema of the JSON results<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;oDS.responseSchema = {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;resultsList : "result",<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fields : ["value"]<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;};<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Instantiate the AutoComplete<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var oAC = new YAHOO.widget.AutoComplete("${fieldHtmlId}", "${fieldHtmlId}-Container", oDS);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Throttle requests sent<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;oAC.queryDelay = .5;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// The webservice needs additional parameters<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;oAC.generateRequest = function(sQuery) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;#if ds?contains("?")&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return "&amp;q=" + sQuery ;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;#else&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return "?q=" + sQuery ;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/#if&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;};<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;oDS: oDS,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;oAC: oAC<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;};<BR />})();<BR />//]]&gt;&lt;/script&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>unfortunately everytime i type in the field, nothing happens and catalina.out says</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />ERROR [alfresco.web.site] [http-apr-8080-exec-4] javax.servlet.ServletException: Could not resolve view with name 'ds/autocomplete/alfrescoperson' in servlet with name 'Spring Surf Dispatcher Servlet'<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>So i guess I'm doing something wrong or there's nothing like alfrescoperson DataSource there..</SPAN><BR /><BR /><SPAN>anyway I'd be really thankful, if you'd suggest me any way how to perform this kind of feature for my custom property, no matter how.. if there's a way how to do this with JavaScript or something, it would be really nice but I'm pretty sure I need to code some class file just like with the custom LIST picking it from database.</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><BR /><SPAN>Matouš</SPAN></BODY></HTML> Fri, 24 Jan 2014 15:29:37 GMT bazter 2014-01-24T15:29:37Z Autocomplete custom property from LIST https://connect.hyland.com/t5/alfresco-archive/autocomplete-custom-property-from-list/m-p/294803#M247933 Hello,I've made my own custom type with few custom properties and one of them is a LIST which picks values from MySQL database. Now, because the amount of values increased a lot, I decided to change it into text field with autocomplete feature which I want to keep at picking values from the same MyS Fri, 24 Jan 2014 15:29:37 GMT https://connect.hyland.com/t5/alfresco-archive/autocomplete-custom-property-from-list/m-p/294803#M247933 bazter 2014-01-24T15:29:37Z Re: Autocomplete custom property from LIST https://connect.hyland.com/t5/alfresco-archive/autocomplete-custom-property-from-list/m-p/294804#M247934 <HTML><HEAD></HEAD><BODY><SPAN>Should I post it into another section?</SPAN></BODY></HTML> Mon, 27 Jan 2014 10:00:32 GMT https://connect.hyland.com/t5/alfresco-archive/autocomplete-custom-property-from-list/m-p/294804#M247934 bazter 2014-01-27T10:00:32Z Re: Autocomplete custom property from LIST https://connect.hyland.com/t5/alfresco-archive/autocomplete-custom-property-from-list/m-p/294805#M247935 <HTML><HEAD></HEAD><BODY><SPAN>Check your </SPAN><PRE class="language-none line-numbers"><CODE>…/site-webscripts/org/alfresco/components/form/data<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN> folder. It should contain autocomplete component (</SPAN><PRE class="language-none line-numbers"><CODE>autocomplete.get.config.xml, autocomplete.get.desc.xml<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>, etc.). And after that, try to use "google" instead of "alfrescoperson" in url</SPAN></BODY></HTML> Thu, 15 May 2014 10:41:21 GMT https://connect.hyland.com/t5/alfresco-archive/autocomplete-custom-property-from-list/m-p/294805#M247935 alhol 2014-05-15T10:41:21Z