Index: APPS/Halux/Planning/Activiteit/impl/ActiviteitPerBatchService.cls.xml =================================================================== diff -u -r70505 -r72230 --- APPS/Halux/Planning/Activiteit/impl/ActiviteitPerBatchService.cls.xml (.../ActiviteitPerBatchService.cls.xml) (revision 70505) +++ APPS/Halux/Planning/Activiteit/impl/ActiviteitPerBatchService.cls.xml (.../ActiviteitPerBatchService.cls.xml) (revision 72230) @@ -86,7 +86,7 @@ set qHandler = ##class(%XML.DataSet).%New("%DynamicQuery:SQL") #Dim Query As %String = "SELECT DISTINCT ProTimeID as PersNr,isnull(Foto,'') as Foto,isnull(FamilieNaam,'') as Achternaam,isnull(Voornaam,'') as Voornaam,isnull(Initialen,'') as Initialen " - do qHandler.Prepare(Query_" FROM APPS_HaLux_Planning_Activiteit_dto.Medewerker WHERE ProTimeID<>'' and (Activiteit=? or 'Allen'=?) and Bekwaamheidsniveau>2") + do qHandler.Prepare(Query_" FROM APPS_HaLux_Planning_Activiteit_dto.Medewerker WHERE (Activiteit=? or 'Allen'=?) and Bekwaamheidsniveau>2") do qHandler.Execute(Activiteit,Activiteit) quit qHandler