In Confluence, how do you get a count of open tasks for the current user in a specific space/spaces?

[Marc Moroz]

I've been working on custom macros but can't get the count of open tasks assigned to the current user.

I assume it might need to ignore tasks in task reports as well.

Ideally, it would be nice to specify one or more spaces.

Has anyone dealt with this?

[Irina Chiriac]

+1 for the need of counting open tasks of a given user. Seems pretty straight forward to add in the Task Report Macro

[mdimov]

It is very disappointing that there is no easy solution to this most simple of tasks.

[Andrey Khaneev [StiltSoft]]

Hello Marc,

You can combine Task Report macro with Table Filter and charts app in different ways:

• Wrap Task Report macro with Pivot Table macro and get number of tasks.
• Wrap Task Report macro with Table Filter macro and set the total row to show number of tasks (count).

[Marc Moroz]

Thanks for taking the time to put this together but this isn't going to work for us.  Getting add ons through info security, evaluation, sign-off, etc is tough.  And I'm unlikely to get an entire add on approved because I need one field.

I'm really in need of a custom script I can copy for a user defined macro.

[cruel]

That worked great for me

[Payal Gogia]

hey @Marc Moroz,

Did you get any solution to your problem. I am facing the same issue. Want to get a count of the tasks.

[Victor Mutambuki]

Marc,

Use Content by user macro.

Victor

[Marc Moroz]

Hi Victor,

The Content by user macro lists everything, not just open tasks.  It also needs to have a user name set in the macro and can't be used for "current user"

If there is a way to get this to do what I was asking, I'm missing it.

[Victor Mutambuki]

How about Task Report Macro

[Marc Moroz]

That creates a list of all of the tasks, not a count.  It also can't be set up to show tasks only for the current user.

The count is important because this is just one element on a dashboard, I can't fill up the page with a long list of tasks - some people have many.

[Victor Mutambuki]

One of the parameters is you can select current user, assignee.

[Marc Moroz]

I don't see that.  But even if that's the case, it's still a list of the open tasks rather than a count.  The count of open tasks for assigned user is the key thing here.