Many customers cannot accept the ProjectServer interface. Users can display pages according to their own needs, but most domestic users like a certain style. I just want such a page, no personal customization.
The only way is to embed the webpart in the project center yourself, which has always been a problem for displaying projects based on logged-in user permissions.
After querying N data, find the corresponding SQL statement.
declare @PermUid UniqueIdentifier;
set @PermUid = 'a120a079-75bc-4f0f-b376-3fb0ae9ac940';
declare @ViewUid UniqueIdentifier;
set @ViewUid = '3524BB38 -C387-4D21-BCDC-CDBC33305AD8';
declare @ResUid UniqueIdentifier;
set @ResUid = '47390293-429A-4A7B-AE27-D004CA19DAAF';
select * from dbo.MSP_WEB_FN_SE C_GetAllProjectsResCanViewByViewID( @ResUid, @PermUid, @ViewUid, 3)
ViewUid Find [WSEC_OBJ_UID] according to [MSP_WEB_SECURITY_CATEGORY_OBJECTS] PermUid According to WSEC_FEA_ACT_UID of MSP_WEB_SECURITY_SP_CAT_PERMISSIONS Found.
I won’t introduce you where to find ResUid.
The test is as follows