Sort Records Manually
Hi, i have a database where 5 records are displayed on my label using 5 columns. These records are selected by language codes from the database which are fr, de, nl, en and uk. The problem i have is that the records appear not in the sorting i want. Bartender sorts them alphabetically, but i would like to override that.
Best would be to display in the first column en, then nl, de, fr and uk. I think i have to solve this trick using the custom SQL command, but i have no idea how to solve this.
As i can't add new information into the database, i need some way around this by manually adjusting this sorting.
Any help would be greatly appreciated.
Thanks
-
solved... used a custom sql query:
ORDER BY CASE WHEN "Language" ='en' THEN '1' etc... :D
0
Please sign in to leave a comment.
Comments
1 comment