Index: CSPimpl/Tools/TopErrormeldingen/Service.cls.xml
===================================================================
diff -u
--- CSPimpl/Tools/TopErrormeldingen/Service.cls.xml	(revision 0)
+++ CSPimpl/Tools/TopErrormeldingen/Service.cls.xml	(revision 49905)
@@ -0,0 +1,45 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="CSPimpl.Tools.TopErrormeldingen.Service">
+<Super>TECH.RegisteredObject</Super>
+
+<Property name="QueryAPI">
+<Type>TECH.Query.QueryAPI</Type>
+<Private>1</Private>
+</Property>
+
+<Method name="%OnNew">
+<FormalSpec>QueryAPI:TECH.Query.QueryAPI=""</FormalSpec>
+<Private>1</Private>
+<ProcedureBlock>1</ProcedureBlock>
+<ReturnType>%Status</ReturnType>
+<ServerOnly>1</ServerOnly>
+<Implementation><![CDATA[
+	Set ..QueryAPI = $$$Implementation(QueryAPI,##class(TECH.Context).Instance().GeefQueryAPI())
+	
+	Quit $$$OK
+]]></Implementation>
+</Method>
+
+<Method name="GeefLijnenIterator">
+<ReturnType>TECH.Iterator</ReturnType>
+<Implementation><![CDATA[
+	#dim Datum As %Date = ##class(TECH.DateTime).%New().CurrentDateVoorQueries()
+
+	#dim SqlStatement As TECH.String = "SELECT Count(ID) As Aantal, Max(Tijd) As LaatsteTijdstip, Groep, Actie FROM vhLib.Logging WHERE (Datum = ? AND (Niveau = 'E')) GROUP BY Groep, Actie ORDER BY Aantal DESC, LaatsteTijdstip DESC"
+
+	#dim ResultSet As TECH.ResultSet = ..QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement,$Lb(Datum)))
+
+	Set ErrorMeldingen = ##class(%ListOfDataTypes).%New()
+
+	While ResultSet.Next() {
+		Do ErrorMeldingen.Insert($listbuild(ResultSet.GetData(1),$ztime(ResultSet.GetData(2)),ResultSet.GetData(3),ResultSet.GetData(4)))	
+	}
+	
+	Quit ##class(TECH.ListIterator).%New(ErrorMeldingen)
+]]></Implementation>
+</Method>
+</Class>
+
+
+</Export>