with developers as ( select email from tbl_Fspro_members where ownerId = 78 and fsl_tablecode = 'MSC' and left( email, charIndex( '@', email ) - 1 ) in ( ) and email like '%@telusagcg.com' ) select m.lastName + ', ' + m.firstName as requestorName, r.statusCode, count(*) requestCount from tbl_SCRUM_Requests r with (nolock) inner join tbl_fspro_members m with (nolock) on m.fspro_userid = r.requestor and m.firstName != 'Van' where r.releaseName = and r.ownerId = 78 and r.ownerType = 'MSC' and m.email not in ( select email from developers ) group by m.firstName, m.lastName, r.statusCode select sum(requestCount_B) qaCount from qmd_crossTabLifecycle with developers as ( select email from tbl_Fspro_members where ownerId = 78 and fsl_tablecode = 'MSC' and left( email, charIndex( '@', email ) - 1 ) in ( ) and email like '%@telusagcg.com' ) select m.lastName + ', ' + m.firstName as requestorName, r.rank, count(*) requestCount from tbl_SCRUM_Requests r with (nolock) inner join tbl_fspro_members m with (nolock) on m.fspro_userid = r.requestor and m.firstName != 'Van' where r.releaseName = and m.email not in ( select email from developers ) and r.ownerId = 78 and r.ownerType = 'MSC' group by m.firstName, m.lastName, r.rank with developers as ( select email from tbl_Fspro_members where ownerId = 78 and fsl_tablecode = 'MSC' and left( email, charIndex( '@', email ) - 1 ) in ( ) and email like '%@telusagcg.com' ) select m.lastName + ', ' + m.firstName as requestorName, r.statusCode, r.trackingId, r.description from tbl_SCRUM_Requests r with (nolock) inner join tbl_fspro_members m with (nolock) on m.fspro_userid = r.requestor and m.firstName != 'Van' where r.releaseName = and r.statusCode = 'B' and r.ownerId = 78 and r.ownerType = 'MSC' and m.email not in ( select email from developers ) -- and r.percentComplete = 100 order by requestorName, r.trackingId DEV = #lsDateformat( _releaseProfile.startDate, "Ddd Mmm, D")# through #lsDateFormat( DateAdd( "d", -3, _releaseProfile.qaDate), "Ddd Mmm, D" )# QA = #lsDateformat( _releaseProfile.qaDate, "Ddd Mmm, D")# through #lsDateFormat( _releaseProfile.endDate, "Ddd Mmm, D" )# GA = Week of #lsDateformat( _releaseProfile.releaseDate, "Ddd Mmm, D")# #_releaseProfile.weeks# Weeks #_devSchedule# / #_qaSchedule# / #_gaSchedule#  #_weekCount#

Team,

Our goal is to provide software solutions that increase the efficiency and satisfaction of our customers. In an effort to do so, we require SCRUMs to be in the complete state.

There are currently #lsnumberformat( qmd_qaTotal.qaCount )# SCRUM requests still in QA.

Please review your QA SCRUMs within 24 hours to ensure that they meet the documented requirements. If a SCRUM does meet the requirements, mark it Complete so that the developer can move on to other SCRUMS. If a request does not meet your requirements, please set it back to Active, add a message, and notify the developer as soon as possible. Below is the complete status for this release.

NOTICE: This is QA week for this release. If your name appears in red, you are putting the release at risk. Please review your Scrums ASAP!
SCRUM requests still in QA
Requestor Scrum # Description
#htmleditformat( requestorName )# #htmleditformat( trackingID )# #htmleditformat( left( description, 120 ))#


All SCRUMs must be moved from QA to Complete by the end of the day #lsdateformat( _releaseProfile.endDate, "dddd mmm d, yyyy" )#. If they are not, the entire release may be delayed. If you have any questions, please let me know.

Cheers,
Michael

P.S. Please do not review QA scrums from prior releases. Also do not add new requirements to existing SCRUMs in the release. If a new requirement is desired, please create a SCRUM and work with scrum team to have get it prioritized and scheduled for development using the standard process.


#_emailBodyHTMLwithInlineCSS#