teksi / wastewater

[DEV] Future TEKSI wastewater module, adapted data model to fit VSA-DSS 2020 new standard
https://teksi.github.io/wastewater
GNU General Public License v3.0
2 stars 5 forks source link

optimize main ws views #415

Closed cymed closed 1 month ago

cymed commented 2 months ago

General

Describe your changes

skip "_usage_current", "_function_hierarchic", "_status" from wn, as "_usage_current", "_function_hierarchic" are loaded in a different wayn and having wn__status is not bringing any value but confusion.

Screenshots

image

Issue ticket number and link

Checklist before requesting a review

Checklist before merge

ponceta commented 1 month ago

@cymed could you add some more context and maybe screenshots of how it impacts currents project forms?

cymed commented 1 month ago

We have three attributes on wastewater_node "_usage_current", "_function_hierarchic" and "_status" that are calculated on the database. All three are not shown in any form of vw_tww_wastewater_structure. The information of "wnusage_current" is also in "channel_usage_current", "wn__function_hierarchic" in "channel_function_hierarchic" and "wnstatus" in "status".

This PR excludes these three attributes from the main view