Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- command.CommandText = $@"INSERT INTO c_GDPREntity(c_ObjectId, c_isBeingProcessed)
- SELECT c_Id, 0 FROM c_Order WHERE c_id in(select c_orderid from c_OrderLine
- WHERE c_OrderLineType = 'service' AND c_Id in (SELECT c_OrderLineid FROM c_OrderLineStatusEvent
- WHERE (c_ChangedTo = 'completed' OR c_ChangedTo = 'cancelled') AND GETDATE() > DATEADD(DAY,{daysBeforeAnonymization}, c_ChangedAt)))
- AND c_Id NOT IN(SELECT c_ObjectId FROM c_GDPRObjectStatus)";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement