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; } } }

JQL request for day 2 of sprint in Structure formula column

Mikolaj Umiastowski

Is it possible in a formula column to build a jql that displays something based on the status of a Story on day 2 of sprint.
I have this, and it works :

IF JQL {status CHANGED TO 'Deployed' ON '2024/05/21' AND status = 'Deployed'}: "(/)" ELSE IF JQL {status WAS 'In Progress' ON '2024/05/21'}: "(*g)"

But I'd rather not have a fixed date but something like (pseudo-code) :


status WAS 'In Progress' ON 'day 2 of the sprint'

So that I don't have to change the formula for each new sprint.

Accepted answers

Stepan Kholodov

Hello @Mikolaj Umiastowski

If the issue only has one sprint assigned to it, you can use this formula:

if historical_value(this, "status", date_add(sprint.startdate, 2, "day")) = "In progress": "(*g)"

I hope this helps. If you need further assistance of have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

All comments

Stepan Kholodov

Hello @Mikolaj Umiastowski

If the issue only has one sprint assigned to it, you can use this formula:

if historical_value(this, "status", date_add(sprint.startdate, 2, "day")) = "In progress": "(*g)"

I hope this helps. If you need further assistance of have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

Mikolaj Umiastowski

Thanks, it helped a lot !
I finally did that :

with FORMAT_CAPTION(color,offset1) = (
with SPACE(pixels) = """!https://upload.wikimedia.org/wikipedia/commons/5/52/Spacer.gif|width=$pixels!""":
"""{panel:borderStyle=solid|borderColor=white|bgColor=$color}${SPACE(offset1)}{panel}"""
):
IF issuetype = "Story" OR issuetype = "Bug" OR issuetype = "Task" OR issuetype = "Sub-task" OR issuetype = "Epic":
IF DATE_ADD(sprintstartdate, 19, "day") = TRUNCATE_TIME(LatestDone):
"(/)"
ELSE IF historical_value(this, "status", date_add(sprintstartdate, 19, "day")) = "In Progress" AND DATE_ADD(sprintstartdate, 19, "day") < now():
"""{color:#0000FF}${REPEAT("■", 1)}{color}"""

Mikolaj Umiastowski

where sprintstartdate is defined in a formula so that I can update it

Mikolaj Umiastowski

you can see final result : nt

Welcome!

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

Quick Links

Find more posts tagged with

jira

structure

addon-com.almworks.jira.structure

jql

jira-data-center

data-center