topic CMIS Queries on Nodes Outside of Company Home? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-nodes-outside-of-company-home/m-p/305344#M258474 <HTML><HEAD></HEAD><BODY><SPAN>I'm trying to do some CMIS queries on repository nodes that exist outside of Company Home.</SPAN><BR /><BR /><BR /><SPAN>My use case is this: I'd like to calculate some metrics on my users and when their accounts where created.&nbsp;&nbsp; Each user has a node under the System &gt; People.&nbsp;&nbsp; These nodes have a child node named 'configurations' that provide a date created.&nbsp; </SPAN><BR /><BR /><SPAN>I'm using the CMIS search because it allows me provide a date range.&nbsp;&nbsp; What I'd like is to query the names and count of users created by month for the last three years.</SPAN><BR /><BR /><SPAN>Something similar to: </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />SELECT * FROM cmis:folder WHERE cmis:name = 'configurations' AND cmis:creationDate &gt; TIMESTAMP '2013-01-01T14:20:00.000-00:00' AND cmis:creationDate &lt; TIMESTAMP '2013-02-01T14:20:00.000-00:00'<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><BR /><SPAN>My issue is that the javascript search APIs don't seem to accommodate searches outside of company home.&nbsp; That said, how can I perform similar queries in javascript?</SPAN></BODY></HTML> Mon, 05 Aug 2013 16:48:52 GMT vamirr 2013-08-05T16:48:52Z CMIS Queries on Nodes Outside of Company Home? https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-nodes-outside-of-company-home/m-p/305344#M258474 I'm trying to do some CMIS queries on repository nodes that exist outside of Company Home.My use case is this: I'd like to calculate some metrics on my users and when their accounts where created.&nbsp;&nbsp; Each user has a node under the System &gt; People.&nbsp;&nbsp; These nodes have a child node named 'configurati Mon, 05 Aug 2013 16:48:52 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-nodes-outside-of-company-home/m-p/305344#M258474 vamirr 2013-08-05T16:48:52Z Re: CMIS Queries on Nodes Outside of Company Home? https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-nodes-outside-of-company-home/m-p/305345#M258475 <HTML><HEAD></HEAD><BODY><SPAN>Here are a few thoughts:</SPAN><BR /><BR /><SPAN> - Lucene also supports date range searches. You don't need CMIS to do that.</SPAN><BR /><SPAN> - CMIS doesn't care where in the repository your nodes live. But that configurations folder has to be of type cm:folder or one of its sub-types, including custom types. And the config objects have to be of type cm:content or one of its sub-types, including custom types. For example, objects that inherit directly from sys: and skip cm:content won't be available to CMIS.</SPAN><BR /><SPAN> - There is a "cmis" root-scoped object available from JavaScript. It was broken in 4.0 community for a while, but I believe it was fixed with 4.2.</SPAN><BR /><SPAN> - You might want to test your searches in the node browser. You can specify all of the different search syntaxes that the repository supports. Then when you are satisfied your query is working, you can worry about putting it in your code.</SPAN><BR /><SPAN> - Consider installing Florian Maul's JavaScript console if you have not already.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Thu, 15 Aug 2013 23:45:17 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-queries-on-nodes-outside-of-company-home/m-p/305345#M258475 jpotts 2013-08-15T23:45:17Z