Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Combining Table Filter and Table Transformer -> Sorting issue

Tommy Strømme March 6, 2024

Hi,
I have the Table Filter on top, then the Table Transformer and Finally the Page Properties Report.

It works fine for the most, however after adding the Table Transformer the Table Filter is not doing its sorting anymore. I have chosen to Sort by Prioirty column, that used to work fine, but now its listed a bit random. Have to physically click on the Priority Header to get it right.

The Table Filter does work with the pre-set filters though, and only shows me what I have pre-selected, so its not entirely not working, just the sorting bit. 

Any help appreciated!

Regards

Tommy

1 answer

3 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 6, 2024

Hi @Tommy Strømme ,

As I saw on the screenshots from your previous question, the Priority column has a kind of a dropdown inside its cell or smth: what macro/app are you using to create it?

How does the sorting works with plain text or numbers?

Tommy Strømme March 6, 2024

Good morning,

The dropdown is this macro:

Save time with Easy Dropdown Menu in Confluence - Atlassian Community

However, I tried to change the sorting now to one of the other columns with no dropdowns, "Owner", which is plain text and that didn't work either. Usually, before the Table Transformer, I would use both Priority and then Owner. 

The filters work though.

Tommy

active projects.pngsortowner.png

Tommy Strømme March 6, 2024

Seems like I found a workaround. I added this at the end of of the Table Transformation code:

ORDER BY Priority ASC;

tommy

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2024

Hi,

Indeed the Table Transformer macro and its ORDER BY function allows you to sort your table. Besides, the macro uses its own internal sorting logic, so it works better, for example, regarding dates.

The Table Filter macro uses a standard Confluence logic for sorting, it just makes it a default one. By standard sorting I mean the standard sorting arrows that appear in the headers of your tables.

The sorting in the Table Filter regarding simple text strings shouldn't be broken though. You may check what version of the app you are currently using (the up-to-date one is 11.0.0), update the app and if the issue persists, create a support request.

Please attach the page storage of your page with the Page Properties Report and our macros and one of the pages with the Page Properties macro (upper right corner of the page -> menu ... -> View storage format). We'll recreate them and take a look. 

Tommy Strømme March 11, 2024

Hi,

I am not an admin in our Confluence instance (yet), but from the looks of it (by just clicking edit on the table filter) it says in the top right of it that its v10.1.2. Also tried to find "view storage format" on the page that holds the page properties report with the table filter macro and the table transformer, but I don't think I have "view storage format" 

Will try to get the admin to update to 11.0.0 and see if that helps :)

No rush though, the sorting workaround was great!

Thanx

Tommy

snip.png

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 11, 2024

Hi,

The View storage format option is also enabled by your Confluence administrator or he/she may do it for you (for them it should be always visible).

Glad that everything works through a workaround!

Brett Hall April 17, 2024

We see the same issue @Tommy Strømme. Adding the ORDER BY to the transformer fixes it, except that the user ability to sort Priority ASC or DESC by clicking the header row is still non-functional. I'll file a ticket with the very-helpful Stiltsoft support team.

Like Stiltsoft support likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events