Sort table column alphabetically

UI Builder
1

Hi,

How can i sort the entries in a column alphabeticaaly when i pull them in with load table objetcs?
The “sort by” doesn’t work. I read somewhere on the forum you could do it with sql syntax but i tried it with sort by and it doesn’t work.

Thanks

2

Could you please show what you attempted with the “sort by” connector?

3

Not much as of yet. i filled in the column name and thought it would sort the items alphabetically. I’ve looked up how the sql syntax works. There they use ORDER BY i thought the sort by might be the same.

4

This might help: https://www.youtube.com/watch?v=w1-8w32y5a4

Here’s an example with Codeless:

My data:

Data Browser - ConsoleDemo - Backendless 2022-01-20 11-02-47
Data Browser - ConsoleDemo - Backendless 2022-01-20 11-02-471725×992 245 KB

Data retrieval logic with sorting:

UI Builder - ConsoleDemo - Backendless 2022-01-20 11-04-58
UI Builder - ConsoleDemo - Backendless 2022-01-20 11-04-58895×603 75 KB

Result:
https://www.backendless.us/api/files/ui-builder/containers/support/index.html?page=sorting