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

How do I get a snapshot of issues on a particular day using JQL (rest)?

Tahir Rasheed

Hi,

So I would like to get a snaphot of all issues on a particular day.So for example I want a snapshot of issues on the 20th of December:

project = MYPROJECT AND parent = MYPROJECT-3 AND status WAS NOT EMPTY DURING ("2016/12/20","2016/12/20")

However this also shows me issues that were created after the date I am interested in. How can I achieve this?

Best regard,

Accepted answers

Nic Brough -Adaptavist-

Your status clause is irrelevant because the status cannot be empty. Your query is effectively "issues in myproject where the parent is myproject-3"

All comments

Nic Brough -Adaptavist-

Your status clause is irrelevant because the status cannot be empty. Your query is effectively "issues in myproject where the parent is myproject-3"

Tahir Rasheed

Ok got it, so instead I'm using

project = MYPROJECT AND parent = MYPROJECT-3 AND status WAS IN ("status1", "status2", "status3") DURING ("2016/12/20","2016/12/20")

I couldnt find a way to use wildcards with status, is it possible?

Nic Brough -Adaptavist-

Ah, good.

If by "wildcard", you mean you want to do something like "status name starts with/ends with/contains a string", then no, there's no way to do that, you need to lest each one individually.

Tahir Rasheed

well, rather than using WAS IN (x,y,z) I'm interested in all status values so wanted to use WAS * to avoid explicitly listing each value.

mlassau_atlassian

Finding issues that existed on a certain date in JQL is easy (eg "createdDate < 2016-3-1").
This will return the current values for an issue, but IIUC you want to get the "snapshot" of what it looked like at that time.

JIRA does not provide a snapshot view of issues - perhaps this would be a useful improvement.
But it can provide a log of all changes an issue has gone through.
To get to this in REST you use "expand=changelog" eg:

https://jira.atlassian.com/rest/api/latest/search?jql=issue=JRA-99&expand=changelog

But realise that this will produce a LOT of data (network traffic, memory usage etc may be an issue?), and you will then need to process it yourself to calculate the snapshots at particular points in time.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-core

jql