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

This widget could not be displayed.

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
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

602 views 8 6
Join discussion

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