Table Transformer - RAG status from JIRA filter not displaying correctly
Hi all, I have been looking for a way to constrain the column width of the output of a JIRA issue macro in confluence. This led me to the table transformer macro, which I used by wrapping it over the JIRA issue macro (as shown in the below screen grab) and used the included SQL to define column widths at set values. The issue I came across is that the RAG status no longer displays correctly in this new wrapped format (as highlighted in the below screen grabs). The problem appears and disappears depending on the number of issues being displayed.
I have also included the SQL that I am using at present to set the widths (the output of this is shown in the 'RAG status kind of working' image, where all statuses displaying but are incorrectly set to yellow). An additional issue I have of lower importance but potentially related is that the wrapping of the macro within table transformer removes the link from the 'key' column. If I can have that restored I'd love to know how.
Many thanks for any and all help in advance!
1 answer
1 accepted
Hi @Josh Sim ,
What concerns the first part of the case, please check the Table Filter and Charts for Confluence app version - the current one is 7.9.13. If you use the older one, please update the app and check if the unstable behavior still persists.
Besides, check the names of your columns (uppercase and lowercase letters, etc.) and use an autocomplete function of the Table Transformer macro.
If nothing works, please raise a support request here and will try to troubleshoot the issue.
What about the missing links to the "Key" field, we can suggest using the following SQL query:
SELECT
FORMATWIKI("{cell:width=10px}", 'Key', "{cell}") AS 'Key',
FORMATWIKI("{cell:width=300px}", 'Project', "{cell}") AS 'Project'
FROM T*
When we use commas instead of the pluses, we preserve the initial column formatting (clickable links for your case) and add additional custom column formatting (that is width).
Please check the documentation related to the preserving of the initial cell formatting here.
Hi Katerina, thanks so much for your assistance, my issue regarding links is resolved now, much appreciated. Re: the first issue I have triple checked my column naming is correct using autocomplete to no avail. I've been informed that the app version in use is 7.1.9 and I have requested an update.
In the meantime, one last twist in the issue: when I transpose the chart all the RAG statuses show up correctly? This is of course not the layout I am after but nonetheless demonstrates that it is somehow possible.
Hi @Katerina Kovriga _Stiltsoft_ ,
We are currently updated to version 7.4.0 of the Table Filter and Charts for Confluence app. As I have no idea when we'll get all the way up to date I'm going to pursue a support ticket to see if this issue can be replicated and resolved.
If I could just attach a couple adjacent queries to the above if you've got a moment:
1. It seems that formatting cell width to a certain number of pixels is often ignored? This has occurred in the case of trying to restrict large text fields to say, 300px so I imagine that there is some sort of hidden minimum. Is this the case that I should expect the fixed width to be exceeded when that cell contains a large amount of content?
2. Because in JIRA you can have multiple custom fields (and therefor columns) with the same name but different field codes, I would expect to be able to differentiate them in the macro. However, in such a case with the rag status, I have added both fields to the 'columns to display' section of the jira issue/filter nested inside the Table Transformer macro and I can still only see 1 'T1.RAG Status' column to select (cannot screenshot bc it is a dropdown). Is this just an incompatibility?
Again, any and all help is much appreciated!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.