Hello
I have SQL list (one of many) of 6000 relations of groups to a specific documents.
I want to clean-it up in bulk to leave only Owner, and then I want to bulk update it so just 2 relations are made tov every single document from the list.
If you want to Visualize it:
Document #112233 have relation with Group 1, Group 2, Group 3, Group 4, Group N+1, Owner
I want to remove all groups (so Owner remains) from document #112233, and then update it again, with Group 2 and Group 7, only.
Then multiply that situation 1000+ documents or more.
Can someone point me to the scripts that were prepared to run that change, or any other solution? This is first update from many that will happen, so the script would be very handy. I am myself quite amateur with that.