As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
How to get all children for a node with negative condition like where=(nodeType!='email')
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.
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.
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