Attachment Macro sorting with a numerical prefix

Question

Hi,

I am using the standard file list template in confluence to display a list of supporting files. The naming standard I use for the files is

yyyyMM  ie   201902 Test Report.pdf

If I edit the macro and choose to sort by "name" and "Descending" the macro preview shows things beautifully sorted exactly how I would like . i.e.

However after saving the macro... confluence then presents the data in a complete meaningless sort order ie

The most goading this is the macro preview is RIGHT... Its only the resulting page that has the incorrect file display order.

In the saved macro it appears confluence is ignoring the number abd just sorting on part of the name property. But in the preview it correctly sorts on the full name property.  Am I doing something wrong? Shouldnt the preview match the saved output?

Michael Jones_url83s · Answer

It has exactly the same result. It sorts on the alpha characters and seems to ignore the numeric prefix.  It seems like an incredibly strange way to function as all database keys, collection sorts and the like in virtually every other software tool support numbers when sorting on alphanumeric field.

Gillian Rourke · Answer

How frustrating...

What happens when you press on the File column header?  Does it sort the table as you would expect?