How can I create a page in confluence which includes report of all unresolved comments

Question

In a specific space in confluence, I want to have a page where I can see reports of all the comments created by me that are still open (un-resolved).

In addition, to see all open tasks that I've created.

I've tried using a dedicated macro but it displays the resolved comments as well.

Anyone know what is the field in the Comment entity that holds the comment state so I can use it in my CQL query?

Any other idea?

thanks,

Guy

Irina_Bel_Stiltsoft_ · Answer

Hi @Guy Tadmor

The Talk - Advanced Inline Comments for Confluence app can help you with your case. Once you start using Talk as inline comments, you can collect them from different spaces and pages with the Talk Report. It automatically provides the following information:

A good practice is to use this app with the Table Filter and Charts  app. With the combination of these apps, you can filter comments by a certain user, the priority of a comment (low, medium, or high), and its status(open, archived, or resolved). These filters can help you to see which comments may take your immediate reaction.

Shannon S · Answer

Hello Guy,

There is not a specific query in Confluence search (using CQL) for that, but @Stephen Deutsch has given a very good answer on the subject below:

* How can I decide the page has inline comment or not

He may have further suggestions on your query if he happens to stop by this thread.

As for tutorials on building macros or add-ons, you can start with the following:

* Writing Confluence Plugins
* Writing User Macros

And if you get stuck, we do have our Developer Resources here:

* Get Help with Confluence Development Queries

Kind regards,

Shannon

Guy Tadmor_m00za4 · Answer

Hi,

Thanks for your quick reply.

Seems a bit strange to me that it is not possible to build CQL (query language) for this, can you please re-check again, maybe there is a field that I can use in the query to check the state of the comment?

I'm aware of this add-on but since we need to pay for the add-on, it will require some time to get the budget for it and deploy it in our organization.

Yes, I'm using the task report macro, this is seems to be a good solution.

Is there a tutorial how to build macros or add-ons if I want to build this ability using code?

thanks,

Guy.