UPDATE IGNORE #Request.prefix_db_lookup#.Coding_Request
SET Coding_status = '#url.status#',
Completed_Date = '#DATEFORMAT(now(),"yy-mm-dd")#',
Updated_by = '#Session.MM_USID#'
where ID = '#url.coding_id#'
UPDATE IGNORE #Request.prefix_db_lookup#.Coding_Request
SET Assigned_to = '#url.assignee#',
Updated_by = '#Session.MM_USID#'
where ID = '#url.coding_id#'
SELECT *
FROM #Request.prefix_db_lookup#.Coding_Request
JOIN #Request.prefix_db_lookup#.Agency on Agency.Agency_ID = Coding_Request.Agency_ID
Where Coding_Request.Deleted <> 1
and Coding_Request.Coding_status != 'Complete'
AND (message_indicate NOT LIKE '%Identified%' OR message_indicate is null)
AND YEAR(Coding_Request.Request_Date) = YEAR(CURRENT_DATE)
AND (MONTH(Coding_Request.Request_Date) >= MONTH(CURRENT_DATE - INTERVAL 1 MONTH))
ORDER BY Coding_Request.Created_Date DESC
coding_track = CreateObject("Component", "coding");
today_completed_list = coding_track.getCompletdcount('today');
yesterday_completed_list = coding_track.getCompletdcount('yesterday');
sevendays_completed_list = coding_track.getCompletdcount('sevendays');
tab1 = coding_track.GetCodingRequests(1);
tab2 = coding_track.GetCodingRequests(2);
tab3 = coding_track.GetCodingRequests(3);
tab4 = coding_track.GetCodingRequests(4);
tab5 = coding_track.GetCodingRequests(5);
get_users = coding_track.get_coding_users();
getcodingstatus =coding_track.get_codingstatus();
HHA System Administration