Index: APPS/Halux/Planning/impl/Queries.cls.xml =================================================================== diff -u -r1324 -r1345 --- APPS/Halux/Planning/impl/Queries.cls.xml (.../Queries.cls.xml) (revision 1324) +++ APPS/Halux/Planning/impl/Queries.cls.xml (.../Queries.cls.xml) (revision 1345) @@ -69,7 +69,7 @@ FROM APPS_Halux_Planning_impl.ToeleveringInfo TI JOIN APPS_Halux_Planning_impl.ProductInfo PI ON TI.ID = PI.ToeleveringInfoID JOIN APPS_Halux_Planning_impl.ActiviteitInfo AI ON PI.ID = AI.ProductInfoID - WHERE CAST(TI.Gepland As DATE) = :Datum AND ((:Categorie is null) OR (PI.Categorie = :Categorie)) + WHERE ((:Datum is null and TI.Gepland is null) OR CAST(TI.Gepland As DATE) = :Datum) AND ((:Categorie is null) OR (PI.Categorie = :Categorie)) GROUP BY CAST(TI.Gepland As DATE), AI.Naam, TI.ToeleveringNummer, PI.ToeleveringLijnNr]]>