list sub items under a folder

Baber_Amin

Database: SQL Server 2012

 

Hi,

Can anyone confirm that it's the right way to list all items under a folder?

;WITH CTE AS

(

Select E.dataid, e.name, e.subtype, 0 Level , E.ParentId

From dtreecore E Where E.parentid=XXXXXXX

UNION ALL

Select E.dataid, e.name, e.subtype, c.Level + 1 , E.ParentId

From dtreecore E INNER JOIN CTE c on c.dataid = e.parentid

)

SELECT * FROM CTE

 

Nizar Ghazal

Hi Baber,

You want to avoid doing things against DTreeCore, directly, use the view, DTree, instead.

However, do you only want the items directly beneath it? Or all items in all subfolders?

Because, if you want to do the latter, you need to use DBrowseAncestors or one of the other ancestor tables, and use AncestorID to get everything that eventually leads up to a specific container.

Thanks.