when i select the table ,the fields ware order by displayname . i want to change the order by The database which the source table in . how should i do
Hi @huiliuliu
Metabase sorts by display name, but a workaround is to use Nested Queries - it’s not perfect, but it would allow you to create a question, where you setup the column/field order and save that question, and then allow other questions to use that as the source:
https://www.metabase.com/blog/Nested-Queries/
There’s an open issue for allow sorting - go and upvote by clicking 
on the first post: