Columns containing only icons cannot be sorted

[René]

Hi, I like the (x) (/) icons a lot, and they help a lot to visualize states. But if a column only contains icons, the table cannot be sorted by clicking on the sort icon of this column.

Can this functionality be added?

[René · Accepted solution]

There is a rejected issue for this: [CONFCLOUD-52798] Page Properties report not sorting on emoji column - Create and track feature requests for Atlassian products.

As soon the issue is open again, please go and vote for it. The icons are there for a certain reason, and used int tables there are extremely helpful. So, please Atlassian, reconsider to provide a fix.

[Katerina Rudkovskaya _Stiltsoft_]

Hi @René Herrmann,

We can suggest trying our Table Filter and Charts for Confluence app.
Its Table Filter macro recognizes emoticons, so you’ll be able to filter your table by them.

[René]

Thank you Katerina, for your answer and help. This looks like a nice app, but we currently try to find out how or if it is possible to sort the column without an additional investment.

[Stiltsoft support]

@René Herrmann Seems that it is not possible out of the box.

Meanwhile, here is an example of a workaround for sorting using our app and its Table Transformer macro:

Now we create an additional column for sorting where each number corresponds to a specific emoticon:

SELECT *,
CASE WHEN T1.'Emoticons'::string = "(error)"
THEN 1
WHEN T1.'Emoticons'::string = "(tick)"
THEN 2
ELSE 0
END
AS 'Column For Sorting'
FROM T*

After publishing the page, you may sort your table using the newly created 'Column for sorting'.