How do I update the lists of select one fields directly through the database?

Welcome on the odk forum. Please take some time to Introduce yourself here! - #1110 by tiensinh3030

Choices list are not stored in the database. So you will have to update medias on the aggregate server.

In the past I wanted to do such a thing I finally never investigate to automate it.
But I had in mind to generate media files with psql and after push a new form version and media files to aggregate using briefcase (in a cron task)
https://docs.getodk.org/briefcase-using/#push-to-aggregate

And maybe I will need it soon, since we use collect to inventory and follow some hydrolic valves on the field. If a new one is created, I will need it in my choice list to follow its waterlevel later.

Please let me us know if you achieve this.

1 Like