nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oldest created folder in docbase

Lavanya_Soundararajan

Does anyone know how to fetch oldest created folder and also the folder which has maximum number of depths?

Thanks in advance

Find more posts tagged with

Comments

rajashankar

Hi,

Query to find folder which is oldest

select min(r_creation_date) as oldestdate from dm_folder

Regards

Raja

rajashankar

Query to find depth of folder

select r_object_id,object_name,count(i_ancestor_id) from dm_folder group by r_object_id,object_name having count(i_ancestor_id)>10 enable (row_based).

hope this helps