Index: OBJTimpl/PM/OBJTIdentNrMappingRepository.cls.xml =================================================================== diff -u -r66508 -r66565 --- OBJTimpl/PM/OBJTIdentNrMappingRepository.cls.xml (.../OBJTIdentNrMappingRepository.cls.xml) (revision 66508) +++ OBJTimpl/PM/OBJTIdentNrMappingRepository.cls.xml (.../OBJTIdentNrMappingRepository.cls.xml) (revision 66565) @@ -13,8 +13,12 @@ TECH.Persistent @@ -43,6 +47,17 @@ } ]]> + + +OBJTItemID:%String +%ResultSet + + Index: OBJTimpl/PM/OBJTIdentNrMapping.cls.xml =================================================================== diff -u -r66508 -r66565 --- OBJTimpl/PM/OBJTIdentNrMapping.cls.xml (.../OBJTIdentNrMapping.cls.xml) (revision 66508) +++ OBJTimpl/PM/OBJTIdentNrMapping.cls.xml (.../OBJTIdentNrMapping.cls.xml) (revision 66565) @@ -9,16 +9,36 @@ %String - + %String + + + + + +Prod.Product + + %Boolean $$$false 1 + +OBJTItemID + + + +ItemID +1 + + %Library.CacheStorage ^OBJTimpl.PM.OBJTIdentNr9F1FD @@ -27,17 +47,18 @@ ^OBJTimpl.PM.OBJTIdentNr9F1FI ^OBJTimpl.PM.OBJTIdentNr9F1FS -listnode - %%CLASSNAME ItemID -ADUOBJItemID +OBJTItemID + +Product + Index: OBJTimpl/PM/OBJTIdentLookupService.cls.xml =================================================================== diff -u -r66534 -r66565 --- OBJTimpl/PM/OBJTIdentLookupService.cls.xml (.../OBJTIdentLookupService.cls.xml) (revision 66534) +++ OBJTimpl/PM/OBJTIdentLookupService.cls.xml (.../OBJTIdentLookupService.cls.xml) (revision 66565) @@ -18,6 +18,13 @@ 1 + + + + OBJTIdentNrMappingRepository:OBJTimpl.PM.OBJTIdentNrMappingRepository="",Logger:vhLib.Logger="" 1 @@ -37,10 +44,9 @@ try { #dim ResultSetIterator as TECH.ResultSetIterator #dim ResultSet as TECH.ResultSet - Set ResultSet = ..SQLConnection.GetResultSet("select itemid,aduobjitemid from INVENTTABLE where dataareaid = 'vhbe' and itemid <> ADUOBJITEMID and ADUOBJITEMID is not null and ADUOBJITEMID <> ''") + Set ResultSet = ..SQLConnection.GetResultSet("select itemid,aduobjitemid from INVENTTABLE where dataareaid = 'vhbe' and ADUOBJITEMID is not null and ADUOBJITEMID <> '' ") Do ..OBJTIdentNrMappingRepository.VerwijderAlle() - Set ResultSetIterator = ##class(TECH.ResultSetIterator).%New(ResultSet) While (ResultSetIterator.HasNext()){ #dim rs as TECH.ResultSet @@ -63,15 +69,25 @@ AdminIdentNr:%String %String + + +OBJTItemID:%String +TECH.Iterator + +