Sort Records Manually

Legacy Poster

• 21 de septiembre de 2015 19:39

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

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • 21 de septiembre de 2015 20:48

  solved... used a custom sql query:

   

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

  0

Iniciar sesión para dejar un comentario.