Task list database table
From TaskDepender
(→Design) |
(→Create the table) |
||
Line 36: | Line 36: | ||
OR | OR | ||
(SELECT COUNT(ContainerId) from Deliverables where Deliverables.ContainerId=t.Id AND Deliverable.CloneId=0)>0 IsContainer | (SELECT COUNT(ContainerId) from Deliverables where Deliverables.ContainerId=t.Id AND Deliverable.CloneId=0)>0 IsContainer | ||
− | FROM Tasks t WHERE ContainerId=(SELECT Value FROM StateVariables WHERE | + | FROM Tasks t WHERE ContainerId=(SELECT Value FROM StateVariables WHERE Key='CurrentContainerId') |
</syntaxhighlight> | </syntaxhighlight> | ||