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 |
| 232 | StarDraw |
| 4565 | Main Development |
| 6652 | Patch View |
Support
Documentation
Learning Services
Partner Programs