topic CMIS SCORE function not working as expected in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/cmis-score-function-not-working-as-expected/m-p/3926#M1614 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to order my CMIS query results by relevance using the score function, but it's not working as it should.</P><P></P><P>For instance, the results of this query:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>SELECT D.cmis:name, SCORE() AS relevance FROM cmis:document as D WHERE CONTAINS(D,'test')) ORDER BY relevance DESC</P></BLOCKQUOTE><P>Are not ordered by score:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>"example test script.js.sample" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.5994702577590942<BR /> "2_1995-00001_00001.pdf" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.039295781403779984<BR /> "26_1995-00001_00001.pdf" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.12414738535881042<BR /> "26_1998-00003_00001.pdf" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.03449612110853195<BR /> "Alfresco_Enterprise_4_1_5_Administrator.pdf" &nbsp;&nbsp;&nbsp; 0.11594238877296448</P></BLOCKQUOTE><P></P><P>Furthermore, if I add the path to the query, like this:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>SELECT D.cmis:name, SCORE() AS relevance FROM cmis:document as D WHERE CONTAINS(D,'test')) AND CONTAINS(D, 'PATH:"/app:company_home/st:sites//*"') ORDER BY relevance DESC</P></BLOCKQUOTE><P>The results are not only disordered, but the query is also returning score values greater than 1:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>"2_1995-00001_00001.pdf" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.0265105962753296<BR /> "26_1995-00001_00001.pdf" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.0837550163269043<BR /> "26_1998-00003_00001.pdf" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.0232725143432617<BR /> "Alfresco_Enterprise_4_1_5_Administrator.pdf" &nbsp;&nbsp;&nbsp; 1.0782195329666138</P></BLOCKQUOTE><P></P><P>Is there anything that I'm doing wrong?</P><P></P><P>Thank you in advance!! Regards</P></BODY></HTML> Fri, 20 Jan 2017 12:03:06 GMT tcuser 2017-01-20T12:03:06Z CMIS SCORE function not working as expected https://connect.hyland.com/t5/alfresco-forum/cmis-score-function-not-working-as-expected/m-p/3926#M1614 Hi all,I'm trying to order my CMIS query results by relevance using the score function, but it's not working as it should.For instance, the results of this query<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" />ELECT D.cmis:name, SCORE() AS relevance FROM cmis:document as D WHERE CONTAINS(D,'test')) ORDER BY relevance DESCAre not ordered by score Fri, 20 Jan 2017 12:03:06 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-score-function-not-working-as-expected/m-p/3926#M1614 tcuser 2017-01-20T12:03:06Z Re: CMIS SCORE function not working as expected https://connect.hyland.com/t5/alfresco-forum/cmis-score-function-not-working-as-expected/m-p/3927#M1615 <HTML><HEAD></HEAD><BODY><P>I've found out that if I change from solr to lucene, score and order are correct... does it make sense??</P></BODY></HTML> Fri, 20 Jan 2017 13:38:14 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-score-function-not-working-as-expected/m-p/3927#M1615 tcuser 2017-01-20T13:38:14Z Re: CMIS SCORE function not working as expected https://connect.hyland.com/t5/alfresco-forum/cmis-score-function-not-working-as-expected/m-p/3928#M1616 <HTML><HEAD></HEAD><BODY><P>Anyone help??</P></BODY></HTML> Tue, 24 Jan 2017 12:38:56 GMT https://connect.hyland.com/t5/alfresco-forum/cmis-score-function-not-working-as-expected/m-p/3928#M1616 tcuser 2017-01-24T12:38:56Z