Untitled

 avatar
unknown
plain_text
a year ago
782 B
6
Indexable
--select * from mrms.lg_masterParamSetComponents lmpsc;
--
--select * from mrms.lg_masterParamSetComponents lmpsc 
--where relationId in (42,44,46);

update mrms.lg_masterParamSetComponents set 
isHeader = 0,
isActive = 0
where relationId in (42,44,46);

--select * from mrms.lg_masterParamSetComponents lmpsc 
--where relationId in (43,45,47);

update mrms.lg_masterParamSetComponents set 
parent = 0
where relationId in (43,45,47);

--select * from mrms.lg_paramSetComponents lpsc 
--where 
--lpsc.relationId in (42,43,44,45,46,47)
--and lpsc.parameterId = 6;

update mrms.lg_parameters set status = 'DRAFTED' where id = 2;

update mrms.lg_paramSetComponents set 
parentId = 0,
isActive = 1,
isHeader = 0,
isDeleted = 0
where relationId in (42,43,44,45,46,47)
and parameterId = 2;
Editor is loading...
Leave a Comment