LiveReport on pending tasks

Scott_Wallace

Do Tasks follow the folder structure ? Our contracts are all stored under a Contracts folder. I'd like to use a live report to show tasks that are currently "Pending" but only from this Contracts folder down I'm not interested in any other tasks in the system. Current Task SQLSELECT * FROM DTREEWHERE dtree.subtype=206AND dtree.status=0but I'd like to add somethingstart with dataid = ###### connect by parentid = prior dataidIs this possible ? Can tasks be sorted this way ?