topic custom field search failure in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/custom-field-search-failure/m-p/255069#M208199 <HTML><HEAD></HEAD><BODY><SPAN>Hi, </SPAN><BR /><SPAN>Is there any problem with using text field in search sort?</SPAN><BR /><SPAN>I have created a sorting fields and labels: </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="search.sort.relevance"&gt;&lt;/sort&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="Numurs"&gt;custom:documentRegNumber&lt;/sort&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="Dokumenta veids"&gt;custom:documentType&lt;/sort&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="Dokumenta nosaukums"&gt;custom:documentNameClasification&lt;/sort&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="Datums"&gt;cm:created|false&lt;/sort&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="Autors"&gt;cm:author&lt;/sort&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="Arhīva lietas numurs"&gt;custom:archiveCaseNumber&lt;/sort&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="Rediģēšanas datums (pēdējais)"&gt;cm:modified&lt;/sort&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="search.sort.mimetype"&gt;.mimetype&lt;/sort&gt;</SPAN><BR /><BR /><SPAN>Everything works fine (custom category fields too) except custom:documentRegNumber and custom:archiveCaseNumber witch are text types:</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="custom:documentRegNumber"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;title&gt;Dokumenta reģistrācijas numurs&lt;/title&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;type&gt;d:text&lt;/type&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;mandatory&gt;true&lt;/mandatory&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;property name="custom:archiveCaseNumber"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;title&gt;Arhīva lietas numurs&lt;/title&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;type&gt;d:text&lt;/type&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;mandatory&gt;false&lt;/mandatory&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/property&gt;</SPAN><BR /><BR /><SPAN>In log file I get:</SPAN><BR /><SPAN>2012-12-04 18:44:25,923&nbsp; ERROR [solr.core.SolrCore] [http-bio-8443-exec-1] java.lang.UnsupportedOperationException: Ordering not supported for @{custom.model}documentRegNumber</SPAN><BR /><BR /><SPAN>So, I want to know, is there any problem with using text field in sorting or I am doing something wrong?</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Laura</SPAN></BODY></HTML> Tue, 04 Dec 2012 17:08:29 GMT lauraeis 2012-12-04T17:08:29Z custom field search failure https://connect.hyland.com/t5/alfresco-archive/custom-field-search-failure/m-p/255069#M208199 Hi, Is there any problem with using text field in search sort?I have created a sorting fields and labels: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="search.sort.relevance"&gt;&lt;/sort&gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="Numurs"&gt;custom:documentRegNumber&lt;/sort&gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sort labelId="Dokumenta veids"&gt;custom:docume Tue, 04 Dec 2012 17:08:29 GMT https://connect.hyland.com/t5/alfresco-archive/custom-field-search-failure/m-p/255069#M208199 lauraeis 2012-12-04T17:08:29Z Re: custom field search failure https://connect.hyland.com/t5/alfresco-archive/custom-field-search-failure/m-p/255070#M208200 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Text fields are not orderable unless unless they are tokenised "false" or "both".</SPAN><BR /><SPAN>It generally makes no sense to sort on tokenised fields as the sort by the lowest token generated.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Mon, 17 Dec 2012 15:24:45 GMT https://connect.hyland.com/t5/alfresco-archive/custom-field-search-failure/m-p/255070#M208200 andy 2012-12-17T15:24:45Z Re: custom field search failure https://connect.hyland.com/t5/alfresco-archive/custom-field-search-failure/m-p/255071#M208201 <HTML><HEAD></HEAD><BODY><SPAN>HTTP Status 500 - Ordering not supported for {</SPAN><A href="http://www.cchindia.co.in/model/cch/dtax/article/1.0}subtopic" rel="nofollow noopener noreferrer">http://www.cchindia.co.in/model/cch/dtax/article/1.0}subtopic</A><SPAN> java.lang.UnsupportedOperationException: Ordering not supported for </SPAN></BODY></HTML> Fri, 07 Feb 2014 15:53:43 GMT https://connect.hyland.com/t5/alfresco-archive/custom-field-search-failure/m-p/255071#M208201 maddy 2014-02-07T15:53:43Z