Need SQL - Show all Tasks under a specific Node

Mathias_Dresske

I want a list of tasks (subtype 206) within ALL folders and subfolders of a specific start-folder.The following statement lists only files and folders although there is no criteria relating to the subtype.select d.*from dtree d, dtree pwhere d.parentid = p.dataidand d.dataid in (select dataid from dtree start with dataid = 6596360 connect by prior dataid = parentid)//6596360 is the DataId of the StartFolder.

Tim_Hunter

Tasks are related to the Task list using the parentid with a negative parentid unlike folders and like projects.This should do it for you (note I left in the Task List subtype)select d.*from dtree d, dtree pwhere d.parentid = p.dataidand d.dataid in (select dataid from dtree start with dataid = 6596360 connect by prior dataid = abs(parentid))and d.subtype in (204, 206)