Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Build monthly status report from updatedby()?


I'd like to be able to automatically build a status report of work done by a person over the last month. This status report could provide backup for an invoice if someone had a question about what the person was working on.

I've found with the new updatedby() JQL function that I can build this report easily with the following code: 

issuekey in updatedby(user, -30d)

What I'd love to be able to do is use a toggle or dropdown on a confluence page where I could choose the user and the time period.  Then I don't have to build a report for each individual user.

I'd also love to be able to choose the dates, e.g., from the beginning of last month to the end of last month. I tried using startOfMonth() in the formula above, but it doesn't work.

Any thoughts on how I might automate these 2 pieces (the user and the time period)?



2 answers

Hi @lececere

I can help with the date piece - you can search between two specific dates (rather than using startofmonth()) - see the Functions Reference page for more details.

In relation to drop-downs - I've seen apps like this one before for Jira Dashboards - where you can add quick filters to the Dashboard which acts like a drop-down. It would still require some setup as you'd need to create the multiple queries for the drop-down options - but it would save you some real estate on visualising it.

Dynamically changing the JQL filter based on content from a Confluence page - not sure how possible that would be unfortunately.


Hi Ste,

Thanks for your response.

I've been working with the add-on you suggest, Rich Filters, for the last several months and absolutely love it! It allows tons of flexibility in reporting and filtering on dashboards.

Unfortunately, since the name of the person is within a function, I've confirmed with the rich filter folks that there isn't a way to get a dropdown to change that value. I could, as you suggest, create a static button for each individual. That certainly would be more efficient than creating a new rich filter and report for each person.

If anyone has additional thoughts, I'd love to hear them.

Thanks again Ste!


Like Ste likes this

The updatedby() is not functioning well in jira cloud. The result I got including user that has never updated anything on the ticket.

Hi @Frank Chee 

Was this a one-off or a regular issue when using this function? And was this Classic or Next-Gen?


Regular issue in next-gen project

Hi @Frank Chee 

Can you share an example of the JQL you used, with the function above?


Hello, Laurie! @lececere 

You can automatically build a status report of completed work by an assignee over a certain period of time with Time in Status for Jira Cloud by SaaSJet.

With this add-on, you can not only automatically generate the report of the average time issues spent in statuses during a specific period of time, but also the report of the time that a particular assignee was assigned to each issue, the report of how long your issues has been staying in each status, how many times an issue has been in each status, and much more.

This add-on has an advanced filtering system by project, filter, report, label, sprint, and assignee (also by issue creation, update, and resolution date).

Moreover, you can view your data in charts (Pie, Bar and Area Charts).

And, of course, you can export the data both as numeric report and graphical.

You can always try it for free, hope this will help.


Thanks @Julia Denys [SaaSJet] for your response.

We aren't using time tracking right now.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you