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

Hi,
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
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,547 views 25 14
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