Index: WS/TBX/Order.cls.xml =================================================================== diff -u -r203 -r216 --- WS/TBX/Order.cls.xml (.../Order.cls.xml) (revision 203) +++ WS/TBX/Order.cls.xml (.../Order.cls.xml) (revision 216) @@ -983,6 +983,13 @@ Set:(ClientHostIP'?1.3N3(1"."1.3N)) ClientHostIP=$S(NewStatusH'<$$$shShownForKlant:"192.999.1.999", 1:"192.168.1.999") ; ATTENTION: if an ExternIP already present in the log, the order remains visible in Hist. Do ##class(cspBasis.GAProdTBox).SetOrderShowInHist(WSOrd.%Id(), WSOrd.KLNummer, ClientHostIP, WSOrd.WebDomain, $G(VhisieLogin)) Quit + + /* SQL-Statement om alle offertes van een klant te verbergen (in de historiek) : + +UPDATE WS_TBX.WebOrder Set ShowInHist='10' + WHERE (KLNummer = 16509) AND (webdomain = 'www.tandem-box.com') AND (BonType='OFF') + + */ ]]>