Suppress assignee and date in action items table description

[Nigel Brown]

Is there a way to suppress the assignee and date in the description field  as I have this info in the due date and assignee columns? I know I can remove those columns to not duplicate the data, but then I lose the ability to sort.

Thanks

[Katie A]

If you have access to the macro "Table Transformer", you can!

1. make sure you put all "Descriptions" you want to capture in quotes

    like-      [] "Description" @User //date

    (where [] is the checkbox icon)

LIKE THIS:

2. put your task report macro INSIDE of a table transformer macro.

3. In the table transformer macro, under "Presets" put "custom" and in "SQL query" put something like this:

SELECT
T1.'Task appears on',
T1.'Assignee',
T1.'Due date',
T1.'Label(s)',
MATCH_REGEXP(T1.'Description',"(?<=\")[^\"]*","u")
AS 'Description'
FROM T1

This is the result:

[Alexis Robert]

Hi @Nigel Brown , 

the description column is actually a simple "copy" of the task description, it's not possible to only include some information here even if it's duplicated somewhere else.

You can have a look at the documentation here : https://confluence.atlassian.com/doc/add-assign-and-view-tasks-590260030.html

If you do need more flexibility for tracking tasks, I would suggest looking at Jira : this way you can configure exactly what's displayed in the Jira Issues macro in Confluence, and it gives you more configuration options.

Let me know if this helps, 

--Alexis

[Nigel Brown]

Thanks Alexis, thought as the other two columns were able to include only specific parts there may be a way, but it’s not a major issue, just not a fan of duplicating info but I’ll just have to get use to it 🙂

Thanks again

Nigel