SQL query on duplicated table

Hi everyone,
I discovered a strange behaviour I can’t explain and don’t know how to get around…

SeaTable Setup:

  • Self-Hosted
  • Enterprise Edition v. 5.0.8

When I duplicate a table using the Duplicate Table API call with records duplication, a basic SQL query on this new table systematically returns “There are no records”.
The problem is the same if I use the GUI operation to duplicate the base (see below), and seem to be also present in the cloud version.

duplicate

The Duplicate Table function is only present in the Base Operations (before 4.4) section of the api documentation: is it deprecated ? I don’t think so as it is still working…

Any idea about that ?

Bests,
Benjamin

Hey Ben,
thanks for sharing your findings. I can confirm this behaviour that you describe for version 5.0.x. If you copy a base and duplicate the entries, these copied entries are part of the json file (=the base) but are not returned by:

  • the SQL-query app
  • the API
  • universal app

The good news: this issue is already known and will be fixed with version 5.1. I just tested the situation in our testing system and there the problem is already gone.

Best regards
Christoph

1 Like

Hi Christoph,
Thanks for your answer. Do you already have an idea of the release date for version 5.1 ?
Because I encountered this problem while migrating a process (from version 4.x to v5.0) that was already in production and that should be used again in the first half of september :confused:

Bests,
Benjamin

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.