Show column for field in related model

[jonocodes]

I have Users and Organizations. I would like in the list view for Users to show the Org name, but that name requires a join across the tables.

I am able to get the column to show, but not able to get the values to display. I have tried using sqlalchemy orm add_columns() and reducing the select to not return a model, but instead return specific fields in list_query().

But I see here

sqladmin/sqladmin/models.py

Line 696 in fadf4d6

return result.scalars().unique().all()

That 'scalars()' is reducing it back to the Users object.

Is there a suggested way for showing joined values like this?

[aminalaee]

Yes you can do something like:
‘’’
column_list = [“org.name”]
‘’’

And it will do the join

[jonocodes]

Thanks for your reply. That does not work for me. Do you have any examples? Do I need to override list_query() still?
scalars() still reduces the result to a User object, which wipes out the additional column.

[jonocodes]

Oh sorry, I was capitalizing 'Org', which of course represents the model not the relationship. User error. Well your suggestion works. Thanks!

[jonocodes]

It does look like an n+1 though as it is performing a join for each user, instead of prefetching the relation. It probably the way I defined my models.

[JakNowy]

@aminalaee This works great for me, but is it possible to rename the field label back to "name" instead of "org.name"? Or introduce some column aliases in general?

[aminalaee]

I think the column_labels should work: https://aminalaee.dev/sqladmin/configurations/#general-options