Query filter with sub-folder of a tree

[Mukesh_Kumar]

I have created subfolders inside Application(root) folder. e.g I have following sub-folders inside Application(root) folder. "Back office", "Front Office", Planning, "Solution Delivery", etc. Inside "Solution Delivery" I have another set of sub-folders ("BI", "MDM", Digital Solution, Oracle Practices, etc.

Now, I want to list the Applications which are contained only in a sub-folder. e.g. I want to list all application contained only in sub-folder "Oracle Practices".

Where and How can I write this query?

[lionel · Accepted solution]

Hello,

try this query :

Select [Folder of Applications] Into @FA Where [Parent Folder] Deeply &Name Or Name &Name
Select [Application] Where [Parent Folder] in @FA

Regards,

Lionel

[Mukesh_Kumar]

I was able to find these query which works for certain scenarios, but not all.

Select [Application] where [Parent Folder] = "Planning"

Select [Application] where [Parent Folder] = &"Folder"

Scenario for which it does not work.

The result shows the list of only those Applications which are directly under the folder (Parent Folder), but not anything under child/children folder.  What I wanted was, if I provide a folder name it should list everything underneath this folder also including it's child. I will be similar to providing the root node of a tree and the query will traverse entire tree.