SQL to Support DCSA

SELECT

lli.LearningLogItemID

, da.UserID

, lli.LoggedByID AS DelegateAccountID

, llic.CompetencyID

, lli.LearningResourceReferenceID

, lli.Activity AS ResourceName

, lli.ExternalUri

, llic.AssociatedDate AS AddedDate

, lli.LastAccessedDate

, lli.DueDate

, lli.CompletedDate

FROM LearningLogItems AS lli

INNER JOIN LearningLogItemCompetencies AS llic ON lli.LearningLogItemID = llic.LearningLogItemID

INNER JOIN DelegateAccounts AS da ON lli.LoggedByID = da.ID

WHERE

(NOT (lli.LearningResourceReferenceID IS NULL))

AND (lli.ArchivedDate IS NULL)