HHA System Administration

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.DateCompleted IS NULL or i.DateCompleted = '2001-01-01' or Unresolved = 1) 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.DateCompleted > #Period# AND i.InternalMemo != '?? Bug (0)' ORDER BY i.DateCompleted DESC 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.DateCompleted != '' AND i.InternalMemo = '?? Bug (0)' ORDER BY i.DateCompleted DESC HHA System Administration Superadmin Home

Unresolved Problem Log

Ticket	When reported	Type	Problem	Step	Reported by	Agency	Support Tech	Resolved
style="color:red;">#Incident_ID#	#Incident#	#DATEFORMAT(DateCreated,"mm/dd/yyyy")# #TIMEFORMAT(DateCreated,"hh:mm tt")#	#DoingWhat#	#InternalMemo#	#Last_Name#, #First_Name#	#Agency_Name#	#AssignedTo#	Mark Resolved

[<< First 25] [< Previous 25] [Next 25 >] [Last 25 >>]

Resolved No-Bug Problem Log

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

Resolved Bugs

Ticket	When reported	Reported by	Support Tech	Resolved	Date/Time Read
#Incident_ID#	#DATEFORMAT(DateCreated,"mm/dd/yyyy")# #TIMEFORMAT(DateCreated,"hh:mm tt")#	#First_Name# #Last_Name#	#AssignedTo#	#DATEFORMAT(DateCompleted,"mm/dd/yyyy")# #TIMEFORMAT(DateCompleted,"hh:mm tt")#	#DATEFORMAT(DateRead,"mm/dd/yyyy")# #TIMEFORMAT(DateRead,"hh:mm tt")#