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 Query to filter issues in a project

Manish Prakash_vsh3u0

Hi,

I have to pull historical data date wise and for that I need a filter which can pull all list of issues on a particular date & this continues to be searched for all following dates.

I am using below filter but my data is not accurate as I am missing data in between

sprint in (4640, 4610, 4681, 4622, 4629) AND fixVersion was not EMPTY on "2018/04/09"

Please suggest a filter to be used and I have tried above filter with Status, Resolution, Reporter, Assignee & other possible operators that work with "was".

Thanks,

Manish

Accepted answers

Alexey Matveev

Let me clarify a bit on what you want. Let s say you have "TEST_FIELD" custom field. On Jan 28 you set the "value 1" value for the field. Then on Jan 30 you changed the value to "value 2". On Feb 1 you want to write a JQL query so, that in the issue result view you would see the value of the TEST_FIELD on Jan 28? You want to see the "value 1" value?

It is not possible to do it with JQL. When you execute a jql function, you always see the current values of custom fields.

All comments

Alexey Matveev

It is not possible to do it with JQL. When you execute a jql function, you always see the current values of custom fields.

Manish Prakash_vsh3u0

Ok, Thanks.

However, my query was different. let me rephrase it.

My need is I have to pull defects information in a project for back dates, say what's all issue were in Verify state on a particular date ?

Alexey Matveev

Concerning your requirement about to show all issues in the Verify state on a particular date, you can do it with the following query

status was Verify on <DATE>

You can use the WAS operator only with the Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only.

You can not use the WAS operator with other fields. That is the limitation of JQL.

Manish Prakash_vsh3u0

Yes, this worked for me.

Thanks.

Welcome!

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

Quick Links

Find more posts tagged with

jira