topic Sorting and Filtering in Activiti Rest in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sorting-and-filtering-in-activiti-rest/m-p/206915#M160045 <HTML><HEAD></HEAD><BODY><SPAN>As part of our Activiti implementation, we are building a UI that connects to the Activiti REST interface, and we have noticed some perculiarities with the filtering and sorting functions of the REST interface and Activiti in general.</SPAN><BR /><BR /><SPAN>It seems that the sorting on Ids is done as text, so you would receive the response in an odd order, such as:</SPAN><BR /><BR /><SPAN>1</SPAN><BR /><SPAN>2</SPAN><BR /><SPAN>22</SPAN><BR /><SPAN>3</SPAN><BR /><BR /><SPAN>instead of:</SPAN><BR /><SPAN>1</SPAN><BR /><SPAN>2</SPAN><BR /><SPAN>3</SPAN><BR /><SPAN>22</SPAN><BR /><BR /><SPAN>Also, when using 'nameLike' or similar for filtering, it seems to be case sensitive.</SPAN><BR /><BR /><SPAN>Is there any way to work around these two issues?</SPAN></BODY></HTML> Wed, 05 Nov 2014 07:13:32 GMT mhanrahan 2014-11-05T07:13:32Z Sorting and Filtering in Activiti Rest https://connect.hyland.com/t5/alfresco-archive/sorting-and-filtering-in-activiti-rest/m-p/206915#M160045 As part of our Activiti implementation, we are building a UI that connects to the Activiti REST interface, and we have noticed some perculiarities with the filtering and sorting functions of the REST interface and Activiti in general.It seems that the sorting on Ids is done as text, so you would rec Wed, 05 Nov 2014 07:13:32 GMT https://connect.hyland.com/t5/alfresco-archive/sorting-and-filtering-in-activiti-rest/m-p/206915#M160045 mhanrahan 2014-11-05T07:13:32Z Re: Sorting and Filtering in Activiti Rest https://connect.hyland.com/t5/alfresco-archive/sorting-and-filtering-in-activiti-rest/m-p/206916#M160046 <HTML><HEAD></HEAD><BODY><SPAN>The id is a string, so indeed string ordering is done if you dont provide any specific ordering.</SPAN><BR /><BR /><SPAN>case sensitive will depend on your db. Some db's are case insensitive, some arent.</SPAN></BODY></HTML> Wed, 05 Nov 2014 13:07:29 GMT https://connect.hyland.com/t5/alfresco-archive/sorting-and-filtering-in-activiti-rest/m-p/206916#M160046 jbarrez 2014-11-05T13:07:29Z Re: Sorting and Filtering in Activiti Rest https://connect.hyland.com/t5/alfresco-archive/sorting-and-filtering-in-activiti-rest/m-p/206917#M160047 <HTML><HEAD></HEAD><BODY><SPAN>I'm using MySQL, which as far as I can tell, isn't case sensitive for LIKE by default.</SPAN></BODY></HTML> Thu, 06 Nov 2014 02:35:47 GMT https://connect.hyland.com/t5/alfresco-archive/sorting-and-filtering-in-activiti-rest/m-p/206917#M160047 mhanrahan 2014-11-06T02:35:47Z