Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Query for due date was 3/1-3/31 as of 2/28/01

I am having several problems trying to create this query - any suggestions helpful

due >= 2021-03-01 AND due <= 2021-03-31

assignee in (membersOf(development))

As of 2/28/01

One of the error messages was I could not use assignee in command and I also got a separate error when writing that due was command

3 answers

0 votes
Charlie Misonne Community Leader Mar 31, 2021

Can you share the full JQL query please? And perhaps a screenshot of what you are getting.

To me it's not very clear how you are inputting that query, why the 3 separate lines?

This one should work

due >= 2021-03-01 AND due <= 2021-03-31 and assignee in (membersOf("developers"))

I'm not sure what you mean with "As of 2/28/01"

I want to know what items were due between 3/1-3/31 on 2/28/21 - so, I dont want to see items that were updated to be due to 3/18 on 3/2

This shows me whats due on those date as of right now

assignee in (membersOf(development)) AND due >= 2021-03-01 AND due <= 2021-03-31 order by created DESC

but I want to know what the results were on 2/28/21

Charlie Misonne Community Leader Apr 01, 2021

From your screenshot I can see you are trying to use the DURING operator.

DURING only works after the WAS operarator.

And unfortunatrly WAS is not supported for the duedate field.

On this page you can read: "This operator can be used with the Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only"

Like @Martin Bayer _MoroSystems_ s_r_o__  is suggesting you can only perform your own analysis by exporting the data, a BI tool, etc.

Good luck!

So, can I do was resolution = done, in march, during 2/28? 

Charlie Misonne Community Leader Apr 01, 2021

Im' not sure what you mean with "during 2/28".

You can do: resolution was done DURING ("2021/03/01","2021/03/31")

DURING always takes 2 dates. This means the value of the resolution was "done" between "2021/03/01" and "2021/03/31"

If you want to find issues where the value of the resolution was done on "2001-02-28" you can do this: resolution was done ON "2001-02-28"

You can also search for: resolution = done and resolutiondate= "2001-02-28"

 

But I don't see how the resolution relates to your original question about the duedate.

Hi @caglad , it would be helful to see a screenshot or something. I think the correct JQL should be something like:

  • due >= 2021-03-01 and due <= 2021-03-31 and assignee in membersOf("development")

Yup, this is the JQL 

assignee in (membersOf(development)) AND due >= 2021-03-01 AND due <= 2021-03-31 order by created DESC

but I want to know what the results were on 2/28/21

hi @caglad you can't do it easily. JQL only shows current data. You would need to load history of the issues and analyze data.

yeah, I didnt want to do it that way though :)

For April, I am adding a label of all the issues due in April (today) and then I will be able to see what issues look like on 5/1 and compare to issues that I marked

I should ask, I am really just trying to report effectiveness of our forecasting of work that should be due in April

This is the error with what I think should be the what was due in March on 2/28lessthan.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

ThinkTilt is joining the Atlassian Family!

This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...

280 views 16 17
Read article

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you