SELECT Communication.*,CommunicationSubjects.Subject FROM #Request.prefix_db_agency#.Communication
JOIN #Request.prefix_db_agency#.CommunicationSubjects ON CommunicationSubjects.CommSub_Id = Communication.CommSub_ID
WHERE Comm_ID = #url.ID#
UPDATE #Request.prefix_db_agency#.communication_to SET viewed = '#myDateTime#' WHERE Comm_Id = '#url.Id#' AND employee_id = '#session.EmployeeId#'
SELECT employee_id, viewed FROM #Request.prefix_db_agency#.communication_to WHERE Comm_ID = #url.ID#
ArrayAppend(assignees, #employee_id#);
ArrayAppend(dateViewed, #viewed#);
function stripHTML(str) {
return REReplaceNoCase(str,"<[^>]*>","","ALL");
}
SELECT Emp_ID, Emp_First, Emp_Last, "" AS eaType
FROM #Request.prefix_db_lookup#.pEmployee
WHERE pEmployee.Loc_ID = '#session.AgencyID#'
AND (Status = '0'
OR
Emp_ID IN (select employee_id from #Request.prefix_db_agency#.communication_to where comm_id = '#url.id#')
)
AND pEmployee.Emp_Type = 'Employee'
ORDER BY Emp_Last
SELECT Emp_ID, Emp_First, Emp_Last, "" AS eaType
FROM #Request.prefix_db_lookup#.pEmployee
WHERE Emp_Id = #GetComm.Record_Created_By#
SELECT pPatients.Patient_ID, pPatients.Pt_Last,
pPatients.Pt_First, pPatients.Pt_Middle,pPatients.Status, pPatients.Status
FROM #Request.prefix_db_agency#.pPatients
WHERE (pPatients.Pt_Last LIKE '%%' OR pPatients.Patient_Id = '%' )
AND pPatients.Loc_ID = '#session.AgencyID#'
AND Status < 2
ORDER BY pPatients.Pt_Last, pPatients.Pt_First
SELECT CommSub_Id, Subject FROM #Request.prefix_db_agency#.CommunicationSubjects WHERE Agency_Id = #session.AgencyId# OR Agency_Id < 0 ORDER BY Subject