How to get the order of table columns

Anvil Q&A
1

Hi,

I can use list_columns() to get the list of columns (name and type) from my app tables, but how can I get the order of the columns as stored?

I understood the column order is available in anvil.yaml file that could be extracted using pyyaml. But can I find and open the anvil.yaml file in the server module?

Thank you,

Huarong

2

I am not aware of any way to get the order (unless list_columns is guaranteed to reflect order - not sure about that).

Could you store that information in a variable on the server side and keep track of things that way?

3

Thank you. Yes I could store that information, but I would much prefer this could be automated if list_columns() could return the order of columns.

Huarong

4

It may be worth a feature request if you wanted to add one (please see the feature request channel).