Agile - Custom Columns

We originally set up a "Done" column to display the tasks/work completed, and then the final step would be an "Archive" as the final step of the workflow, which is not displayed - figuring that over time this would grow to a considerable size.

Now we are wondering whether we can display this "Archive" column but have the individual tasks/jobs fall away based on a time/number limit (ie. once in the Archive for more than 24 or 48 hours it would no longer be displayed in the column.

I have looked at the Min/Max constraints but these are not appropriate for our needs.

Is this something which can be configured?


1 answer

1 accepted

This widget could not be displayed.
Paul Greig Atlassian Team Jan 28, 2013

Hi Jason,

I would suggest this could be done with either of the following:

1. Updating the agile custom filter query, using an exclude arguement like project = <project name> ORDER BY Rank ASC AND resolutiondate >= "-2d"

2. If you wanted to mark the date of the archive transition, by creating a custom-field for the archivedate to be updated on the workflow transition and subsequently updating the filter with an expression similar to: project = <project name> ORDER BY Rank ASC AND archivedate >= "-2d"



Thanks for your assistance.

I tried both of those but got the following sort of errors:

Error in the JQL Query: Expecting ',' but got 'AND'. (line 1, character 53) - this error was for having 'AND' following Rank ASC.

When I added the ',' instead of 'AND' I got the following:

Error in the JQL Query: Expecting either 'ASC' or 'DESC' but got '-1d'. (line 1, character 69) - after resolutiondate it was expecting ASC or DESC rather than "-1d".

It then wanted another comma after ASC, rather than "-1d".



Paul Greig Atlassian Team Jan 29, 2013

Hi Jason,

Apologies, the example arguments should have looked like:

* project = <project name> AND resolutiondate >= "-2d" ORDER BY Rank ASC

* project = <project name> AND archivedate >= "-2d" ORDER BY Rank ASC



I tried "archivedate" and it says it is not valid.

The resolutiondate code is valid, but Im not sure that the effect is what I am after. When I set up the filters for the various tasks and then click on the filters, all tasks in the project disappear.

Im thinking its because Resolution is set to "Unresolved" regardless of whether a task is in progress, or has been completed. In looking through various tasks at various points in the Workflow, I cannot see a way to change this.

Update: I have found the issue with Resolution not changing, so hopefully with some newly created Tasks I can see how this works for the current project.

However, in checking a different Project which had been set up to change the Resolution on completion of task, the issue above, where all the tasks whether active or completed disappear on using the new Filter.

Paul Greig Atlassian Team Jan 29, 2013

Hi Jason,

Only resolutiondate is an existing field. To use archivedate (or similar) you would need to define your own custom field. There is a great article here about custom-field's in JIRA: Afterwards you would need to look into the addition of a new column in GreenHopper, the following guide would be useful:



And also add (resolutiondate is empty) or (resolutiondate >= -2d) to the clause

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 46m ago in Canada

Topic Tuesday - August 21

Hello and happy Topic Tuesday! We would love to continue to find out more about you. Here’s the question: What is one way Atlassian products have shifted the way your team works? Looking forw...

10 views 2 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you