How to add multiple rows automatically in a table based on one column (drop down list) values?

My requirement table created in a confluence page as below column headers and sample rows as below:

Requirement ID                           Components             
rqPOC_IDS_SubsFeat_Enhn_6     Web-Apps,XDM-DataMgr   
rqPOC_IDS_SubsFeat_Enhn_3     XDM-DataMgr, DB
rqPOC_IDS_SubsFeat_Enhn_4     Web-Apps,XDM-DataMgr,Callp

"Components" column field is of drop down list - multiple choice selection type.

Using "Scaffolding Reporting", what specifically we are looking for is:::

Automatically create rows for each of our "Components" values added in the above table as below along with new column i,e Compliancy(i,e drop down list - single choice selection type) added for all the rows.
So that compliancy can be updated in a page by respective component primes individually into the reporting table generated as below.

Requirement ID                           Components              Compliancy
rqPOC_IDS_SubsFeat_Enhn_6      Web-Apps                  NO  rqPOC_IDS_SubsFeat_Enhn_6     XDM-DataMgr           YES
rqPOC_IDS_SubsFeat_Enhn_3      XDM-DataMgr           NO  
rqPOC_IDS_SubsFeat_Enhn_3      DB                              YES
rqPOC_IDS_SubsFeat_Enhn_4      Web-Apps                  NO  
rqPOC_IDS_SubsFeat_Enhn_4      XDM-DataMgr           YES
rqPOC_IDS_SubsFeat_Enhn_4      Callp                           YES

Also Using this reporting table generated, we should also able to export into XLS to filter our requirementIds for our tracking purpose.

- Manju

1 answer

Hello Manju,

You can use Table Filter macro to filter your table or to export it to csv.

Thank you very much Andrey Khaneev for sharing this info.

I am going thru this Add-on, really intresting.

Was looking for simple reporting mechanism which fits to my requirement to filter out multiple requirement tables updated in our confluence pages to report, review, update the needed details and export into XLS for tracking purpose. Thanks Again.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

434 views 2 13
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you