Index: AX/Uitgaand/PM/VestSpecOrdInst/impl/VestSpecOrdInstIterator.cls.xml =================================================================== diff -u -r48051 -r48349 --- AX/Uitgaand/PM/VestSpecOrdInst/impl/VestSpecOrdInstIterator.cls.xml (.../VestSpecOrdInstIterator.cls.xml) (revision 48051) +++ AX/Uitgaand/PM/VestSpecOrdInst/impl/VestSpecOrdInstIterator.cls.xml (.../VestSpecOrdInstIterator.cls.xml) (revision 48349) @@ -65,7 +65,7 @@ #dim SqlStatement as %String Set SqlStatement = "SELECT ID FROM Prod.Product WHERE isnull(Gentype,'')='' and korttekst not like 'GEN%' AND KortTekst NOT LIKE 'IO%' AND (NonAktief IS null OR NonAktief = '2')" _" UNION SELECT ID FROM Prod.Product WHERE KortTekst like 'GEN%' AND (NonAktief IS null OR NonAktief = '2') AND LeverancierNummer = '6332'" - _" UNION SELECT ID FROM Prod.Product WHERE GenerischeRoutine = '254796' UNION SELECT ID FROM Prod.Product WHERE ID = '1804877'" + _" UNION SELECT ID FROM Prod.Product WHERE GenerischeRoutine = '254796' UNION SELECT ID FROM Prod.Product WHERE ID IN (1804877,1174139,858490)" Set ..ResultSet = ..QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement)) ]]> Index: AX/Uitgaand/PM/ProductVertaling/impl/ProductVertalingIterator.cls.xml =================================================================== diff -u -r48051 -r48349 --- AX/Uitgaand/PM/ProductVertaling/impl/ProductVertalingIterator.cls.xml (.../ProductVertalingIterator.cls.xml) (revision 48051) +++ AX/Uitgaand/PM/ProductVertaling/impl/ProductVertalingIterator.cls.xml (.../ProductVertalingIterator.cls.xml) (revision 48349) @@ -68,7 +68,7 @@ #Dim SqlStatement as %String Set SqlStatement = "SELECT ID FROM Prod.Product WHERE isnull(Gentype,'')='' AND KortTekst NOT LIKE 'GEN%' AND KortTekst NOT LIKE 'IO%' AND (NonAktief IS null OR NonAktief = '2')" _" UNION SELECT ID FROM Prod.Product WHERE KortTekst like 'GEN%' AND (NonAktief IS null OR NonAktief = '2') AND LeverancierNummer = '6332'" - _" UNION SELECT ID FROM Prod.Product WHERE GenerischeRoutine = '254796' UNION SELECT ID FROM Prod.Product WHERE ID = '1804877'" + _" UNION SELECT ID FROM Prod.Product WHERE GenerischeRoutine = '254796' UNION SELECT ID FROM Prod.Product WHERE ID IN (1804877,1174139,858490)" /* // Indien nodig is hieronder een filter voorzien om het resultaat te beperken tot overzichtelijk, voor debugging: _" and ID in (1175,1988,2865,6945,161441,1342834,1432651)" Index: AX/Uitgaand/PM/ExtArtOmschrLev/impl/ExtArtOmschrLevIterator.cls.xml =================================================================== diff -u -r48051 -r48349 --- AX/Uitgaand/PM/ExtArtOmschrLev/impl/ExtArtOmschrLevIterator.cls.xml (.../ExtArtOmschrLevIterator.cls.xml) (revision 48051) +++ AX/Uitgaand/PM/ExtArtOmschrLev/impl/ExtArtOmschrLevIterator.cls.xml (.../ExtArtOmschrLevIterator.cls.xml) (revision 48349) @@ -90,7 +90,7 @@ TECH.Iterator 1 1