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

[rsurya037]

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 rest call

http://alfresco.dev.com/alfresco/api/-default-/public/alfresco/versions/1/nodes/-root-/children?relativePath='path'&skipCount=0&maxItems=40&include=isLocked&where=(nodeType='folder')

do we have any option like either nodeType in ('folder', 'document')  or nodeType!='email'

Can any one help me on this.

[afaust]

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.

[f1mahesh]

Hi

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