Index: vhLibLogging.csp
===================================================================
diff -u -r109 -r113
--- vhLibLogging.csp	(.../vhLibLogging.csp)	(revision 109)
+++ vhLibLogging.csp	(.../vhLibLogging.csp)	(revision 113)
@@ -215,6 +215,7 @@
 	<BR>
 	<PRE>#(sqlLOGAllFields)#</PRE>
 	<PRE>#(" ... WHERE (Datum = '"_($$FormatDateTime^vhLib("MM/DD/YYYY",$H))_"' AND Detail [ 'zoekterm')")#</PRE>
+	<PRE>#(" ... WHERE (Actie IN ('DOM.AKP.event.ProductToelevLijnGemaakt','DOM.VKP.event.ProductOrderLijnGemaakt','DOM.PM.event.AdministratiefProductGemaaktEvent','ProductToelevLijnEventData'))  AND (Detail [ '...ID')")#</PRE>
 	<form name="theForm" method="post">
 		<table cellspacing="5">
 			<tr valign="top">
@@ -423,7 +424,7 @@
 	}
 	Set LogViewerHelper=##class(vhLib.LogViewer).%New()
 	set MaxRows = $get(%request.Data("MAXROWS",1),1000)
-	Set AantalDagen = 0   ; 15
+	Set AantalDagen = 1   ; 15
 	
 	Set BijkomendeCondities = ##class(%ListOfDataTypes).%New()
 	#dim Veld As %String = $O(%request.Data(""))
@@ -444,6 +445,8 @@
 	Set sqlLOGAllFields="SELECT Datum, Tijd, Groep, Niveau, Actie, JobID, SessionID, GekendeExceptie->StoryID, DetailTrunc As Detail,  ID , Gebruiker, LessDetail, MainIndex , Namespace , RemoteIP , Server , ProgLabel , SubID  " 
 	Set sqlLOG=LogViewerHelper.GeefSqlStatementMetFilters(AantalDagen, ##class(TECH.ArrayOneDimIterator).%New(.arFilterGroepen), ##class(TECH.ArrayOneDimIterator).%New(.arFilterNiveaus),BijkomendeCondities, EnkelTeTrierenOfBehandelen)
 	Set sqlLOG=$$$Replace(sqlLOG, "vhLib.Logging.","")
+	Set sqlLOG=$$$Replace(sqlLOG, " WHERE "   , $$$CRLF_"   WHERE "   )
+	Set sqlLOG=$$$Replace(sqlLOG, " ORDER BY ", $$$CRLF_"   ORDER BY ")
 	
 	; SQLs to be displayed
 	Set sqlActive=$G(%request.Data("QUERY",1),sqlLOG)