Sort Records Manually 关注

0
Avatar
Legacy Poster

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

1 评论

0
Avatar
Legacy Poster
评论操作 固定链接

solved... used a custom sql query:

 

ORDER BY CASE WHEN "Language" ='en' THEN '1' etc... :D

请先登录再写评论。