topic Re: How to get all children for a node with negative condition like where=(nodeType!='email') in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/how-to-get-all-children-for-a-node-with-negative-condition-like/m-p/95702#M28148 <HTML><HEAD></HEAD><BODY><P>The children operation is supposed for "simple" lookups without complex filtering conditions. For anything more complex, you should use the actual search / query operation. With Alfresco FTS / CMIS Query Language and Transactional Metadata Query (TMQ) capabilities you can create operations with dynamic restrictions that are transactionally consistent and not dependent on SOLR.</P></BODY></HTML> Wed, 26 Jun 2019 18:30:20 GMT afaust 2019-06-26T18:30:20Z How to get all children for a node with negative condition like where=(nodeType!='email') https://connect.hyland.com/t5/alfresco-forum/how-to-get-all-children-for-a-node-with-negative-condition-like/m-p/95701#M28147 How to get all children for a node with negative condition like where=(nodeType!='email')GET&nbsp;/nodes/{nodeId}/children&nbsp; (this is the endpoint that am using from alfresco api explorer)For example if we have 3 different nodeTypes(folder, document, email)how to get the folders and document in a single r Wed, 26 Jun 2019 13:38:33 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-get-all-children-for-a-node-with-negative-condition-like/m-p/95701#M28147 rsurya037 2019-06-26T13:38:33Z Re: How to get all children for a node with negative condition like where=(nodeType!='email') https://connect.hyland.com/t5/alfresco-forum/how-to-get-all-children-for-a-node-with-negative-condition-like/m-p/95702#M28148 <HTML><HEAD></HEAD><BODY><P>The children operation is supposed for "simple" lookups without complex filtering conditions. For anything more complex, you should use the actual search / query operation. With Alfresco FTS / CMIS Query Language and Transactional Metadata Query (TMQ) capabilities you can create operations with dynamic restrictions that are transactionally consistent and not dependent on SOLR.</P></BODY></HTML> Wed, 26 Jun 2019 18:30:20 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-get-all-children-for-a-node-with-negative-condition-like/m-p/95702#M28148 afaust 2019-06-26T18:30:20Z Re: How to get all children for a node with negative condition like where=(nodeType!='email') https://connect.hyland.com/t5/alfresco-forum/how-to-get-all-children-for-a-node-with-negative-condition-like/m-p/95703#M28149 <P>Hi</P><P>Could you please assist how to user negation in where clause in Alfresco APIs.</P><P>For example in below URL I want to filert all the values that are not like '<SPAN><STRONG>/alfresco-access/login/user</STRONG></SPAN>' but oracle query pattern is not working. Is there any other way to user not like filter.&nbsp;</P><P><SPAN>http://&lt;IP&gt;:8080/alfresco/api/-default-/public/alfresco/versions/1/audit-applications/alfresco-access/audit-entries?where=(<STRONG>valuesKey !='/alfresco-access/login/user'</STRONG> and createdAt BETWEEN ('2023-11-17T00:00:01.000+0000','2023-11-17T23:59:59.000+0000'))&amp;skipCount=0&amp;maxItems=500&amp;orderBy=createdAt ASC&amp;include=values1</SPAN></P> Thu, 23 Nov 2023 17:12:02 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-get-all-children-for-a-node-with-negative-condition-like/m-p/95703#M28149 f1mahesh 2023-11-23T17:12:02Z