Is there some sort of operator that allows you query as if you were querying on a particular day? I.e. so that you could see what the values were as of that date?
project = X AND asof = '1/1/2020'
Hi @Tariq Ahmed -- Welcome to the Atlassian community!
In addition to what @Sachin noted, you can use things like CHANGED for some fields (such as status) for points in time. Please look here for more details:
Hi @William Sheboy ,
Thanks for the follow up! Unfortunately that won't do the trick. CHANGED only contains the most recent change.
CHANGED: 6/1/2020, State = In-Progress
CHANGED: 6/2/2020, State = Done
Querying for what things were as-of 6/1 wouldn't work:
changed <= '6/1/2020'
This would only get me list of things where their LAST change was 6/1.
You can use something like created > "2020/06/18" and created < "2020/06/19"
or to find all issues created in the last five days: created >= "-5d"
You can find more details about JQL here
created <= "2010/12/13"
created > "2010/12/12" and created < "2010/12/12 14:00"
and created <
Find issues created on 15 January 2011:
created > "2011/01/15" and created < "2011/01/16"
Thanks - ya I looked at the reference, didn't see what I was looking for.
For example if you wanted to get a list of User Stories and what state they were in on a given day, you've have to write a script which would dump the change history for each story, and try to derive what was the last change closest to that date and what the state was at that point in time.
Microsoft's Azure DevOps Server (formerly TFS) as a similar WIQL language, which has an asof operator so that you can do point in time queries.
Was hoping something similar existed in JQL.
Hey @Suresh Adimulam ,
Unfortunately no. The approach I'm taking is working on a script which grabs totals for the day, and saves that snapshot in my own database. If I ever get enough time will be happy to publish it for anyone who wants to use it. It's very rudimentary right now (writing it in GO, as the first thing I've ever written in GO).
If it's possible to grab the change history of the status field for a given work item via the API, you could reverse engineer what everything was on a given day.
Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event