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

[Gregory_Carlin]

Hello,

[Patrick_Abgrall]

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'...)

[Jyothsna_SM1]

Hi,

[Jyothsna_SM1]

Hi Patrick,

[Patrick_Abgrall]

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

[Jyothsna_SM1]

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!!

[Patrick_Abgrall]

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

[Jyothsna_SM1]

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

[Bhagat__Singh]

hi Gregory [Gregory Carlin](https