topic Re: Query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/query/m-p/9389#M3343 <HTML><HEAD></HEAD><BODY><SPAN>L'ho fatto anni fa per la versione 2.1</SPAN><BR /><BR /><SPAN>In pratica si tratta di estendere la classe org.alfresco.repo.dictionary.constraint.ListOfValuesConstraint e fare in modo che i valori da elencare siano recuperati attraverso una query i cui parametri sono specifciati nel constraint.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>&lt;constraint name="dnw:comune_constraint" type="it.datanetwork.alfresco.repo.dictionary.constraint.ListOfValuesQueryConstraint"&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="driver"&gt;&lt;value&gt;org.gjt.mm.mysql.Driver&lt;/value&gt;&lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="url"&gt;&lt;value&gt;jdbc:mysql://localhost/demo&lt;/value&gt;&lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="sql"&gt;&lt;value&gt;select comune from comuni order by comune&lt;/value&gt;&lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="username"&gt;&lt;value&gt;root&lt;/value&gt;&lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="password"&gt;&lt;value&gt;password&lt;/value&gt;&lt;/parameter&gt;<BR />&lt;/constraint&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 08 Nov 2010 11:43:00 GMT alarocca_5413 2010-11-08T11:43:00Z Query https://connect.hyland.com/t5/alfresco-archive/query/m-p/9388#M3342 io ho creato una tabbella in C:\Alfresco\alf_data\mysql\alfresco di nome lettere.frm.ho creato il seguente file ma invece che inserire i tipi di lettera (raccomandata fax..)come ho fattto vorrei importarli dalla tabella lettera.frm. Si puo fare Come? &lt;?xml version="1.0" encoding="UTF-8" ?&gt; - &amp; Tue, 12 Oct 2010 10:04:38 GMT https://connect.hyland.com/t5/alfresco-archive/query/m-p/9388#M3342 fagiano 2010-10-12T10:04:38Z Re: Query https://connect.hyland.com/t5/alfresco-archive/query/m-p/9389#M3343 <HTML><HEAD></HEAD><BODY><SPAN>L'ho fatto anni fa per la versione 2.1</SPAN><BR /><BR /><SPAN>In pratica si tratta di estendere la classe org.alfresco.repo.dictionary.constraint.ListOfValuesConstraint e fare in modo che i valori da elencare siano recuperati attraverso una query i cui parametri sono specifciati nel constraint.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>&lt;constraint name="dnw:comune_constraint" type="it.datanetwork.alfresco.repo.dictionary.constraint.ListOfValuesQueryConstraint"&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="driver"&gt;&lt;value&gt;org.gjt.mm.mysql.Driver&lt;/value&gt;&lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="url"&gt;&lt;value&gt;jdbc:mysql://localhost/demo&lt;/value&gt;&lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="sql"&gt;&lt;value&gt;select comune from comuni order by comune&lt;/value&gt;&lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="username"&gt;&lt;value&gt;root&lt;/value&gt;&lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;parameter name="password"&gt;&lt;value&gt;password&lt;/value&gt;&lt;/parameter&gt;<BR />&lt;/constraint&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 08 Nov 2010 11:43:00 GMT https://connect.hyland.com/t5/alfresco-archive/query/m-p/9389#M3343 alarocca_5413 2010-11-08T11:43:00Z