Hello,
My name is Ian Balas and I'm a system admin for a brokerage company in Long Island, NY.
Our marketing department uses Jira Software (Cloud edition) to keep track of tasks and projects.
My director wants a report of all work logs from each user in our instance from all issues (Jira's version of tickets) regardless of who's assigned to the issue.
JQL (Jira Query Language) filters usually help with most types of reporting we need, but not for this case. When trying filters like:
project = MAR AND worklogAuthor in membersOf("Aress (Marketing)")
to attempt to pull the work logs entered all time by users in this group, it'll give us the time spent on those issues, but unfortunately also accounts for the hours from work logs entered by other users on those issues. In simpler terms, that JQL filter will pull the issue in which the user logged work on, but the value in "Time Spent" will be a lot larger due to other users logging in work on that issue.
We either have to buy an add-on called Jira Timesheets in which users keep track of all their individual work logs (this would cost us well over $70/month cross-licenses for just one person who would use it...so we really want to avoid this route), or I would have to create something through Jira Cloud's REST API that pulls individual user's work logs across all users. I'm working on the latter, of course.
I figured work on this using Postman API Dev environment. The problem is that I can't seem to pull anything from our Jira instance... and I think it's because I haven't been able to successfully establish any Authorization from Postman <-> Jira.
Any help or guidance would be appreciated.
And if anyone has any better ideas on how to create a field/add-on that'll give us work logs from individual users, do tell me.