Description
Retrieves sessions and locations classified as Near and Far from Survey Review attributes.
Query :
Retrieves sessions and locations classified as Near and Far from Survey Review attributes.
Query :
SELECT A.ClientName,A.BottlerName,A.SessionUid,A.SurveyLocation,CAST((A.SurveyDateTime AT TIME ZONE 'UTC'AT TIME ZONE 'Central Standard Time (Mexico)') AS datetime) AS SurveyDateTime_MX FROM vwClaimReportList A WHERE A.ClientId = 408 AND CAST((A.SurveyDateTime AT TIME ZONE 'UTC'AT TIME ZONE 'Central Standard Time (Mexico)') AS datetime) >= '2026-07-01' ORDER BY SurveyDateTime_MX;