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

Suppress assignee and date in action items table description

Nigel Brown September 1, 2021

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

 

2021-09-02 09_21_59-Clipboard.png

 

 

2 answers

2 votes
Katie A January 24, 2024

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:

Screenshot 2024-01-24 at 11.35.01 AM.png

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:

Screenshot 2024-01-24 at 11.35.57 AM.png

0 votes
Alexis Robert
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 3, 2021

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 September 3, 2021

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events