topic How to get all children for a node with negative condition like where=(nodeType!='email') in Alfresco Forum

How to get all children for a node with negative condition like where=(nodeType!='email')

rsurya037 — Wed, 26 Jun 2019 13:38:33 GMT

How to get all children for a node with negative condition like where=(nodeType!='email')GET /nodes/{nodeId}/children (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

Re: How to get all children for a node with negative condition like where=(nodeType!='email')

afaust — Wed, 26 Jun 2019 18:30:20 GMT

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.

Re: How to get all children for a node with negative condition like where=(nodeType!='email')

f1mahesh — Thu, 23 Nov 2023 17:12:02 GMT

Could you please assist how to user negation in where clause in Alfresco APIs.

For example in below URL I want to filert all the values that are not like '/alfresco-access/login/user' but oracle query pattern is not working. Is there any other way to user not like filter.

http://<IP>:8080/alfresco/api/-default-/public/alfresco/versions/1/audit-applications/alfresco-access/audit-entries?where=(valuesKey !='/alfresco-access/login/user' and createdAt BETWEEN ('2023-11-17T00:00:01.000+0000','2023-11-17T23:59:59.000+0000'))&skipCount=0&maxItems=500&orderBy=createdAt ASC&include=values1