Monday, December 10, 2012 2:44 AM
Hey Does Anyone know how to hard delete a leaf member using the API ? and not by using the staging process, ETL etc.....
Monday, December 10, 2012 5:38 AM
how about this then, Bad practice i know, but since i cant wait for the staging processing cycle nor do i want to inundate the server by reducing the processing frequency I've opted for a custom stored proc
it should be self explanatory.
here is a stored proc that I whacked together which i am calling in my code.
create proc usr.HardDeleteMemberByCode
declare @SQL varchar(max), @entitytable varchar(60)
select @entitytable = EntityTable
from mdm.tblEntity E
Inner join mdm.tblModelVersion mv
on mv.Model_ID = e.Model_ID
inner join mdm.tblModel m
on m.ID = mv.ID
where m.Name = @ModelName and
mv.Name = @VersionName and
E.Name = @EntityName
set @SQL = 'delete from mdm.' + @entitytable + ' where code = ''' + @MemberCode + ''''
P.S if anyone knows the API method call please let me know
- Marked As Answer by wombelite Monday, December 10, 2012 5:40 AM