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)
Slack: https://hee-nhs-tis.slack.com/
Jira issues: https://hee-tis.atlassian.net/issues/?filter=14213