SOLVED

Project online: Status Manager Field

%3CLINGO-SUB%20id%3D%22lingo-sub-2112733%22%20slang%3D%22en-US%22%3EProject%20online%3A%20Status%20Manager%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2112733%22%20slang%3D%22en-US%22%3E%3CP%3EUpon%20deleting%20resources%2C%20I%20got%20this%20message%20%22%3CSPAN%3EThe%20resource%20is%20the%20assignment%20owner%20for%20....%20and%20cannot%20be%20deleted.%3C%2FSPAN%3E%22%20I%20am%20unable%20to%20query%20Status%20manager%20unlike%20other%20custom%20fields.%26nbsp%3B%20This%20allows%20me%20to%20see%20info.%20I%20need%20across%20all%20projects%20and%20know%20where%20to%20go%20and%20replace%20old%20resource%2Fstatus%20manager%20with%20new%20person.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%2C%20I%20query%20using%20task%20name%20which%20is%20time%20consuming%20and%20not%20productive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20query%20Status%20Manager%20and%20whether%20this%20is%20searchable.%26nbsp%3B%20Thank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2112733%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOnline%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ereporting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121113%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20online%3A%20Status%20Manager%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F953702%22%20target%3D%22_blank%22%3E%40NLuu-020321%3C%2FA%3E%26nbsp%3BAlso%20I%20would%20like%20to%20expand%20a%20bit%20more%20to%20help%20those%20who%20maybe%20new%20to%20Project%20and%20PBI.%3C%2FP%3E%3CP%3ETo%20get%20Status%20manager's%20name%2C%20you%20will%20need%20to%20compare%20two%20datasets%201)%20Resources%20and%202)%20Tasks.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20PBI%2C%20and%20get%20data%20via%20OData%20feed%20selection%20(put%20in%20your%20URL%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoursharepointsite.com%2Fsites%2Fyoursitename%2F_api%2FProjectdata%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoursharepointsite.com%2Fsites%2Fyoursitename%2F_api%2FProjectdata%3C%2FA%3E)%3C%2FP%3E%3CP%3EIn%20the%20Resources%20dataset%20retrieve%20ResourcesId%20and%20ResourceName.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Tasks%20dataset%2C%20retrieve%20Task%20name%2C%20Project%20Name%2C%20and%20Task%20status%20manager%20UID.%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20merge%20two%20datasources%20to%20find%20the%20Status%20manager's%20name%20residing%20in%20what%20project%20and%20which%20task.%3C%2FP%3E%3CP%3EWith%20that%20information%2C%20you%20know%20where%20to%20go%20make%20change%20and%20replace%20former%20status%20manager%20who%20left%20the%20company%20with%20the%20new%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2113067%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20online%3A%20Status%20Manager%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113067%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much%20Paul.%26nbsp%3B%20Cheers!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2112968%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20online%3A%20Status%20Manager%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2112968%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F953702%22%20target%3D%22_blank%22%3E%40NLuu-020321%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EUsing%20the%20Task%20endpoint%20in%20the%20ProjectData%20API%2C%20you%20will%20have%20the%26nbsp%3BTaskStatusManagerUID.%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Upon deleting resources, I got this message "The resource is the assignment owner for .... and cannot be deleted." I am unable to query Status manager unlike other custom fields.  This allows me to see info. I need across all projects and know where to go and replace old resource/status manager with new person.

 

Currently, I query using task name which is time consuming and not productive.

 

How do I query Status Manager and whether this is searchable.  Thank you.

 

3 Replies
best response confirmed by NLuu-020321 (Occasional Contributor)
Solution

Hello @NLuu-020321 ,

Using the Task endpoint in the ProjectData API, you will have the TaskStatusManagerUID.

Paul

@Paul Mather Thank you very much Paul.  Cheers!

@NLuu-020321 Also I would like to expand a bit more to help those who maybe new to Project and PBI.

To get Status manager's name, you will need to compare two datasets 1) Resources and 2) Tasks. 

I used PBI, and get data via OData feed selection (put in your URL:

https://yoursharepointsite.com/sites/yoursitename/_api/Projectdata)

In the Resources dataset retrieve ResourcesId and ResourceName. 

In the Tasks dataset, retrieve Task name, Project Name, and Task status manager UID. 

Then merge two datasources to find the Status manager's name residing in what project and which task.

With that information, you know where to go make change and replace former status manager who left the company with the new one.