Recent Code Changes

Recent Code Changes select deploymentFile, count(*) scrumCount from qmd_files group by deploymentFile "notChanged" : notChanged, "numberOfDaysAgo" : numberOfDaysAgo, "sensitive" : sensitive, "size" : size, "scrumCount" : 0, "conflict" : "N" }>

Below is the list of recent code/database changes (since #lsdateformat( _cutoffDay, 'MM/dd/yyyy' )#) on dev. If you see a file that you are concerned about, please review with the developer.

The changes are annotated as follows:

Red Text - This file/table has been changed but is not associated with a SCRUM in the #htmleditformat( url.releaseName )# release. (some exceptions apply*) If you changed it please update the deployment notes ASAP!
Yellow Background - Critical file/table, change with caution as the changes impact the operation of the platform or all clients
Blue Text - This file/table has been associated with more than one SCRUM
Blue on Orange - Release conflict - This file/table has been associated with more than one SCRUM, one of which is Complete and one of which is not.
Non Change - This file/table is listed in deployment notes, but as a comment and will not be deployed
Red on Cyan - Deployment notes contain a directory. All entries should be explicit files to avoid unintended deployments!

select * from qmd_files where notDeployed = 1

Non Deployed - This files was not deployed in the release because it wasn't associated with a SCRUM in the QA or Complete state, no changes where made (based on file compare), or it was indicated as not changed in the deployment notes.

style="color:red;"style="color:blue;" class="#_classes#">

Changed Tables
Table	Last Changed		SCRUM	Status	Developer
#htmleditformat( tableName )#	#lsdateformat( dateLastModified, 'MM/dd/yyyy')#yesterdaytoday	#_daysAgo# days ago	#htmleditformat( left( _v, 60 ))#	#htmleditformat( _v )#	#htmleditformat( _v )#	Untracked Change
#htmleditformat( left( _v, 60 ))#	#htmleditformat( _v )#	#htmleditformat( _v )#

select * from qmd_files where numberOfDaysAgo = 0 order by dateLastModified desc, deploymentFile displayRecentFiles( qmd_todayFiles, "Today's Files", true );
select * from qmd_files where numberOfDaysAgo = 1 order by deploymentFile displayRecentFiles( qmd_yesterdayFiles, "Yesterday's Files" );
select * from qmd_files where scrum = '' or scrum is null order by deploymentFile displayRecentFiles( qmd_untrackedFiles, "All Untracked Files" );
displayRecentFiles( qmd_files, "All Changed Files" );
displayRecentFiles( qmd_committedFiles, "Committed Files", false, true );

The following file patterns representing files that we do not track changes (i.e. backups, test code, etc...) are ignored when they are not on scrum.

#htmleditformat( _filesToIgnore[_f2idx] )#

style="color:red;"style="color:blue;" class="#_classes#">

#htmleditformat( arguments.title )#
File	Last Changed		SCRUM	Status	Developer
#_deploymentFileHTML#	#lsdateformat( dateLastModified, 'MM/dd/yyyy')#yesterday#lstimeformat( dateLastModified, "h:mm TT" )#today na	#_daysAgo# days ago na	#htmleditformat( left( _v, 60 ))#	#htmleditformat( _v )#	#htmleditformat( _v )#	Untracked Change
#htmleditformat( left( scrum, 60 ))#	#htmleditformat( scrumStatus )#	#htmleditformat( developer )#

#_emailBodyHTMLRaw# #_emailBodyHTML# select distinct a.email from tbl_SCRUM_Requests r with (nolock) inner join tbl_FSpro_members a with (nolock) on a.fspro_userId = r.assignedTo where 1 = 1 and r.ownerId = 78 and r.ownerType = 'MSC' and r.releaseName =

Sent to: #htmleditformat( _emailTo )#

select developer, count( distinct deploymentFile ) files from qmd_files where notChanged = 0 group by developer order by files desc