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

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.

Find more posts tagged with

Comments

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)