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

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

caglad

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

Accepted answers

All comments

Charlie Misonne

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"

Martin Bayer _MoroSystems_ s_r_o__

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")

caglad

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

caglad

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

caglad

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

caglad

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

Martin Bayer _MoroSystems_ s_r_o__

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.

caglad

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

Charlie Misonne

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!

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

query