NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Old Version 3

changes.mady.by.user Frost, Ruth (NIH/NCI) [C]

Saved on

compared with

New Version 4

changes.mady.by.user Frost, Ruth (NIH/NCI) [C]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Resolved more TBDs.

...

Advanced Tables - Table Plus
sortColumn1
Table Transformer
dateFormatdd M yy
export-wordfalse
export-csvfalse
separator.
version2
export-printfalse
sqlSELECT 'Epic Link' as 'Feature', 'Summary' as 'Description', 'Key' as 'Jira Tracker Number' FROM T*
transposeResultfalse
show-sourcefalse
plainTextfalse
id1695924784843_-597278440
transposefalse
worklog365|5|8|y w d h m|y w d h m
export-pdffalse

Jira
serverNCI Tracker
columnIdscustomfield_12350,summary,issuekey
columnsEpic Link,summary,key
maximumIssues1000
jqlQueryfilter=34797
serverId7954a81f-12da-3366-a0ef-97c806660e7c

Hidden Data

In the above Jira macro, replace TBD with the filter number for the Improvements list in the current sprint.

Copy sprint numbers from Rui's "MWS Sprint" filter into the new Jira filter criteria and below:

  • Sprint in (TBD5703, 5689, 5693, 5691, 5692, 5690, 5702, 5704, 5886) 
  • AND (labels not in (NRN) OR labels is EMPTY)
  • AND resolution = Fixed
  • AND issuetype != Bug
  • ORDER BY summary ASC

When the team deploys this Sprint to Stage:

  1. Add an Epic Link to each ticket above that doesn't already have one. 
  2. In each ticket Summary, delete the prefix if it duplicates the Epic Link.
  3. In each ticket Summary, add ending punctuation and otherwise copyedit, if necessary.

When the team deploys this Sprint to Production:

  1. Open this page in view mode and copy the output of the Jira macro.
  2. Open this page in edit mode and paste the table. 

...

Advanced Tables - Table Plus
sortColumn1
Table Transformer
dateFormatdd M yy
export-wordfalse
export-csvfalse
separator.
version2
export-printfalse
sqlSELECT 'Epic Link' as 'Feature', 'Summary' as 'Description', 'Key' as 'Jira Tracker Number' FROM T*
transposeResultfalse
show-sourcefalse
plainTextfalse
id1695924940765_171141476
transposefalse
worklog365|5|8|y w d h m|y w d h m
export-pdffalse

Jira
serverNCI Tracker
columnIdscustomfield_12350,summary,issuekey
columnsEpic Link,summary,key
maximumIssues1000
jqlQueryfilter=34798
serverId7954a81f-12da-3366-a0ef-97c806660e7c

In the above Jira macro, replace TBD with the filter number for the Bug Fixes list in the current sprint.
Hidden Data

Copy sprint numbers from Rui's "MWS Sprint" filter into the new Jira filter criteria and below:

  • Sprint in (TBD5703, 5689, 5693, 5691, 5692, 5690, 5702, 5704, 5886) 
  • AND (labels not in (NRN) OR labels is EMPTY)
  • AND resolution = Fixed
  • AND issuetype = Bug
  • ORDER BY summary ASC

When the team deploys this Sprint to Stage:

  1. Add an Epic Link to each ticket above that doesn't already have one. 
  2. In each ticket Summary, delete the prefix if it duplicates the Epic Link.
  3. In each ticket Summary, add ending punctuation and otherwise copyedit, if necessary.

When the team deploys this Sprint to Production:

  1. Open this page in view mode and copy the output of the Jira macro.
  2. Open this page in edit mode and paste the table. 

...

Advanced Tables - Table Plus
sortColumn1
Table Transformer
dateFormatdd M yy
export-wordfalse
export-csvfalse
join-columnEpic Link
separator.
version2
export-printfalse
sqlSELECT 'Epic Link' as 'Feature', 'Summary' as 'Description', 'Attachment Description' as 'Workaround', 'Key' as 'Jira Tracker Number' FROM T*
transposeResultfalse
show-sourcefalse
plainTextfalse
id1692026983273_-1612685466
transposefalse
worklog365|5|8|y w d h m|y w d h m
export-pdffalse

Jira
serverNCI Tracker
columnIdscustomfield_12350,summary,customfield_10758,issuekey
columnsEpic Link,summary,Attachment Description,key
maximumIssues1000
jqlQueryfilter=34799
serverId7954a81f-12da-3366-a0ef-97c806660e7c


In the above Jira macro, replace TBD with the filter number for the Not Fixed list in the current sprint.
Hidden Data

Copy sprint numbers from Rui's "MWS Sprint" filter into the new Jira filter criteria and below:

  • Sprint in (TBD5703, 5689, 5693, 5691, 5692, 5690, 5702, 5704, 5886) 
  • AND (labels not in (NRN) OR labels is EMPTY)
  • AND resolution = "Won't Fix" 
  • ORDER BY summary ASC

When the team deploys this Sprint to Stage:

  1. Add an Epic Link to each ticket above that doesn't already have one. 
  2. In each ticket Summary, delete the prefix if it duplicates the Epic Link.
  3. In each ticket Summary, add ending punctuation and otherwise copyedit, if necessary.
  4. For each bug, copy the workaround from the Workaround field into the Attachment Description field, so this macro will display it in the Workaround column.
  5. For each non-bug, add "No workaround" to the Attachment Description field.

When the team deploys this Sprint to Production:

  1. Open this page in view mode and copy the output of the Jira macro.
  2. Open this page in edit mode and paste the table. 

...

Advanced Tables - Table Plus
sortColumn1
Table Transformer
dateFormatdd M yy
export-wordfalse
export-csvfalse
join-columnEpic Link
separator.
version2
export-printfalse
sqlSELECT 'Epic Link' as 'Feature', 'Summary' as 'Description', 'Key' as 'Jira Tracker Number' FROM T*
transposeResultfalse
show-sourcefalse
plainTextfalse
id1695925018561_298248446
transposefalse
worklog365|5|8|y w d h m|y w d h m
export-pdffalse

Jira
serverNCI Tracker
columnIdscustomfield_12350,summary,customfield_10524,issuekey
columnsEpic Link,summary,Workaround,key
maximumIssues1000
jqlQueryfilter=34800
serverId7954a81f-12da-3366-a0ef-97c806660e7c


Hidden Data

In the above Jira macro, replace TBD with the filter number for the Known Issues list in the current sprint.

Update the label in the filter and below:

  • project = DSRMWS
  • AND resolution = Unresolved
  • AND labels = KnownIssueSprintTBD KnownIssueSprint52 
  • ORDER BY summary ASC

When the team deploys this Sprint to Stage:

  1. Add the KnownIssueSprintTBD KnownIssueSprint52  label to tickets in DSRMWS-TBD 3186 that don't have strikethrough in the ticket description. (Those tickets haven't been resolved yet.)
  2. If one of those tickets is resolved before the release, remove the label from that ticket, so this macro won't display it.
  3. Add an Epic Link to each ticket above that doesn't already have one. 
  4. In each ticket Summary, delete the prefix if it duplicates the Epic Link.
  5. In each ticket Summary, add ending punctuation and otherwise copyedit, if necessary.

When the team deploys this Sprint to Production:

  1. Open this page in view mode and copy the output of the Jira macro.
  2. Open this page in edit mode and paste the table. 

...