@kkangsan 👋 You cannot order on the many side of the relation as of now. You need to use a raw query if you need to order on the many type relation. There’s a request for this so you can add a 👍 and follow for more updates: https://github.com/prisma/prisma/issues/5837

@Ryan 👋 Thanks for the reply, In my situation, it's still under development, so changing the field to int seems like the best solution.

It’s not a problem of string or int, you cannot do an order by on

Quiz[]

. If it were

Quiz

then only it’s possible.

It is my mistake. There seems to be a problem while posting a question by changing from my model to a new example. lesson - quiz 1:1 😅

Then sorting should work on strings as well. It will sort based on the alphabets in the string.

Is there a way to orderby by casting a string to a number? https://stackoverflow.com/questions/8502505/order-varchar-string-as-numeric

select * 
from your_table
order by cast(your_text_column as double precision) desc;

Casting would need a raw query, otherwise you can change your field to a number if that’s what you want to order by.

@Ryan TY ! 👍