dql query to get the list of Folders with the count for all the folders.
we don’t need to pass the specific folder path in the query and folder should Identify the main folder Name dynamically and it should generate the result set.
Basically we want DQL for pulling out
the YXZName folder name and folder path and the count of documents
inside the folders/Subfolders