Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,301,037
Community Members
 
Community Events
165
Community Groups

JIRA issue/filter macro, display 1 field per line for sub-tasks

I am trying to shoe ONE field per row/line in confluence when executing the JIRA Issue/Filter.

I have a Task that has many Sub-Tasks, but i have a requirement to display each field in the sub-task on separate lines. Is there a way I can edit the macro to make data display on separate lines? Or another possible solution?

1 answer

0 votes

Hi @ray scott 

Could you provide a screenshot or drawing of what you're trying to achieve?

I'm struggling to visualise the Sub-task fields on separate line requirement.

Ste

Imagine a Parent "Task" and 3 "Sub-tasks", I am looking to display the TASK using a standard macro JIRA issue/filter, with the data in one row showing multiple heading columns. However the "Sub-Tasks" are required to display on field at a time, per row see below:

 

Task = USA and Sub-tasks =include New York, Texas and Ohio

The report will look like this:

Country  Population  Average Age 

USA          360M         71

 

State

New York

Population

7M

Average Age

70

 

State

Texas

Population

9M

Average Age

74

 

State

Ohio

Population

2M

Average Age

79

 

 

Thanks for any help.

 

Ray

Hi @ray scott ,

Please clarify the issue a little bit more: maybe you could provide us with screenshots of manually created tables?

One of the output of the Jira Issues macro that you get - still struggling with the source table.

And the second one of the desired result: from your post I see that the first row looks like a summary and then we have some entries that are not in a tabular form at all.

Maybe our Table Filter and Charts for Confluence app will come in handy? We often have tricky cases with tables, for example, this Community thread.

Thanks for your reply. I cannot offer screen shots due to security.

 

If you are familiar with JIRA, the hierarchy is very basic, we have Tasks that have Sub-tasks as children. The Task is a Summary/ higher lever record and the Sub-tasks are a breakdown of the work needed to support the higher lever task.

 

eg

TASK 1

>>>>Sub-task 1

>>> Sub-task 2

>>> Sub-task 3

 

I nee to print the details of each sub-task in a column, not a row, so each field of the Sub-task prints on a separate row

Hi @ray scott ,

Didn't mean the exact screenshots - just images of manually created tables with dummy data before and after the required transformation.

If I got the case right, you want to transpose the table. Here are two options: the Table Transformer macro to transpose the whole table and the Table Transformer macro on top of the Table Filter macro to transpose only Sub-tasks.

Wed 11-1.png

Wed 11-2.png

Wed 11-3.png

And here is the result with filtration:

Wed 11-4.pngWed 11-5.png

Hi @ray scott 

To add, I don't think what you're looking for is going to be possible natively without a lot of filters.

 


You could technically...

  • Create a table in your desired format
  • Place a Jira Filter macro in every cell (for Sub-tasks)
  • Then for the Sub-tasks...
    • Search for the New York Sub-task in every Jira Filter macro in the first column
    • Set the field to display to...
      • only State in the first row
      • only Population in the second
      • only Average Age in the third
  • Repeat process for every other Sub-task cell

 


But, it would be a lot of manual work, and need manually updating each time new Tasks / Sub-tasks were added.

It'd be easier to look for an App which can help formulate the data in this manner - such as what is being suggested by Katrina :)

Ste

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

408 views 2 13
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you