adm_report_folders_v

Folder reporting view showing hierarchy, content counts and status information.

Access scope — Administrative reporting

Applies NO ADM user-access filter. Every matching row in the instance is returned, whoever is querying, and establishing an ADM context does not narrow it. Treat it as an administrative interface: anything built on it carries the whole authorization decision itself.

Overview

Group: Administrative reporting

Category: Folders - Folder hierarchy and organization analysis

Use Cases

• Folder hierarchy analysis
• Content organization review

Columns

The view contains 17 columns providing comprehensive information:

Column Name	Description
folder_id	Primary key of the folder.
parent_folder_id	Foreign key to the parent folder (null for root folder).
folder_name	Name of the folder (single path segment).
folder_path	Full hierarchical path of the folder.
description	Optional description of the folder purpose.
is_system_folder	Y if the folder is managed by the system.
created_date	Timestamp when the folder was created.
created_by	User who created the folder.
updated_date	Timestamp when the folder was last updated.
updated_by	User who last updated the folder.
deleted_flag	Y if the folder has been soft-deleted.
deleted_date	Timestamp when the folder was soft-deleted.
deleted_by	User who soft-deleted the folder.
folder_status	A single label for the folder, in priority order: DELETED if the folder is in the trash, else SYSTEM if ADM manages it, else ACTIVE. A deleted system folder reads as DELETED, so read deleted_flag and is_system_folder when both matter.
direct_child_folders	Count of immediate child folders that are not in the trash. Takes no account of who is asking, so it can be higher than the number of children the current user may see.
direct_documents	Count of documents directly in this folder, excluding trashed ones but INCLUDING archived ones - so it is not the number a user would see listed in the folder, and it takes no account of who is asking. Count adm_my_documents_v grouped by folder_id for that.
folder_depth	Number of path segments: the filesystem root is 0, /users and /groups are 1, a user or group home is 2.

Description: Comprehensive reporting view for folders showing hierarchy, content counts, and status information for easy inspection of the folder structure. ADMINISTRATIVE SCOPE: no ADM user-access filter is applied - every row in the instance is returned regardless of who is querying. For a session-scoped interface use adm_my_folders_v.

Key Features

• Folder depth calculation
• Content counts
• Hierarchy visualization
• System vs user folders

Related Views

Other views in the Folders category:

• adm_my_folders_v