Sorting and searching on foreign models

[wnowicki]

We are struggling with sorting and searching on foreign models, I can't find any solution in docs so I decided to ask about it.

So this is the model:

class BatchItem(BatchItemBase, TimeStampModel, table=True):
    __tablename__ = "batch_items"

    id: int = Field(primary_key=True)
    batch_id: int = Field(foreign_key="batches.id")
    batch: "Batch" = Relationship(back_populates="batch_items")

    def __str__(self) -> str:
        return f"{self.id}"

and the admin config

class BatchItemAdmin(ModelView, model=BatchItem):

    column_list = [
        BatchItem.id,
        BatchItem.batch,
        BatchItem.is_active,
        BatchItem.created_at,
        BatchItem.updated_at,
    ]

    column_default_sort = [(BatchItem.id, True)]

    column_sortable_list = column_list

By default we are using column_sortable_list = column_list but this gives us an error

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'batches.id' in 'order clause'")
[SQL: SELECT count(*) AS count_1 
FROM (SELECT batch_items.created_at AS created_at, batch_items.updated_at AS updated_at, batch_items.is_active AS is_active, batch_items.batch_id AS batch_id, batch_items.id AS id 
FROM batch_items ORDER BY batches.id = batch_items.batch_id ASC) AS anon_1]

I've tried

column_sortable_list = [BatchItem.batch_id]

and

column_sortable_list = ["batch"]

none of them worked. Do you know any solution for that?