Description
Extracts historical data for metrics enabled for consider for scoring = Yes within a specific period and client.
Query :
Extracts historical data for metrics enabled for consider for scoring = Yes within a specific period and client.
Query :
Select SessionUid,SceneUid,ProgramArea,ProgramId,ProgramName,ProgramItemId,ProgramItemName,ActualValue,ScoreValue,MaxPoints from vwProgramItemMetricsActualList where ClientId = 221 and ProgramId = '1818' and ScoringEnabled = 1 and CreatedOn >= '2025-09-01' and CreatedOn < '2025-10-01'