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?
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
Thanks for any help.
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.
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.
>>> 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.
And here is the result with filtration:
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...
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 :)
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...
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