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; } } }

LR[ora] to list folders with highest numbers of objects within?

Thomas_Gudella_(tgudella_-_(deleted))

Hello,I need a LR that lists the top 20 of folders/containers with the most children in it.It must be some correlation Dtree.DataIA and Dtree.ParentID grouped and sorted - but I'm a SQL novice.Any advice would be appreciated.Best regards, Tom.

Find more posts tagged with

Comments

Martin_Gäckler

select * from dtree where subtype=0order by childcount descthen restrict the report on 20 itemsHope this helpsMartin

Thomas_Gudella_(tgudella_-_(deleted))

Thanks a lot.Somehow I missed the column childcount...Best regards, Tom.