List of all tasks in space

Hello,

we are using the news tasks feature from Confluence 4.3 quite intensively.

On the other hand sometimes the project manager wants to have on overview of alle tasks within a space/global.

Is there a way to list all task, e.g. by creating a user macro?

I only found this Object: but I don t know if and how it can be used.

http://docs.atlassian.com/atlassian-confluence/latest/com/atlassian/confluence/content/render/xhtml/storage/InlineTasksUtils.html

thanks

Philipp

3 answers

1 accepted

Finally I found an elegant way to show the personal tasks of the logged-in user:

The content of the task-menu is a iframe: so this can also be used within a page with the help of iframe macro (you have to install it before).

I created a User-macro: my-tasks with this content.

## @noparams

<ac:macro ac:name="iframe">
<ac:parameter ac:name="src">/plugins/servlet/notifications-miniview/notification</ac:parameter>
<ac:parameter ac:name="width">600</ac:parameter>
<ac:parameter ac:name="height">400</ac:parameter>
<ac:parameter ac:name="id">inlineTasks</ac:parameter>
</ac:macro>

Hello Philippe,

The tasks are stored in ao_***_aotask in your database. You can do a simple (replace the *** with the correct value from your db):

  • select * from ao_***_aotask

This should list all tasks within your instance. In the GLOBAL_ID column you will find from which space/page the task belong to, as well as the owner of the task (USER column).

Hope it helps

Hi Alyson,

so I would need the SQL plugin to integrate this into a macro, right?

In this case the restrictions would be ignored, right?

I have to think about it!

Thank you very much.

Philipp

Philipp,

You can use the SQL plugin to display the results on a Confluence page, otherwise you will only get the results on your database management tool.

Sorry, I'm not sure what you mean by "restrictions would be ignored". Do you mean page restrictions?

Yes, I meant "page restrictions"

So users could be confused if they put a task on a restriced page which is then shown in the public list.

But maybe I misunderstood it and tasks do not depend on page-restrictions at all?

Philipp

Finally I found an elegant way to show the personal tasks of the logged-in user:

The content of the task-menu is a iframe: so this can also be used within a page with the help of iframe macro (you have to install it before).

I created a User-macro: my-tasks with this content.

## @noparams

&lt;ac:macro ac:name="iframe"&gt;
&lt;ac:parameter ac:name="src"&gt;/plugins/servlet/notifications-miniview/notification&lt;/ac:parameter&gt;
&lt;ac:parameter ac:name="width"&gt;600&lt;/ac:parameter&gt;
&lt;ac:parameter ac:name="height"&gt;400&lt;/ac:parameter&gt;
&lt;ac:parameter ac:name="id"&gt;inlineTasks&lt;/ac:parameter&gt;
&lt;/ac:macro&gt;

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

521 views 19 11
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you