Sorting Data in Postgres via If->Then->Else

Is there a way to sort via If->Then->Else? I was able to do it with Glide Tables, but not with Postgres source. Is there a workaround or do I have to do it in the SQL table?

Yeah, it looks like sorting by computed columns is not supported. So you’ll probably need to do something in the source table to get the values you need into non-computed columns (as Glide sees them).

You mean to say that because of computed column, sorting feature will not be supported in other than Glide tables, am I right ?

No, not exactly. I was just referring to SQL data sources, which is what the question was related to. If you have a read of the document I linked to, hopefully that will make it clearer.

1 Like

Thanks Darren. Will update in the SQL table but would be a great feature to have :eyes: :four_leaf_clover:. Bit more complicated to get set up in SQL.

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