Extracting information from Jira

[Sushmitha]

Hi team,

I have some questions from one of our customers.

1) User is looking to extract information from JIRAs as to who made the last comment (reporter/assignee/other) and when did the last comment happened
2) How the updatedBy() function can be used?
3) Wanted to compare updated and created labels but are not able to do so. Is this possible? is there any excel /python plugin available to do such comparison

[Aron Gombas]

You could try the Better Excel Exporter app because:

• it can export the assignee (no extra work required)
• it can export the reporter (no extra work required)
• it can export the last comment's date and author (as two built-in calculated fields)
• it can export the created date
• it can export the updated date

You can then compare these with the Excel native features, formulas, etc.

(Disclaimer: it is a paid and supported app, developed by our team.)

[Ste Wright]

Hi @Sushmitha 

Some responses below!

I'm assuming your extract is an export, given JQL functions are mentioned here - such as to CSV?

Also, I find these help pages on Advanced Searching are really useful :)

---

(1) Last Commenter

This isn't a native field, you'd need to have this data in a field to extract it in an export.

The easier ways I've seen to create this field are...

• A scripting App, to created a scripted field - such as using Scriptrunner
• An automation App, to populate a standard field - such as Automation for Jira

You could also create a field like last comment to extract that also if preferred.

Note...

• I've assumed you want this as a user picker or similar. You can technically export all the comments with the users listed, and then try to calculate this in Excel, etc.
• To do that, when exporting choose the option CSV (all fields) - this exports all comments, alongside all field data from across the platform with no limits.

---

(2) updatedBy()

See how this functions works on this help page

In summary...

• Search for Issues updated by a specific user
• Include a time range if needed (date from, date to)

---

(3) Updated vs Created Labels

Just to confirm - do you mean compare Created and Updated date fields?

If so - you can do single searches with some dynamic information - such as...

• created > startOfWeek()
• created < startOfYear()

If you want to compare two dates though, you'll need an App which extends the power of JQL - such as Scriptrunner - then you can do queries like...

issueFunction in dateCompare(" ","updated > resolved")

^ Which looks for Issues where the updated date is after the resolution date

---

 Does this answer your queries sufficiently? Let us know if we can be of any further help :)

Ste

[Sushmitha]

Hi @Ste Wright ,

Thanks for your answer.

I have created two custom fields 'last commenter' and 'last commented on' to store who made the last comment and when did the last comment happened. And used automation to populate those fields. I can see those fields and data on ticket. But while extorting Jira those fields are not on excel sheet.

Am I missing something ? 

[Ste Wright]

Hi @Sushmitha 

How are you exporting this data to Excel?

It should work if the fields are populated, and you are...

1. Searching for these Issues using JQL
2. Setting the fields as visible in the Columns
3. Exporting the data using Export > Export Excel CSV, or the Excel button

Ste