JQL Query to filter issues in a project

[Manish Prakash]

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

[Alexey Matveev · Accepted solution]

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. 

[Manish Prakash]

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]

Yes, this worked for me.

Thanks.

[Alexey Matveev]

@Manish Prakash

If my answer helped you , kindly accept the answer. In this case other users will be able to find this answer, if they have similair question.