SQL to Support DCSA

Owned by Jeremy Brockman
10 May 2023
1 min read

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)

Slack: https://hee-nhs-tis.slack.com/
Jira issues: https://hee-tis.atlassian.net/issues/?filter=14213