SELECT * FROM #Request.prefix_db_lookup#.Incident i, #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_lookup#.Agency a WHERE e.Employee_ID = i.Employee_ID AND a.Agency_ID = i.Agency_ID and i.Agency_ID = #url.ID# and (i.DateCompleted IS NULL or i.DateCompleted = '2001-01-01') ORDER BY i.DateCreated SELECT * FROM #Request.prefix_db_lookup#.Incident i, #Request.prefix_db_lookup#.Employee e, #Request.prefix_db_lookup#.Agency a WHERE e.Employee_ID = i.Employee_ID AND a.Agency_ID = i.Agency_ID and i.Agency_ID = #url.ID# and i.DateCompleted != '' ORDER BY i.DateCompleted DESC HHA System Administration Superadmin Home

Unresolved Problem Log

Ticket When reported Problem Reported by Due for resolution Support Tech Resolved
#Incident_ID#
#DATEFORMAT(DateCreated,"mm/dd/yyyy")# #TIMEFORMAT(DateCreated,"hh:mm tt")#
#InternalMemo#
#Last_Name#
#AssignedTo#
#DATEFORMAT(DateCompleted,"mm/dd/yyyy")# #TIMEFORMAT(DateCompleted,"hh:mm tt")#
Mark Resolved



Resolved Problem Log

Ticket When reported Problem Reported by Support Tech Resolved Read?
#Incident_ID#
#DATEFORMAT(DateCreated,"mm/dd/yyyy")# #TIMEFORMAT(DateCreated,"hh:mm tt")#
#InternalMemo#
#Last_Name#
#AssignedTo#
#DATEFORMAT(DateCompleted,"mm/dd/yyyy")# #TIMEFORMAT(DateCompleted,"hh:mm tt")#
#Deleted#