topic Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client in Nuxeo Forum

How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Jyothsna_SM1 — Wed, 16 Oct 2019 07:42:44 GMT

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Gregory_Carlin — Wed, 16 Oct 2019 07:54:51 GMT

Hello,

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Patrick_Abgrall — Wed, 16 Oct 2019 11:34:52 GMT

A guess of answer from https://doc.nuxeo.com/nxdoc/nxql/ :

ecm:ancestorId: the id of an ancestor of the document (parent, grand-parent, etc., up to the root). This is only useable in a WHERE clause with the syntax ecm:ancestorId = 'some-doc-id' or ecm:ancestorId <> 'some-doc-id'. It's an alternative to ecm:path STARTSWITH '/some/doc/path' if you know the id instead of the path. See also ecm:path. (Since Nuxeo 5.9.6)

So If you're looking for a NXQL query to be used in a Nuxeo client, SELECT * FROM Folder WHERE ecm:ancestorId = <top folder id> or SELECT * FROM Document WHERE ecm:ancestorId = <top folder id> AND ecm:primaryType IN ('Folder', 'your custom type'...) might look like an answer to your question.

Would you want only first level subfolders, the NXQL query would look like: SELECT * FROM Folder WHERE ecm:parentId= <top folder id> or SELECT * FROM Document WHERE ecm:parentId = <top folder id> AND ecm:primaryType IN ('Folder', 'your custom type'...)

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Jyothsna_SM1 — Fri, 18 Oct 2019 05:05:57 GMT

Hi,

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Jyothsna_SM1 — Fri, 18 Oct 2019 05:13:32 GMT

Hi Patrick,

Getting all the sub-folders of a folder worked. Is there any way I can get sub-folders only till required level. I mean if I need only till second level or third level. Can we control how many levels to get?

Thanks in advance!!

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Jyothsna_SM1 — Fri, 18 Oct 2019 05:14:04 GMT

Hi Patrick,

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Patrick_Abgrall — Fri, 18 Oct 2019 06:00:16 GMT

There is nothing out of the box except all levels or first level. You can however automate your custom need using some JavaScript automation,

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Patrick_Abgrall — Fri, 18 Oct 2019 06:00:55 GMT

There is nothing out of the box except all levels or first level. You can however automate your custom need using some JavaScript automation,

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Jyothsna_SM1 — Fri, 18 Oct 2019 06:47:21 GMT

I'm working on the backend only with java client I have no idea about java script. Is there a way we can do it on backend

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

Bhagat__Singh — Wed, 22 Jan 2020 03:54:42 GMT

hi Gregory [Gregory Carlin](https

Re: How do I get the subfolders of a subfolder in nuxeo just by iterating in one go using nuxeo client

a_c — Wed, 29 Jan 2020 22:51:33 GMT

Hello [Bhagat Singh](https