nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Combining Table Filter and Table Transformer -> Sorting issue

Tommy Strømme

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

Accepted answers

All comments

Stiltsoft support

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

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.png

Tommy Strømme

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

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

filter

data-center

table

table-filter

table-filter-and-charts

confluence-data-center

table-transformer

table-filter-charts-spreadsheets