can we compare 2 JQLs/dashboards/ specific update to a field !!

Question

hello,

Situation: There are set of JQLs that help me fetch issues that need an update for a specific field in JIRA.

We run these on a weekly basis to keep the JIRA data hygiene.

Situation: There are issues that are long pending and appear in JQLs Week on Week. Need a way to see the aging/count of such issues.

Currently we do this by exporting to excel and comparing the data :-( I was hoping there will be a way to compare JQL output in JIRA, dashboard comparison or alteast to query if a specific field data was update in last week.

If this is possible in anyway in confluence also, il be glad- thank you

Archana Nagaraj_zpfis3 · Answer

Thanks for getting back Nic.

Yes I assumed!! the excel was overhead. Started off this discussion as my solo search was taking me no where :-)

Here is the example:

I have a JQL that fetches me all the Features that are missing a Project manager and a Program manager or Product manager.

I run this on Monday every week (20/Jul- 50 issues). Expectations from the Teams is they update the required details within a week. And Next pull on 27/Jul with (55 issues) has the same 50 issues + 5 new issues. So this goes on for couple of weeks and there are Features that are pending without update for a few months now!

Hence, what I am looking for is a JQL/Function that can tell me, how many features were part of first/previous run and are repeating in 2nd run and so on.

something like Issuekey in (Extract 1) and Issue Key in Extract 2 (bringing up list of 50 issues in my example)

Or even this would be ok.. list of New issues in Extract 2 (5 issues that got added)

Let me know if you need additional information

Nic Brough -Adaptavist- · Answer

Jira searches support things like "show me issues that have not been updated for X days/weeks" and "field is empty/has value Y", and those searches can lead straight into a bulk-edit function, so it sounds like you are making a lot of pointless work for yourself with excel.

Could you tell us exactly what you are searching for?  We may be able to help you with your queries.