topic Re: Order By Process Instance ID in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/order-by-process-instance-id/m-p/157389#M111574 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><UL><LI>use DB support (it depends on DB you use) e.g. <A href="http://stackoverflow.com/questions/4939518/sorting-string-column-containing-numbers-in-sql" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/4939518/sorting-string-column-containing-numbers-in-sql</A> (native queries could support it)</LI><LI>use java in memory sorting</LI></UL><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Wed, 23 Apr 2014 06:29:55 GMT martin_grofcik 2014-04-23T06:29:55Z Order By Process Instance ID https://connect.hyland.com/t5/alfresco-archive/order-by-process-instance-id/m-p/157388#M111573 Hi,I am aware that order by process start/create time is not supported and that order by process instance id can do that since it is sequential. However, I've found out that the function does not give it to you as you may want it, since instance id is in the form of a string. 834 comes above 1234 if Wed, 23 Apr 2014 04:04:15 GMT https://connect.hyland.com/t5/alfresco-archive/order-by-process-instance-id/m-p/157388#M111573 liowbot 2014-04-23T04:04:15Z Re: Order By Process Instance ID https://connect.hyland.com/t5/alfresco-archive/order-by-process-instance-id/m-p/157389#M111574 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><UL><LI>use DB support (it depends on DB you use) e.g. <A href="http://stackoverflow.com/questions/4939518/sorting-string-column-containing-numbers-in-sql" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/4939518/sorting-string-column-containing-numbers-in-sql</A> (native queries could support it)</LI><LI>use java in memory sorting</LI></UL><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Wed, 23 Apr 2014 06:29:55 GMT https://connect.hyland.com/t5/alfresco-archive/order-by-process-instance-id/m-p/157389#M111574 martin_grofcik 2014-04-23T06:29:55Z