Is there a SQL query to find the number of folders in every view in a project?
The following SQL query will retun a count of every folder and also display the view the folders are in.
SELECT COUNT (Syn_Folder.ID) as
"No. of Folders", Syn_View.Name as "View"
FROM Syn_Folder, Syn_View
WHERE Syn_Folder.ViewID = Syn_View.ID
GROUP BY Syn_View.Name
Output will look something like this:
|No. of Folders||View|