topic not getting totalItems when running cmis query in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/not-getting-totalitems-when-running-cmis-query/m-p/72685#M23524 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to use cmis queries to implement pagination in my php script. However I'm facing strange behaviors from Alfresco results sets.</P><P></P><P>When I run the following query:</P><P></P><P>{<BR /> "query":{</P><P>"query":"select * from adb:sampledoc where IN_TREE('46518183-593c-481f-b30e-4a42baeb07ff') ORDER BY cmis:creationDate DESC",<BR /> "language":"cmis"<BR /> }<BR />}</P><P></P><P>I get the following result set:</P><P></P><P>{<BR /> "list": {<BR /> "pagination": {<BR /> "count": 0,<BR /> "hasMoreItems": false,<BR /> "totalItems": 0,<BR /> "skipCount": 0,<BR /> "maxItems": 100<BR /> },<BR /> "entries": []<BR /> }<BR />}</P><P></P><P>which contains totalItems, that I need for pagination.</P><P></P><P>However, when I run the following query:</P><P></P><P>{<BR /> "query":{</P><P>"query":"select * from&nbsp;<SPAN>adb:</SPAN><SPAN>sampledoc</SPAN> where IN_FOLDER('bb5715ed-38b1-4b01-839a-6064dfd10f82') ORDER BY cmis:creationDate DESC",<BR /> "language":"cmis"<BR /> }<BR />}</P><P></P><P>I get the following result set:</P><P></P><P>{<BR /> "list": {<BR /> "pagination": {<BR /> "count": 100,<BR /> "hasMoreItems": true,<BR /> "skipCount": 0,<BR /> "maxItems": 100<BR /> },<BR /> "entries": [...]<BR /> }<BR />}</P><P></P><P>As you see, the totalItems is missing. Does anybody know if this is a bug or I'm doing something wrong</P><P></P><P>Even stranger is that, we have alfresco on other systems. running the query with IN_FOLDER gives totalItems back.</P><P></P><P>Any help is appreciated.</P><P>Thanks</P></BODY></HTML> Thu, 22 Mar 2018 09:20:53 GMT archiver 2018-03-22T09:20:53Z not getting totalItems when running cmis query https://connect.hyland.com/t5/alfresco-forum/not-getting-totalitems-when-running-cmis-query/m-p/72685#M23524 Hi,I am trying to use cmis queries to implement pagination in my php script. However I'm facing strange behaviors from Alfresco results sets.When I run the following query:{ "query":{"query":"select * from adb:sampledoc where IN_TREE('46518183-593c-481f-b30e-4a42baeb07ff') ORDER BY cmis:creationDate Thu, 22 Mar 2018 09:20:53 GMT https://connect.hyland.com/t5/alfresco-forum/not-getting-totalitems-when-running-cmis-query/m-p/72685#M23524 archiver 2018-03-22T09:20:53Z Re: not getting totalItems when running cmis query https://connect.hyland.com/t5/alfresco-forum/not-getting-totalitems-when-running-cmis-query/m-p/72686#M23525 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P><SPAN>IN_TREE is</SPAN>&nbsp;not supported in CMIS queries solved by database (transactional metadata queries), so maybe your differences between your systems&nbsp;is how they configure the search subsystem (if your query is solved by database when possible or if it is always sent to SOLR). I can not confirm it but I would say that SOLR should give you totalItems.</P><P></P><P>Regards.</P><P>--C.</P></BODY></HTML> Thu, 22 Mar 2018 15:47:27 GMT https://connect.hyland.com/t5/alfresco-forum/not-getting-totalitems-when-running-cmis-query/m-p/72686#M23525 cesarista 2018-03-22T15:47:27Z