Table1 column replication on table2 inside table transformer

[Patidar, Rajkumar]

Hi,

I have one table transformer, which used two table, table1 generated through JIRA and table2 has add manually have two column Key and Comment. I want all the Key from table1 to be replicated on table2 key column automatically as an when table1 JIRA get updated (Removal/addition of JIRA), while edit mode. Which will help to get all key automatically based on table1 into table2. And no need of manual addition of key in table2 to be done.

Please let me know how this can solve.

[Stiltsoft support]

Hi @Patidar, Rajkumar ,

Seems that you are talking about our Table Filter, Charts & Spreadsheets for Confluence app.

If the final goal of your case is to join these two tables and add manual comments to the output of the Jira Issues macro, then you do everything correctly: the Jira Issues output contains keys and your manual table also contains keys that you type in. The correspondent rows are joined by the correspondent keys.

If you don't want to type in keys in the second table manually, you may take the Spreadsheet from Table macro instead of the Table Transformer macro.

Wrap your Jira Issues macro in the Spreadsheet from Table macro and your Jira output will be turned into a spreadsheet. Then you can add comments, statuses, formulas, etc. in spare columns (cells) like you do it in Excel.

[Patidar, Rajkumar]

Hi 

Thanks for response!

Yes, first scenario of merging table is working fine at my end but dont want to type keys in second table manually was the requirement. I was trying out using Table Transformer but could not able to achieve that requirement. 

At present, I am seeing that Spreadsheet from Table option is disable in configuration at confluence cloud. How I should be able to enable it.

Thanks

Rajkumar Patidar

[Stiltsoft support]

Hi @Patidar, Rajkumar ,

The macro can be enabled by your administrator in the Table Filter Configuration tab of the Administration section.

[Patidar, Rajkumar]

Thanks for information!

I will check on this with administrator.

Thanks

Rajkumar Patidar

[Patidar, Rajkumar]

Hi 

Mentioned in above comment...

If you don't want to type in keys in the second table manually, you may take the Spreadsheet from Table macro instead of the Table Transformer macro.

Wrap your Jira Issues macro in the Spreadsheet from Table macro and your Jira output will be turned into a spreadsheet. Then you can add comments, statuses, formulas, etc. in spare columns (cells) like you do it in Excel.

Could you please provide example how I can achieve it?

I have got spreadsheet from table macro enabled on confluence but it is just looking like xls.

Thanks

Rajkumar Patidar

[Patidar, Rajkumar]

Hi

Please, Ignore my above message. 

I could able to merge JIRA macro and spreadsheet from table.

But now here it converts all JIRA shown as link to text, which is block us to access any JIRA directly from this table and link got converted to text. Is there any solution to keep either JIRA key or summary to show up as link only to have easy access?

Thanks

Rajkumar Patidar

[Patidar, Rajkumar]

Can you please help here on queries?

[Stiltsoft support]

The Spreadsheet from Table macro indeed turns all the links into plain text as for now. We've already created the improvement ticket for our internal backlog - I've added your vote to it. Once the feature is implemented, we'll notify you here.

[Patidar, Rajkumar]

Hi

Thanks for information!

In continuation of my first query, I am able to use JIRA table with Spreadsheet from table macro. Along with JIRA table I have added "Comment" column, so that every Jira current status can be updated by individual user. 

I have filter in JIRA table to include only list of JIRA in Open / In Progress state but not Close state, hence when any JIRA moved to Close state, it will be removed from Spreadsheet but the respective comment does not removed and it get merge with below row.

How can I solve this, where complete row can be removed (along with comment) when JIRA moved to Close state?

Please let me know...

Thanks

Rajkumar Patidar

[Stiltsoft support]

Seems that it is an expected behavior.

You may try to show all the issues in the Jira Issues macro and filter out the required rows in the Spreadsheet from Table macro instead.

[Patidar, Rajkumar]

Thanks for info!

For now I have added CLOSED JIRA also in filter so that comment will not be merge to other rows.

Unfortunately, Spreadsheet from Table have only option to add Filter for one column. Can add for more than one so it is very difficult to manage with high number of JIRA and Users.

Please let me know if more filter option can be enabled.

Thanks

Rajkumar Patidar 

[Stiltsoft support]

Seems that we don't get the issue: the Spreadsheet from Table macro allows you to set filters to any number of columns as you do it in Excel.

For example, here is an outcome of our Jira Issues macro in the Spreadsheet from Table macro:

The two filters are already set (for the Type column and the Assignee column - active filters are shown in violet) and we also can add another filter as well (for example, for the Resolved column).

If it goes differently for you, let's move to our support portal. It's confidential, you'll be able to share your screenshots and other details freely for further investigation.