select * from qmd_myRequests where statusCode <> 'U' and ( statusCode = 'H' or ( upper( releaseName ) = 'UNPLANNED' and statusCode <> 'Z' and statusCode <> 'X' and statusCode <> 'A' and statusCode <> 'B' ) or ( statusCode = 'A' and upper( assignedTo ) = 'UNKNOWN' ) ) order by releaseDate, masterSort, rank select * from qmd_myRequests where statusCode = 'B' and percentComplete = 100 and releaseState in ( 'CURRENT','FUTURE','PRIOR' ) order by releaseDate, masterSort, rank select * from qmd_myRequests where statusCode = 'U' order by releaseDate, masterSort, rank select * from qmd_myRequests where 1 = 1 and ( ( releaseState in ('CURRENT','FUTURE') ) or( statusCode = 'A' ) or( statusCode = 'P' and releaseState = 'PRIOR' ) ) and requestType <> 'CODE DEPLOYMENT' and statusCode <> 'X' and releaseState <> '?' and statusCode <> 'U' and not ( statusCode = 'A' and upper( assignedTo ) = 'UNKNOWN') and not ( statusCode in ('Z','H') and releaseState = 'UNPLANNED' ) and not ( statusCode = 'B' and percentComplete = 100 ) order by releaseDate, masterSort, rank

#htmleditformat( _title )#	#lsnumberformat( _requestQuery.recordCount )#
New Request

_statusDisplays.A = "Active"; _statusDisplays.U = "Unqualified"; _statusDisplays.B = "QA"; _statusDisplays.X = "Complete"; _statusDisplays.P = "Pending"; _statusDisplays.Q = "Queued"; _statusDisplays.Z = "Cancelled"; _statusDisplays.H = "Hold";

#listLast( _queryName, ":")#
Developer	SCRUM	Description	Priority	Due Date	Status	Size	Complexity	Time Estimate	Time Remain.	% Complete	Release	Live
#htmleditformat( assignedTo )#&##160;	#htmleditformat( trackingId )#	#htmleditformat( description )#	#lsnumberformat( rank )#	#dateformat( dueDate, "Mmm D" )#	#htmleditformat( _statusDisplay )# [X]	#sizeEstimate#	LowHighMedium	#lsnumberformat( _timeEstimate )#	#lsnumberformat( _timeRemaining )#	#_percentComplete#	#htmleditformat( releaseName )#	#deployed#