Třídová akce

Kód:

1

Tělo:

SELECT
  TN.ID, 
  TN.Kind, 
  TN.Description,
  TN.CreatedBy_ID,
  CB.LoginName,
  TN.CreatedAt$DATE,
  TN.User_ID,
  SU.LoginName, 
  SUA.Email,
  T.ID,
  T.Owner_ID,
  TOW.LoginName,
  T.AssignedTo_ID,
  TAS.LoginName,
  T.Summary,
  T.Deadline$DATE,
  CH.Changes
FROM TaskNotifications TN
JOIN Tasks T ON T.ID = TN.Task_ID
JOIN SecurityUsers CB ON CB.ID = TN.CreatedBy_ID
LEFT JOIN TaskChanges CH on CH.ID = TN.Change_ID
JOIN SecurityUsers SU ON SU.ID = TN.User_ID
JOIN Addresses SUA ON SUA.ID = SU.Address_ID
JOIN SecurityUsers TOW ON TOW.ID = T.Owner_ID
JOIN SecurityUsers TAS ON TAS.ID = T.AssignedTo_ID
WHERE TN.SentAt$DATE = 0 AND TN.SeenAt$DATE = 0
ORDER BY TN.CreatedBy_ID, TN.User_ID, T.ID, TN.CreatedAt$DATE

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