nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

print historical unique list of all due dates with strikethrough on all but the current due date

Rajal Shah

I have JIRA on cloud version. In the JIRA structure, I would like to write a formula that publishes all the historical values of the due date field with all strikethrough against all of them except the current due date value.

I write this formula for it, but it failes in the "$ ->" row. Any suggestions?

WITH myArray = history.changes.filter($.field = "duedate") :

WITH previousDueDatesArrays = WITHOUT (myArray, LAST(myArray)) :

IF(IS_EMPTY(myArray), "",

JOIN(

WITH(

myArray,

$ ->

IF(

$ == LAST(myArray),

concat("~~",$, "~~") + ", "

)

Accepted answers

Yuliia_Borivets__SaaSJet_

Hi @Rajal Shah

I don't know how to do that with a formula, but if you are open to using apps, you can try the one from my team. It's called Issue History for Jira, and you can create a report with changes in the due date for each issue in your project.

Report example:

due dates sorted by issue key.png

Tuncay Senturk _Snapbytes_

Would this work?

WITH myArray = history.changes.filter($.field = "duedate") :
WITH previousDueDatesArray = WITHOUT(myArray, LAST(myArray)) :
WITH formattedArray = MAP(myArray, 
  IF(
    $.to = LAST(myArray).to,
    $.to,
    CONCAT("~~", $.to, "~~")
  )
) :
JOIN(formattedArray, ", ")

All comments

Yuliia_Borivets__SaaSJet_

Hi @Rajal Shah

Report example:

due dates sorted by issue key.png

Rajal Shah

I need this to work in the Jira structure. It should be a straight-forward formula so purchasing something would be difficult to go through procurement anyways..

Thank you for taking the time to respond

Tuncay Senturk _Snapbytes_

Would this work?

WITH myArray = history.changes.filter($.field = "duedate") :
WITH previousDueDatesArray = WITHOUT(myArray, LAST(myArray)) :
WITH formattedArray = MAP(myArray, 
  IF(
    $.to = LAST(myArray).to,
    $.to,
    CONCAT("~~", $.to, "~~")
  )
) :
JOIN(formattedArray, ", ")

Rajal Shah

great.. This worked (see values on the right edge of the screenshot! I had to map history to a array value of Due Date from the variable selection at the bottom.. Is there something I can do to make your history.changes... formula work instead?

Also, I could not understand how the ".to" fixed the code? Any explanation on that would be awesome. Thank you @Tuncay Senturk _Snapbytes_

Screenshot 2025-04-06 at 6.22.48 PM.png

Petru Simion [Simitech Ltd.]

Hi @Rajal Shah ,

If you will not be able to find your solution of the shelf and if you will get approval to use apps you can try Issue History Dashboard for Jira , an app released by our company.

You can easily restrict your search by Field Updated = Due Date and Date of Change from and to as you wish.

Regards,

Petru

Screenshot from 2025-04-06 20-34-08.png

Tuncay Senturk _Snapbytes_

Whe you pick a specific field like Due date, Structure gives you a simplified array of history changes only for that field. So you don't need to filter for duedate, you're already only getting duedate changes.That's why history works directly as myArray = history.UNIQUE()

For your question regarding the ".to",

you're working with objects like this: { "from": "2025-03-17", "to": "2025-03-24" }

if you had just done MAP(myArray, ...) without .to, you'd be trying to compare the entire object, not just the date string. So, you need $.to because that's the new value of the due date in the change history record.

Tuncay Senturk _Snapbytes_

Last but not least, I'm glad it worked

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

atlassian-marketplace

cloud

atlassian-marketplace-cloud