How to write nested query

Question

Hi,

I want to write a query to find out all JIRA where Sprint version has been updated in last 24 hrs. or any particular timeframe.

Now when I use last updated only, it will obviously give all JIRA which got updated for anything or any field but I want this query to result only ones with Sprint field updated.

Can someone suggest query?

Peyush Agarwal_1dgyi8 · Answer

I tried this and yes you are correct it doesnt help with Sprint field

Suprija Sirikonda _Appfire_ · Answer

Hi @Peyush Agarwal ,

Note that you can use "CHANGED" operator in JQL to find issues that have a value that had changed for the specified field. But this operator can be used with the Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only. This is documented here.

So, in your case, you cannot use "CHANGED" operator for "Sprint" field. You can search for any add-on in Marketplace which fulfils your requirement.

Hope this helps!

Thanks,

Suprija