Project and Portfolio Management Practitioners Forum
cancel

Swapping the field values

SOLVED
Go to solution
Highlighted
sam.greg
Honored Contributor.

Swapping the field values

Hi,

we need to swap the value of 'Assigned To' to filed for two users.

So, all ITGs assigned to User1 should be assigned to User2, all ITGs assigned to User2 need to be assigned to User1.

Can you please tell me if there is way to do this.
2 REPLIES
Sangiliraja_1
Honored Contributor.

Re: Swapping the field values

Hi,

I am not sure i am getting your complete problem.

But if you know the user1 and user2, Try a mass update using Search Requests functionality on PPM.

Thanks
Sangiliraja.P
Mahen M
Acclaimed Contributor.
Solution

Re: Swapping the field values

Take a backup of the existing KCRT_Requests table and write a update Query by hard coding the Request ID's.

Regards,
Mahendran M