Extracting information from Jira

Sushmitha_zy1qz2

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

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