[Question] Sorting in DataTable

[ingdesarr1]

Question

Hello, I'm usign a DataTable to append data to a form. In the DataTable, I activate the option sort_ascending and sort_column_index to sort the data that I'm adding. The problem is the data not sorting, it remains the same as how I append. I have the option on_sort in the column, but not realize nothing. Do have I to do manual sorting or can the table sorting itself? Thanks

Code sample

import flet as ft
import time

class UserDataTable(ft.UserControl):

    def __init__(self):
        super().__init__()

    def app_datatable_instance(self):
        add_control_reference("UserDataTable",self)

    def user_sort(self,e):
        print(e.ascending)
        # e.data["a"] = True
        e.ascending = True
        print(e.ascending)
        self.sort_ascending = True
        self.update()
        pass

    def build(self):
        self.app_datatable_instance()

        return ft.Row(
            controls=[
                ft.DataTable(
                    expand=True,
                    border_radius=15,
                    border=ft.border.all(2,"bluegrey"),
                    horizontal_lines=ft.border.BorderSide(1,"bluegrey"),
                    sort_ascending=True,
                    sort_column_index=0,
                    show_checkbox_column=True,
                    columns=[
                        ft.DataColumn(
                            ft.Text("Nombre",size=12),
                            on_sort= lambda e:self.user_sort(e),
                        ),
                        ft.DataColumn(
                            ft.Text("Creacion",size=12),
                        ),
                        ft.DataColumn(
                            ft.Text("Rol",size=12),
                        ),
                        ft.DataColumn(
                            ft.Text("Comentario",size=12),
                        ),
                        ft.DataColumn(
                            ft.Text("Opciones",size=12),
                        ),
                    ],
                    rows=[],
                ),
            ],
            expand=True,
        )

Error message

No response

------------------------------------------------------

• I have searched for answers to my question both in the issues and in previous discussions.

[getr11]

I guess you have to do it manually. I did it like below. Using pythons sort method.
I used a variable (_sort_ascending) to detect, switch the sort state because DataColumnSortEvent
ascending is not changing. Does anyone know how to give the state back. So that DataColumnSortEvent
ascending changes the value on next sort?

DataColumn(Text("Test"), on_sort=self.on_sort_column),

def on_sort_column(self, e: DataColumnSortEvent) -> None:
        """Sort columns."""
        log.info("on_sort_column %s", e.ascending)
        self._datatable.current.rows.sort(
            key=lambda x: x.cells[e.column_index].content.value,
            reverse=not self._sort_ascending,
        )
        # TODO this must work somehow different
        self._sort_ascending = not self._sort_ascending