topic Re: 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/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 iruizdeeguilaz 2014-02-26T16:37:15Z 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