projects log
{ts '2025-01-30 13:09:46'} SQL
declare @ownerId int = 207 ;
            declare @ownerType varchar(3) = '207' ;
            declare @userId int = 3822275 ;


            select projectId
              from tbl_WRK_Projects with (nolock)
              where ownerId = @ownerId
              and ownerType = @ownerType
              and projectOwnerUserId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'USR'
              and os.objectType = 'WRP'
              and os.linkId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
              inner join tbl_SEC_MemGrpLink mgl with (nolock)
                 on mgl.groupId = os.linkId
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'GRP'
              and os.objectType = 'WRP'
              and mgl.fspro_userId = @userId

{ts '2025-01-30 13:10:58'} SQL
declare @ownerId int = 207 ;
            declare @ownerType varchar(3) = '207' ;
            declare @userId int = 3822275 ;


            select projectId
              from tbl_WRK_Projects with (nolock)
              where ownerId = @ownerId
              and ownerType = @ownerType
              and projectOwnerUserId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'USR'
              and os.objectType = 'WRP'
              and os.linkId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
              inner join tbl_SEC_MemGrpLink mgl with (nolock)
                 on mgl.groupId = os.linkId
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'GRP'
              and os.objectType = 'WRP'
              and mgl.fspro_userId = @userId

{ts '2025-01-30 13:13:01'} SQL
declare @ownerId int = 207 ;
            declare @ownerType varchar(3) = '207' ;
            declare @userId int = 3822275 ;


            select projectId
              from tbl_WRK_Projects with (nolock)
              where ownerId = @ownerId
              and ownerType = @ownerType
              and projectOwnerUserId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'USR'
              and os.objectType = 'WRP'
              and os.linkId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
              inner join tbl_SEC_MemGrpLink mgl with (nolock)
                 on mgl.groupId = os.linkId
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'GRP'
              and os.objectType = 'WRP'
              and mgl.fspro_userId = @userId

{ts '2025-01-30 13:15:44'} SQL
declare @ownerId int = 207 ;
            declare @ownerType varchar(3) = '207' ;
            declare @userId int = 3822275 ;


            select projectId
              from tbl_WRK_Projects with (nolock)
              where ownerId = @ownerId
              and ownerType = @ownerType
              and projectOwnerUserId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'USR'
              and os.objectType = 'WRP'
              and os.linkId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
              inner join tbl_SEC_MemGrpLink mgl with (nolock)
                 on mgl.groupId = os.linkId
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'GRP'
              and os.objectType = 'WRP'
              and mgl.fspro_userId = @userId

{ts '2025-01-30 13:17:28'} SQL
declare @ownerId int = 207 ;
            declare @ownerType varchar(3) = '207' ;
            declare @userId int = 3822275 ;


            select projectId
              from tbl_WRK_Projects with (nolock)
              where ownerId = @ownerId
              and ownerType = @ownerType
              and projectOwnerUserId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'USR'
              and os.objectType = 'WRP'
              and os.linkId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
              inner join tbl_SEC_MemGrpLink mgl with (nolock)
                 on mgl.groupId = os.linkId
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'GRP'
              and os.objectType = 'WRP'
              and mgl.fspro_userId = @userId

{ts '2025-01-30 13:22:07'} SQL
declare @ownerId int = 207 ;
            declare @ownerType varchar(3) = 'MFR' ;
            declare @userId int = 3822275 ;


            select projectId
              from tbl_WRK_Projects with (nolock)
              where ownerId = @ownerId
              and ownerType = @ownerType
              and projectOwnerUserId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'USR'
              and os.objectType = 'WRP'
              and os.linkId = @userId

            union all

            select os.objectId
              from tbl_SEC_ObjectSharing os with (nolock)
              inner join tbl_SEC_MemGrpLink mgl with (nolock)
                 on mgl.groupId = os.linkId
            where os.ownerId = @ownerId
              and os.ownerType = @ownerType
              and os.linkType = 'GRP'
              and os.objectType = 'WRP'
              and mgl.fspro_userId = @userId