How to Query Data and Sort it in descending order using the number?

[JenuelDev]

So I have this list:

And I want to get data and sort it in descending order:
this is wat Im trying to come up but it seems not working.

const myWork = await queryContent("/my-work").sort({ $numeric: -1 }).find();

This does not work,, How to make this work? I need help,, thanks thanks :)

[kokamkarsahil]

Update:

$numeric is boolean and it has to use with field

const myWork = await queryContent("/my-work").sort({ _id: -1, $numeric: true }).find();

[nobkd]

That's great!

[JenuelDev]

thanks mate,, the _id for me works properly,,, without using numeric.. any idea why $numeric need to be added?

[nobkd]

As mentioned in #1859 (reply in thread) if you don't apply the $numeric: true, the ordering works by string sorting, so numbers longer than one digit (different than the file names in your image) aren't sorted correctly.

Imagine that you have the numbers 1, 2, 10, 50 as strings.
If you order by string sorting, your sorted string numbers will look like this: 1, 10, 2, 50

That's not what you expected, so you use the $numeric operator, to interpret the digits in a string as if they were numbers, and get the correct order.

[JenuelDev]

ah I see,, I get it now.. :)

[arkaroy135]

Thanks for the solution. Very helpful.