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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • 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

Create statistical reports for Action Items in Confluence

For action items raised in Confluence I want to see:

Quantity per project

Quantity due in the next 7 working days

Quantity over due

Quantity closed without resolution

Quantity closed on time or by due date

 

How can I build such a report in Confluence

1 answer

By action items do you mean Confluence Tasks? If yes:

Some of your points could certainly be built by querying the ao_9412a1_aotask table in the database. These 3 should be relatively easy:

Quantity per project

Quantity due in the next 7 working days

Quantity over due

You could use PocketQuery to create SQL Queries that can be executed via macros. You might also be interested in Task Reminder which can send out emails containing overdue tasks, tasks that are due in the next 7 days, etc. (but it doesn't have macros).

I'm afraid these two might not be possible, though:

Quantity closed without resolution

Quantity closed on time or by due date

I'm not 100% sure but the last time I looked at the tasks database table I think it only contained assignee, comment, due date, page and whether the task is complete or not. No resolution date, resolution type or anything like that. If you require something like that you'll have to use Jira.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence Cloud

Please tell us how you use Confluence space settings

👋 Hi there, a few of us at Atlassian would love to learn about how you use "space settings" functionality in Confluence. A facelift to the space settings is long overdue and we want to start with im...

567 views 15 9
Join discussion

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