Database default values don't work in QGIS

[ponceta]

Describe the bug Database default values only work database side but are overwritten by QGIS

To Reproduce Exact steps to reproduce the behavior:

1. Open TWW QGIS project
2. Define values for fk_provider and fk_dataowner
3. Create a Wastewater structure
4. default fk_provider and fk_dataowner are not displayed
5. Click ok and reopen the same form
6. fk_provider and fk_dataowner are not selected

Expected behavior A user can define default fk_provider and fk_dataowner in QGIS too.

Screenshots / data

Desktop (please complete the following information):

• TWW version
• QGIS Version
• OS

Additional context Add any other context about the problem here.

[cymed]

When did you create your default values entries? We only set the default values on od (using tww_app.set_default_values) by using a trigger on tww_od.default_values. https://github.com/teksi/wastewater/blob/c7c7e36b71a8bbde9aa1da13dd17347300e74007/datamodel/app/functions/organisation_functions.sql#L57

[sjib]

see also https://github.com/teksi/wastewater/issues/425

[ponceta]

Default values have been inserted :

But when the db queries it, it returns NULL :

Is it right to call it BEFORE the INSERT?

https://github.com/teksi/wastewater/blob/4a9d9bb469c5335bec06b7e822f93cbe833763bf/datamodel/app/functions/organisation_functions.sql#L124-L130

My current workaround is to define QGIS variables :

But this will require some project configurations and I would rather have a db working solution.