Insert the attachments macro name sort with numbers

[Gregory Ruth]

We attempted to use the 'Insert the attachments macro' for a list of policies that are numbered 1 - 60 something.   However, it appears this macro doesn't recognize numerical ordering. So for example, a file named: 1-first-policy.pdf appears after policies 1 through 19 because Confluence is looking at each letter/digit to determine order, conversely 10-tenth-policy.pdf appears first.

Is there any way to get it to sort by number beyond a single digit?

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Gregory Ruth,

If your company uses our Table Filter and Charts for Confluence app, you may use the following workaround with the Table Transformer macros:



Here is the query for the internal Table Transformer macro:

SELECT 'First Number'->split(".")->0 AS 'Number', *
FROM
(SELECT 'File'->split("-")->0 AS 'First Number', *
FROM T*)



We split the file names and leave only numbers.

With the help of the external Table Transformer macro, we sort these numbers:

SELECT 'File', 'Modified' FROM T*
ORDER BY 'Number' ASC



Hope it helps your case.