select * from tbl_WEBLOG_Link with (nolock) where WebLinkId = and WebLinkKey = select r.trackingId, r.description, r.statusCode, r.rank, r.duedate, r.statusCOmments, r.notes, r.timeEstimate, r.sizeEstimate, r.billingStatus, r.assignedTo, ma.firstName aFirstName, ma.lastName aLastName, ma.email aEmail, productAssignedTo.firstName productAssignedToFirstName, productAssignedTo.lastname productAssignedToLastName, productAssignedTo.email pEmail, r.requestor, mr.firstName rFirstName, mr.lastName rLastName, mr.email rEmail, r.releaseName from tbl_SCRUM_Requests r with (nolock) left outer join tbl_FSPro_Members ma with (nolock) on ma.fspro_userid = r.assignedTo left outer join tbl_FSPro_Members mr with (nolock) on mr.fspro_userid = r.requestor left outer join tbl_PCS_Products products with (nolock) on products.productCode = r.product left outer join tbl_FSPRO_Members productAssignedTo with (nolock) on products.productOwnerId = productAssignedTo.fspro_userid and products.scrumNotifications = 1 where requestId =

#htmleditformat( qmd_request.description )#

Status: Active Finished Pending Complete Cancelled Unqualified Hold #qmd_request.statusCode#

style="color:red;"> ATTENTION! - This request is considered an EMERGENCY by the requestor. It should be addressed before any other SCRUM request in your queue. If you are working on another request (other than another Emergency) you should stop working on that request and begin to address this request ASAP. If code changes are required to complete this request they should be deployed as soon as safely possible.

Priority#qmd_request.rank#
Billing Status#qmd_request.BILLINGSTATUS#
Due Date#qmd_request.DUEDATE#
Size#qmd_request.SIZEESTIMATE#
Time Est. (hrs)#qmd_request.TIMEESTIMATE#
View Release Notes

Message Response:

&##160;

MESSAGE HISTORY

#posterFirstName#   #posterLastName#   on   #markTimeFormat#

#htmleditformat(_line)#

Comments

#htmleditformat( _line )#

Notes

#qmd_request.NOTES#