Sorting Table Column

When sorting a column of tag values, Retool is sorting by the underlying value not the label name itself. This is an image of the table columns, where I am trying to sort by the Firm name alphabetically.

These are the settings applied to the column:


and

Any help would be appreciated!

1 Like

Hello @Marcus Welcome to the Retool Community,

I tested it in my app, and it works perfectly as shown in the screenshots and If you want to sort data perfectly in your app, you can use a transformer and a custom JavaScript query



2 Likes

Hi @WidleStudioLLP, thanks for your help! I was able to solve it by just using a SQL view which made it sort properly.