topic Query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/query/m-p/9388#M3342 <HTML><HEAD></HEAD><BODY><SPAN>io ho creato una tabbella in C:\Alfresco\alf_data\mysql\alfresco di nome lettere.frm.</SPAN><BR /><SPAN>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?</SPAN><BR /><SPAN> &lt;?xml version="1.0" encoding="UTF-8" ?&gt; </SPAN><BR /><SPAN>- &lt;!–&nbsp; Definition of new Model </SPAN><BR /><SPAN>&nbsp; –&gt; </SPAN><BR /><SPAN>- &lt;!–&nbsp; The important part here is the name - Note: the use of the ass: namespace</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; which is defined further on in the document </SPAN><BR /><SPAN>&nbsp; –&gt; </SPAN><BR /><SPAN>- &lt;model name="ass:assnewmodel" xmlns="</SPAN><A href="http://www.alfresco.org/model/dictionary/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/dictionary/1.0</A><SPAN>"&gt;</SPAN><BR /><SPAN>- &lt;!–&nbsp; Optional meta-data about the model </SPAN><BR /><SPAN>&nbsp; –&gt; </SPAN><BR /><SPAN>&nbsp; &lt;description&gt;Example assicurativa Model&lt;/description&gt; </SPAN><BR /><SPAN>&nbsp; &lt;author /&gt; </SPAN><BR /><SPAN>&nbsp; &lt;version&gt;1.0&lt;/version&gt; </SPAN><BR /><SPAN>- &lt;!–&nbsp; Imports are required to allow references to definitions in other models </SPAN><BR /><SPAN>&nbsp; –&gt; </SPAN><BR /><SPAN>- &lt;imports&gt;</SPAN><BR /><SPAN>- &lt;!–&nbsp; Import Alfresco Dictionary Definitions </SPAN><BR /><SPAN>&nbsp; –&gt; </SPAN><BR /><SPAN>&nbsp; &lt;import uri="</SPAN><A href="http://www.alfresco.org/model/dictionary/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/dictionary/1.0</A><SPAN>" prefix="d" /&gt; </SPAN><BR /><SPAN>- &lt;!–&nbsp; Import Alfresco Content Domain Model Definitions </SPAN><BR /><SPAN>&nbsp; –&gt; </SPAN><BR /><SPAN>&nbsp; &lt;import uri="</SPAN><A href="http://www.alfresco.org/model/content/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/content/1.0</A><SPAN>" prefix="cm" /&gt; </SPAN><BR /><SPAN>&nbsp; &lt;/imports&gt;</SPAN><BR /><SPAN>- &lt;!–&nbsp; Introduction of new namespaces defined by this model </SPAN><BR /><SPAN>&nbsp; –&gt; </SPAN><BR /><SPAN>- &lt;!–&nbsp; NOTE: The following namespace my.new.model should be changed to reflect your own namespace </SPAN><BR /><SPAN>&nbsp; –&gt; </SPAN><BR /><SPAN>- &lt;namespaces&gt;</SPAN><BR /><SPAN>&nbsp; &lt;namespace uri="ass.new.model" prefix="ass" /&gt; </SPAN><BR /><SPAN>&nbsp; &lt;/namespaces&gt;</SPAN><BR /><SPAN>- &lt;constraints&gt;</SPAN><BR /><SPAN>- &lt;constraint name="ass:allowedStatus" type="LIST"&gt;</SPAN><BR /><SPAN>- &lt;parameter name="allowedValues"&gt;</SPAN><BR /><SPAN>- &lt;list&gt;</SPAN><BR /><SPAN>&nbsp; &lt;value&gt;non specificato&lt;/value&gt; </SPAN><BR /><SPAN>&nbsp; &lt;value&gt;raccomandata&lt;/value&gt; </SPAN><BR /><SPAN>&nbsp; &lt;value&gt;fax&lt;/value&gt; </SPAN><BR /><SPAN>&nbsp; &lt;value&gt;prioritaria&lt;/value&gt; </SPAN><BR /><SPAN>&nbsp; &lt;/list&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/parameter&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/constraint&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/constraints&gt;</SPAN><BR /><SPAN>- &lt;types&gt;</SPAN><BR /><SPAN>- &lt;!–&nbsp; Definition of new Content Type:assicurativa </SPAN><BR /><SPAN>&nbsp; –&gt; </SPAN><BR /><SPAN>- &lt;type name="ass:as"&gt;</SPAN><BR /><SPAN>&nbsp; &lt;title&gt;Assicurativa&lt;/title&gt; </SPAN><BR /><SPAN>&nbsp; &lt;parent&gt;cm:content&lt;/parent&gt; </SPAN><BR /><SPAN>- &lt;properties&gt;</SPAN><BR /><SPAN>- &lt;property name="ass:cliente"&gt;</SPAN><BR /><SPAN>&nbsp; &lt;type&gt;d:text&lt;/type&gt; </SPAN><BR /><SPAN>&nbsp; &lt;mandatory&gt;true&lt;/mandatory&gt; </SPAN><BR /><SPAN>&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>- &lt;property name="ass:numero_Pratica_assicurativa"&gt;</SPAN><BR /><SPAN>&nbsp; &lt;type&gt;d:int&lt;/type&gt; </SPAN><BR /><SPAN>&nbsp; &lt;mandatory&gt;true&lt;/mandatory&gt; </SPAN><BR /><SPAN>&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>- &lt;property name="ass:lettera"&gt;</SPAN><BR /><SPAN>&nbsp; &lt;type&gt;d:text&lt;/type&gt; </SPAN><BR /><SPAN>&nbsp; &lt;mandatory&gt;false&lt;/mandatory&gt; </SPAN><BR /><SPAN>&nbsp; &lt;default&gt;non specificato&lt;/default&gt; </SPAN><BR /><SPAN>- &lt;constraints&gt;</SPAN><BR /><SPAN>&nbsp; &lt;constraint ref="ass:allowedStatus" /&gt; </SPAN><BR /><SPAN>&nbsp; &lt;/constraints&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/properties&gt;</SPAN><BR /><SPAN>- &lt;mandatory-aspects&gt;</SPAN><BR /><SPAN>&nbsp; &lt;aspect&gt;cm:versionable&lt;/aspect&gt; </SPAN><BR /><SPAN>&nbsp; &lt;/mandatory-aspects&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/type&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/types&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/model&gt;</SPAN></BODY></HTML> Tue, 12 Oct 2010 10:04:38 GMT fagiano 2010-10-12T10:04:38Z 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