Sort by Name - Numeric not fully working

[serinf-lauza]

Describe the Bug

Hi! I'm not sure if what I'm asking is actually a bug or if it's suppose to work that way. When I'm sorting a book with the only sort operation "Name - Numeric (Desc)", it does not work when a letter is in front of it.
Example of the result I would get with "Name - Numeric (Desc)":
2
1
Page 1
Page 2

"Page 2" should be on top of "Page 1" since it's suppose to be Desc

Steps to Reproduce

1. Create a sorting rule with only "Name - Numeric (Desc)"
2. Go to a book and create some pages with a name then a number "Page 1" & "Page 2"
3. Sort the book when the new rule created

Expected Behaviour

The expected behaviour would be

Page 2
Page 1

Screenshots or Additional Context

No response

Browser Details

Chrome, Windows 11

Exact BookStack Version

v25.11.2

[ssddanbrown]

Hi @serinf-lauza,
This is expected, to quote our docs:

Name - Numeric: Will attempt to parse a numeric value (24, 24.125), up to one decimal point, from the start of the name and sort on that.

We don't go any deeper than that, since the logic beyond that can become more uncertain relative to expectation.