Error when auto picking a sort column from external tables

[poirazis]

When fetching external tables, ( i.e Postgres ) and the first column happens to be of type json, the system fails to pick another suitable column with result the grid being unable to load.

This is a very specific case, it only happens when the column that is auto picked as sort column happens to be of type json

[linear]

BUDI-8929 Error when auto picking a primaryDisplay from external tables

[ConorWebb96]

Hey @poirazis,

Thanks for flagging this.

I'm adding details for our engineers when they get a chance to look into this further.

Simple table create script

CREATE TABLE platform_bugs (
    bug_data JSON,              -- JSON column
    bug_id SERIAL PRIMARY KEY   -- Primary key named after the JSON column
);

App export

postgres json column-export-1736425935463.tar.gz