Nc_order problems after loading DB on another account

Hi,

I’ve connected PostgreSQL DB I’ve created for a client to his account without using Share option - normally as a external source. It recognized table links - even many to many but ordering is not working. nc_order column is present, but ordering capability is not working.

Also nc_order on some tables does not correlate with order in on the original NocoDB account - I can’t use this feature on external systems.

It aslo rises a question - will I be able to move this DB to another server, replace hostname and retain all NocoDB logic?

Other than that - great system.
Peter

Looks like ordering metadata is not saved to nc_order column, which is not ideal - I have to create my own ordering column to use in ext systems.

I have duplicated table outside NC, removed nc_order column, synced metadata on both instances and neither have working ordering on this table. nc_order was also not recreated.

Thanks for reporting this! I’ve created a GitHub issue for tracking the problem. You can follow it here for updates:

AFAIK, row re-ordering is only supported for the base created directly on NocoDB. Feature not available for external data sources. For external data source table- one should not see drag-drop icon for row as well.

cc @DarkPhoenix2704 please correct me

Based on updates from @DarkPhoenix2704

Row reordering is supported for external DB tables if the table was created from NocoDB. In this case, table was duplicated outside NocoDB & a meta sync was done. Row reordering is not supported for such instances currently.