OpenAtlas

I will look into this issue, at least from a managing point of view.

• AG Grid (GitHub)
• Tanstack (GitHub)
• Tabulator

I will look into these, but if anybody has other solution, which will integrate better, please let me know.

For filling the table dynamically, i.e. through the API, I'd suggest the following workflow:

For that, we would need an API endpoint that accepts an array of system classes and an array of column names as well as parameters for limit and pageNr. It should return the filled in rows as an Array of Arrays of strings, similar to what the entity_table() function currently does. A sample request could look like this:
Request : /get_table_rows?system_classes=['person']&columns=['name', 'description', 'begin', 'end']&limit=20&page=1
Response :

[
  {
    name: "Hugo",
    description: "Our first test entry",
    begin: 1900,
    end: 1990
  },
  {
    name: "Sieglinde",
    description: "Our second test entry",
    begin: null,
    end: 2003
  },
  ...
]

Great. The new endpoint is named /table_rows and gives you back an array of array with strings or Null.
You can select which columns you want with table_columns=.
Additionally, this endpoint shares a lot with the /query endpoint currently. So you can already choose between entities, system_classes, view_classes, linked_entities and use search, filter by type_id, etc.
OpenApi3 file should also be up-to-date with the version 0.4.11.

I will now test it, if every table_colums works as expected.

Available under: features/table_api

As a little bonus, now each Entity Endpoint features the format=table_row.

I don't know if everything stays the same, due to performance considerations, but currently this is the way to go.

PS: it currently only works if you are logged in and send the request from the browser you are logged in due to user settings. This can be easily overwritten, but we keep it for now the way it is.

  File "/home/bkoschicek/www/openatlas/openatlas/display/table.py", line 282, in format_name_and_aliases
    if not entity.aliases or not current_user.settings['table_show_aliases']:
                                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AttributeError: 'AnonymousUserMixin' object has no attribute 'settings'