Bug: Sorting custom fields descendingly gives error

[omarmoo5]

Describe the bug
Whenever i try to sort a custom field descendingly it gives an error.

To Reproduce
For example here in the demo example , the comments field of users page.

If you tried to sort the comments counter field descendingly . it fails.

[Ilya-Green]

which one is comment field? can you provide screen?
if you mean relation field it bacuse it can't undarstand how to sort it, by which parametr.
One of possible solution is may be editing helpers.py: def build_order_clauses: adding this to func:
if attr_key == 'status': attr_key = 'status_id'
but i suppose it will work only for 'hasone' relations.

[Ilya-Green]

also i found this construction in demo source code, it can be solution:

class PostView(ModelView):
    fields = [
        "id",
        "publisher",
    ]
    sortable_field_mapping = {"publisher": User.full_name}

[Ilya-Green]

this is code of how this counter works:
class CommentCounterField(StringField):
async def parse_obj(self, request: Request, obj: Any) -> Any:
assert isinstance(obj, User)
return len(obj.comments)

it just counts the number of comments and returns a number, but it seems it is not set by which parameter such a field should be sorted

[omarmoo5]

this is code of how this counter works:

class CommentCounterField(StringField):

async def parse_obj(self, request: Request, obj: Any) -> Any:

    assert isinstance(obj, User)

    return len(obj.comments)

it just counts the number of comments and returns a number, but it seems it is not set by which parameter such a field should be sorted

Thanks for your reply, Surprisingly it can sorts them ascendingly.