topic Ordering is not support for my:property in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/ordering-is-not-support-for-my-property/m-p/305441#M258571 <HTML><HEAD></HEAD><BODY><SPAN>Hello</SPAN><BR /><BR /><SPAN>I have a problem using ORDER BY with my custom properties. I need help in orther to know what I should change in muy model to allow the order by…</SPAN><BR /><BR /><SPAN>I am able to do queries, and to use my aspect properties in the select…</SPAN><BR /><BR /><SPAN>example:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />StringBuffer cadena = new StringBuffer();<BR />cadena.append( "SELECT * FROM my:customtype&nbsp; as t join my:customaspect as d on d.cmis:objectId = t.cmis:objectId where d.my:dateDocument = TIMESTAMP '"+myDate+"T00:00:00.000-00:00' ");<BR />ItemIterable&lt;QueryResult&gt; results = session.query(cadena.toString(), false);<BR />for (QueryResult qResult : results.skipTo(10).getPage(10)) {<BR />&nbsp;&nbsp; ———<BR />}<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><BR /><BR /><SPAN>But when I add a order by id doesn't work…. it works if i try it against for example t.cmis:name but it diesn't work againts d.my:…..</SPAN><BR /><BR /><SPAN>Looking up on the Internet I fond that it is necesary tu put in the model something like this (but I put it after having the documents added on the repository)</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;index enabled="true"&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;atomic&gt;false&lt;/atomic&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;stored&gt;false&lt;/stored&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;tokenised&gt;true&lt;/tokenised&gt;<BR />&lt;/index&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I have added it on my model :</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;model name="my:model" xmlns="<A href="http://www.alfresco.org/model/dictionary/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/dictionary/1.0</A>"&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;description&gt;my model&lt;/description&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;author&gt;ir&lt;/author&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;version&gt;1.0&lt;/version&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;imports&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;import uri="<A href="http://www.alfresco.org/model/dictionary/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/dictionary/1.0</A>" prefix="d" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;import uri="<A href="http://www.alfresco.org/model/content/1.0" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/content/1.0</A>" prefix="cm" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/imports&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;namespaces&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;namespace&nbsp; uri="dynamic.model" prefix="my" /&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/namespaces&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;types&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;type name="my:document"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;title&gt;my Document&lt;/title&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;parent&gt;cm:content&lt;/parent&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mandatory-aspects&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;aspect&gt;my:customaspect&lt;/aspect&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/mandatory-aspects&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/type&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;type name="my:customtype"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;title&gt;my type&lt;/title&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;parent&gt;my:document&lt;/parent&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/type&gt;<BR />&lt;/types&gt;&nbsp;&nbsp;&nbsp;<BR />&lt;aspect name="my:customaspect"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;title&gt;my Data&lt;/title&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;properties&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="my:title"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;type&gt;d:text&lt;/type&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;index enabled="true"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;atomic&gt;false&lt;/atomic&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;stored&gt;false&lt;/stored&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tokenised&gt;true&lt;/tokenised&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/index&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="my:dateDocument"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;type&gt;d:date&lt;/type&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;index enabled="true"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;atomic&gt;false&lt;/atomic&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;stored&gt;false&lt;/stored&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tokenised&gt;true&lt;/tokenised&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/index&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&lt;/properties&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/aspect&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/aspects&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></CODE></PRE><BR /><BR /><BR /><SPAN>this is the error</SPAN><BR /><BR /><SPAN>&lt;blockquote&gt;</SPAN><BR /><SPAN>Exception in thread "main" org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: Ordering is not support for d.my:title</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:458)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.post(AbstractAtomPubService.java:629)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:145)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.SessionImpl$3.fetchPage(SessionImpl.java:600)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterator.getCurrentPage(AbstractIterator.java:132)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.util.CollectionPageIterator.hasNext(CollectionPageIterator.java:48)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;…….</SPAN><BR /><SPAN>&lt;/blockquote&gt;</SPAN></BODY></HTML> Wed, 26 Feb 2014 08:05:51 GMT iruizdeeguilaz 2014-02-26T08:05:51Z Ordering is not support for my:property https://connect.hyland.com/t5/alfresco-archive/ordering-is-not-support-for-my-property/m-p/305441#M258571 HelloI have a problem using ORDER BY with my custom properties. I need help in orther to know what I should change in muy model to allow the order by…I am able to do queries, and to use my aspect properties in the select…example<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />tringBuffer cadena = new StringBuffer();cadena.append( "SELECT * FROM Wed, 26 Feb 2014 08:05:51 GMT https://connect.hyland.com/t5/alfresco-archive/ordering-is-not-support-for-my-property/m-p/305441#M258571 iruizdeeguilaz 2014-02-26T08:05:51Z Re: Ordering is not support for my:property https://connect.hyland.com/t5/alfresco-archive/ordering-is-not-support-for-my-property/m-p/305442#M258572 <HTML><HEAD></HEAD><BODY><SPAN>a property is sortable&nbsp; only if it is untokenized,so it must be defined as</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;tokenised&gt;false&lt;/tokenised&gt;<BR />or<BR />&lt;tokenised&gt;both&lt;/tokenised&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Wed, 26 Feb 2014 14:15:52 GMT https://connect.hyland.com/t5/alfresco-archive/ordering-is-not-support-for-my-property/m-p/305442#M258572 kaynezhang 2014-02-26T14:15:52Z Re: Ordering is not support for my:property https://connect.hyland.com/t5/alfresco-archive/ordering-is-not-support-for-my-property/m-p/305443#M258573 <HTML><HEAD></HEAD><BODY><SPAN>yes, it worked, I chose both in order to check it and I am able to order <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" />)))) </SPAN><BR /><BR /><SPAN>thanks so much</SPAN></BODY></HTML> Wed, 26 Feb 2014 16:37:15 GMT https://connect.hyland.com/t5/alfresco-archive/ordering-is-not-support-for-my-property/m-p/305443#M258573 iruizdeeguilaz 2014-02-26T16:37:15Z