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?
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.
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.
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.
@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 1WHEN T1.'Emoticons'::string = "(tick)"THEN 2ELSE 0ENDAS 'Column For Sorting'FROM T*
After publishing the page, you may sort your table using the newly created 'Column for sorting'.
It looks like you're new here. Sign in or register to get started.
