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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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,462,535
Community Members
 
Community Events
176
Community Groups

Bob Swift Advanced Tables

Hi,

I'm trying to build a table that shows me the parent-child relationship as follows on confluence to help with reporting status (issues correctly built/Linked in JIRA):

Feature A

      Epic 1

      Epic 2

Feature B

      Epic 3

      Epic 4

 

Excel has a similar function that groups Rows together.  Is there any way to create this on Confluence using Bob Swift Advanced Table or something similar to that?  Are there any macros that would allow you to do this?

Appreciate any pointers

2 answers

1 accepted

0 votes
Answer accepted
Deleted user Feb 10, 2021

Hi @Robert Okemo ,

Thanks for posting your requirement!

We are from the Bobswift support team and we have created a support ticket: SUPPORT-5931 for your request.

Please signup here: https://bobswift.atlassian.net/servicedesk/customer/portal/1/user/signup and once you signup, please let us know your username so that we can add you to the reporter of the support request and discuss further on the issue.

Regards,
Raja

I've created my account on your portal using my corporate email. Not sure where to find username.  It simply has my name and my email address so not sure between which of those is the username

Deleted user Feb 11, 2021

Hi @Robert Okemo ,

Thank you for signing up into our portal.

Please let us know the user name which you are seeing on the portal after you logged in.

So that we can make you the reporter of Support-5931 later you can log in to our portal and can access the ticket.

Thanks,
Raja

Hi Raja,

This is what I see when  Iogin:BobSwift Login.jpg

There is no username I see even when I hover over the user icon.  When I select profile, I see my name and email address

How do I access the username?

Deleted user Feb 11, 2021

Hi @Robert Okemo,

Thanks for signing up.

Now, we could see your name "Robert Okemo" in our portal, and we have added you as the reporter to the ticket.

Please log in and access the issue to discuss further: Support-5931

Regards,
Raja

Excellent! Thank you!

Like Deleted user likes this
Deleted user Feb 22, 2021

Hi @Robert Okemo ,

Thank you for signing up with us and as discussed in support ticket, the https://bobswift.atlassian.net/servicedesk/customer/portal/1/SUPPORT-5931, 

We were able to achieve this use case using the JSON macro. Please refer to the below example, here you can get the issue key, type and linked issues in a table which are extracted from REST API. You can copy the below storage format and modify your project and issue keys accordingly.

Please refer to the below screenshot for the same:screenshot-4.png

Here is the storage format of the example that we have tested in our instance.
{code}
<ac:structured-macro ac:macro-id="00384471-9938-4c5e-909f-ce7b7db48ed3" ac:name="json-table" ac:schema-version="1">
<ac:parameter ac:name="sortDescending">true</ac:parameter>
<ac:parameter ac:name="autoNumber">true</ac:parameter>
<ac:parameter ac:name="capitalize">false</ac:parameter>
<ac:parameter ac:name="headingAugments">key,Linked issues, Issue Type Name</ac:parameter>
<ac:parameter ac:name="url">https://abcd.efgh.com/rest/api/2/search?jql=project%20%3D%20test%20and%20issuetype%20%3D%20epic</ac:parameter>
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
<ac:parameter ac:name="output">wiki</ac:parameter>
<ac:parameter ac:name="columnStyles"/>
<ac:parameter ac:name="fieldPaths">key,fields.issuelinks[*].inwardIssue.key,fields.issuetype.name</ac:parameter>
<ac:parameter ac:name="password">automation</ac:parameter>
<ac:parameter ac:name="sortColumn">1</ac:parameter>
<ac:parameter ac:name="paths">issues</ac:parameter>
<ac:parameter ac:name="user">automation</ac:parameter>
<ac:parameter ac:name="augments">,"%[%json-table:table=true%!%headingAugments=Linked Issue%]%%2%%[%json-table%]%"</ac:parameter>
</ac:structured-macro>
{code}

Thanks,
Raja

Hi @Robert Okemo ,

I guess that your problem will be solved with the help of the Bobswift support team, but in case other Community members will come across this question: we have a similar app - Table Filter and Charts for Confluence.

As we know, users often prefer its filtering capabilities provided by the Table Filter macro. But we also have the Pivot Table macro that works with dynamic Confluence macros perfectly well and allows you to group (aggregate) data (like pivot tables in Excel). 

Thanks Katerina.  I'm trying to use what I have as opposed to purchasing a whole new plug-in each time I need functionality to do something.  I will look into the Macro and see between Table Filter macro and the Bob Swift macros as I don't think I can justify the cost of both of them

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events