with scrums as ( select sr.requestId, sr.trackingId, sr.statusCode, sr.description, mem.lastName as requestedBy, case when sr.assignedTo < 0 then 'Unassigned' else mem2.lastName end assignedTo, opsStatus, opsAction, opsRequestTime, opsRequestUser, opsUser, opsStatusTime from tbl_SCRUM_Requests sr with (nolock) inner join tbl_FSPRO_Members mem with (nolock) on mem.fspro_userId = sr.opsRequestUser left outer join tbl_FSPRO_Members mem2 with (nolock) on mem2.fspro_userId = sr.opsUser where sr.ownerId = #client.usr_acctpk# and sr.ownerType = '#client.usr_accttype#' ) #forJSON( 'scrums', attributes.datastore, 'opsRequestTime desc' )#