Třídová akce

Kód:

1

Tělo:

SELECT T.ID, T.AssignedTo_ID AS User_ID
FROM Tasks T
JOIN PMStates S on S.ID = T.PMState_ID AND NOT (S.SystemState IN (3, 4))
LEFT JOIN TaskNotifications TN ON TN.Task_ID = T.ID AND TN.User_ID = T.AssignedTo_ID AND TN.Kind = 4
WHERE TN.ID IS NULL AND T.AssignedTo_ID IS NOT NULL
AND T.Deadline$DATE > 0 AND T.Deadline$DATE < (:DEADLINE + 1)

UNION

SELECT T.ID, T.Owner_ID AS User_ID
FROM Tasks T
JOIN PMStates S on S.ID = T.PMState_ID AND NOT (S.SystemState IN (3, 4))
LEFT JOIN TaskNotifications TN ON TN.Task_ID = T.ID AND TN.User_ID = T.Owner_ID AND TN.Kind = 4
WHERE TN.ID IS NULL
AND T.Deadline$DATE > 0 AND T.Deadline$DATE < (:DEADLINE + 1)

Generated by ABRA Software a.s. 27.10.2021 16:34:54