How to display one-many relationship data inside the users view

[xmansyx]

i have these two models with one to many relationship

class Users(Base, UUIDMixin, CreatedUpdatedMixin):
    __tablename__ = "users"

    first_name = Column(VARCHAR(length=128), nullable=False)
    last_name = Column(VARCHAR(length=128), nullable=False)
    email = Column(VARCHAR(length=256), nullable=False, index=True, unique=True)
    password_hash = Column(VARCHAR(length=1024), nullable=False)
    status = Column(VARCHAR(length=64), default=UsersStatuses.UNCONFIRMED.value, nullable=False)
    phone = Column(VARCHAR(length=15), nullable=True)
    old_id = Column(VARCHAR(length=128), nullable=True)
    projects = relationship("Project", back_populates="users", secondary="users_projects")
    markdown_projects = relationship("MarkdownProject", back_populates="users", secondary="users_markdown_projects")
    messages = relationship("UsersMessages", back_populates="user")
    role = Column(VARCHAR(length=32), default="user", nullable=False)



class UsersMessages(Base, UUIDMixin, CreatedUpdatedMixin):
    __tablename__ = "users_messages"

    user_id = Column(UUID(as_uuid=True), ForeignKey("users.id"), nullable=False)
    role = Column(String(length=128), nullable=False)
    content = Column(Text, nullable=False)

    # Define the relationship
    user = relationship("Users", back_populates="messages")

here is the userAdmin view:

class UserAdmin(ModelView, model=Users):
    name = "User"
    name_plural = "Users"
    icon = "fa-solid fa-user"

    column_list = [
        Users.id,
        Users.first_name,
        Users.last_name,
        Users.email,
        Users.status,
        Users.phone,
        Users.role
    ]

    can_create = True
    can_edit = True
    can_delete = True
    can_view_details = True
    column_searchable_list = [Users.first_name, Users.first_name, Users.email, Users.role]
    column_sortable_list = [Users.id, Users.first_name, Users.email]
    column_default_sort = [(Users.created_at, True), (Users.first_name, False)]

    column_details_list = [
        Users.first_name,
        Users.last_name,
        Users.email,
        Users.status,
        Users.phone,
        Users.role,
        Users.messages

    ]

how can i select only the content and role from usersmessages table instead of entire object inside details view page

[aminalaee]

I think we've discussed this before,
there's no clear way to know which fields of UsersMessages should be loaded in the relationship, for example you might have the following:

class UsersMessages(Base, UUIDMixin, CreatedUpdatedMixin):
    __tablename__ = "users_messages"

    def __str__(self):
        return str(self.another_column)

And if you loaded only role and content figuring out why SQLAlchemy threw an error for not being awaited can be confusing.

[xmansyx]

i was thinking of a way to may be select what could be select for example something like this
Users.messages.content maybe?

if it's not possible can i achieve this with custom views?
doing something like this:

class UserMessagesView(BaseView):
    name = "all messages Page"
    icon = "fa-chart-line"

    @expose("/users/{user_id}/messages", methods=["GET"])
    async def report_page(self, request, user_id: UUID):
        try:
            print(user_id)
            # async with engine.begin() as conn:
            #     await conn.run_sync(Base.metadata.create_all)
            session = async_session_factory()

            #get messages  from db using id

            return self.templates.TemplateResponse(
                "messages.html",
                context={"request": request, "users_count": users_messages},
            )
        except Exception as e:
            # Handle the exception here, you can log the error, return an error response, etc.
            error_message = f"An error occurred: {str(e)}"
            print(error_message)
            return self.templates.TemplateResponse(
                "error.html",
                context={"request": request, "error_message": error_message},
            )

does expose support passing dynamic parameters like id?

[aminalaee]

Ah sorry I didn't get that first.
You are right, now it's not possible but in the next version I'm hoping to include that feature so you can do "messages.content" to show the content.