topic Alfresco CMIS search in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-search/m-p/311115#M264245 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm using in Java the SearchService to search custom folder on the repository using the CMIS Query language and transactional metadata to Query directly on the database.</SPAN><BR /><BR /><SPAN>To archieve this, I'm using the SearchParam like this :</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />String cmisQuery = "SELECT * FROM " + WvnEdmsModel.QNAME_TYPE_DOSSIER.toPrefixString() + " WHERE " + WvnEdmsModel.QNAME_PROP_E_SPACE_ID.toPrefixString() + " = '" + eSpaceId + "'";<BR /><BR />SearchParameters searchParam = new SearchParameters();<BR />searchParam.setLanguage(SearchService.LANGUAGE_CMIS_ALFRESCO);<BR />searchParam.addStore(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE);<BR />searchParam.setQuery(cmisQuery);<BR />searchParam.setQueryConsistency(QueryConsistency.TRANSACTIONAL);<BR />searchParam.addSort("@wvnEdms:currentStatus", true);<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>However, I don't know why but the results are not ordered…</SPAN><BR /><BR /><SPAN>I tried to add 'order by wvnEdms:currentStatus' to my Query. It works only for String, Integer and DateTime (see here </SPAN><A href="http://docs.alfresco.com/4.2/concepts/intrans-metadata-query.html" rel="nofollow noopener noreferrer">http://docs.alfresco.com/4.2/concepts/intrans-metadata-query.html</A><SPAN>)</SPAN><BR /><BR /><BR /><SPAN>Have you an idea what I'm making wrong with searchParam.addSort ?</SPAN><BR /><BR /><BR /><SPAN>Thank you</SPAN></BODY></HTML> Tue, 17 Nov 2015 16:20:35 GMT vbr 2015-11-17T16:20:35Z Alfresco CMIS search https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-search/m-p/311115#M264245 Hi,I'm using in Java the SearchService to search custom folder on the repository using the CMIS Query language and transactional metadata to Query directly on the database.To archieve this, I'm using the SearchParam like this <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" />tring cmisQuery = "SELECT * FROM " + WvnEdmsModel.QNAME_TYPE_DOSSIER.toP Tue, 17 Nov 2015 16:20:35 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-search/m-p/311115#M264245 vbr 2015-11-17T16:20:35Z Re: Alfresco CMIS search https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-search/m-p/311116#M264246 <HTML><HEAD></HEAD><BODY><P>If you go look at the type definition in something like CMIS Workbench, does that property show as being orderable? It might not be. For example, if you defined it in your content model as being tokenized (the default) it won't be orderable.</P></BODY></HTML> Wed, 21 Sep 2016 21:18:31 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-cmis-search/m-p/311116#M264246 jpotts 2016-09-21T21:18:31Z