I created some questions in SQL, and I used the FIeld Filter to filter some fields , example year, weeks, holliday, this filters having working well. So, when I use in a painel, the weeks filter not show the correct order, this information has resource in database, and in this table I had a field about the weeks and the number to be this order, but when I use in the filter didn't show this order.
How it appears: Domingo, Quarta, Quinta, Segunda, Sexta, Sabado, Terça
Translate - How it appears: Sunday, Wednesday, Thursday, Monday, Friday, Saturday, Tuesday
How I would like to show: Domingo, Segunda, Terça, Quarta, Quinta, Sexta, Sabado
Translate - How I would like to show: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
I have a field in database with this numbers.
Please, How can I order this filter?