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,299,297
Community Members
 
Community Events
165
Community Groups

Table Transformer macro: data presentation + formatting

Edited

Hello community,

Im trying to apply FORMATWIKI on the SQL as per reference documentation pointed by Confluence link at the bottom of the macro (https://docs.stiltsoft.com/display/TFAC/Advanced+table+cells+formatting), but function is not recognised and gives syntax error.

Screenshot 2022-03-02 at 12.31.45.pngScreenshot 2022-03-02 at 12.32.19.png

 


On the other hand, Im struggling with results presentation as I want to set the data in same table but different rows (the only way I got it working is all values next to each other), in addition to set a header row ("January" on the example below)

Screenshot 2022-03-02 at 12.33.29.png

 

Expectations

 

Screenshot 2022-03-02 at 12.33.29.png

 

Any hint?

 

 

Hosting type:

  • JIRA: Cloud
  • Confluence: Server/Data Center 

1 answer

1 accepted

Hi @Esteban Borja Lopez ,

Please check what version of the Table Filter and Charts for Confluence app you use - it seems that you need to update the plugin.

The current version is 8.1.1, the FORMATWIKI function was added in the 6.1.0 version and amplified since then.

What concerns merged cells in headers, the Table Transformer macro refers to tables as databases via the AlaSQL queries. So, every cell should be whole and unmerged.

Maybe the Pivot Table macro will do? You may wrap it on top of the Table Transformer macro and aggregate the data. 

Hello @Katerina Kovriga _Stiltsoft_ , thanks for the fast reply (and sorry for the delayed feedback!).

Indeed we have an outdated version of the plugin, Im just waiting for our IT to implement newest one. Once I got it available and tested, will come back.

On regards the 2nd point, I've tried that without success... nor been able to find examples on how to merge/present data in different rows within same table but next to each other instead (as shown above). If you have any example where to look at, I would appreciate.

In addition, im facing a new issue that im not sure if relates to the outdated table filter plugin: default SLA fields on issue search can be seen ("Time to firs response" and "Time to resolution"), but despite those are available to be added to the table at Jira Issue/Filter Insert macro (by setting them at "Columns to display" section), Filter Table macro does not show any value...

Issue search navigation (JIRA)

Screenshot 2022-03-07 at 09.15.27.png

 

Table Filter macro (with Jira issue/filter insert macro embedded)

Screenshot 2022-03-07 at 09.16.54.png

Screenshot 2022-03-07 at 09.17.16.png

 

Any hint?

Thanks in advance!

And does the Jira Issues macro show something inside these fields? Without the Table Filter macro, I mean.

Because you posted good screenshot from Jira itself, but not the correct output of the Jira Issues macro in Confluence.

The Table Filter macro can't delete any data in the table columns but leave the headers as they are. It shows the source table as it is.

I've figured out that despite the calculated value for response time is shown on the ticket and on the issue filter at Jira navigator, it's not being saved by checking on xml export: 

Screenshot 2022-03-07 at 15.14.06.png

Might it be related to the custom field configuration? Most likely with the type of field...

Maybe the type of the field can be the issue indeed - the Jira Issues macro shows the custom fields as usual.

I've created a custom field ("number" type) and set an automation rule to replicate the value of "Time to first response", and nothing is being copied upon execution.

I've faced in the past that some custom fields types are not eligible to be selected on "Column to display", which make me wonder if the issue is there somehow.

Maybe try to raise a new question regarding custom fields with a more wide topic mentioning Jira Issues macro and tags that include Jira as well. It may attract more attention from other Community members and/or Atlassian team, hope they will be able to suggest some tips.

Like Esteban Borja Lopez likes this

Thanks for the feedback @Katerina Kovriga _Stiltsoft_ . I've opened a new thread with whole details (checked with IT dept beforehand and they are clueless as well)... in case you want to have a look :) https://community.atlassian.com/t5/Confluence-questions/SLA-custom-fields-values-not-being-saved-possible-issue/qaq-p/1965252#M235831 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

270 views 2 5
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you