> For the complete documentation index, see [llms.txt](https://giswater.gitbook.io/change-log/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://giswater.gitbook.io/change-log/3.6.010.md).

# 3.6.010

* [#inventory](#inventory "mention")
  * [#refactor-database-structure-to-manage-additional-fields](#refactor-database-structure-to-manage-additional-fields "mention")
  * [#change-qgis-templates-add-direction-arrow-on-links-and-delete-flowtrace-layers-for-ud](#change-qgis-templates-add-direction-arrow-on-links-and-delete-flowtrace-layers-for-ud "mention")
  * [#cad-tools-show-a-preview-of-what-will-be-drawn-and-change-circle-geometry-type-to-multicurve](#cad-tools-show-a-preview-of-what-will-be-drawn-and-change-circle-geometry-type-to-multicurve "mention")
  * [#add-layers-button-ask-before-removing-a-layer](#add-layers-button-ask-before-removing-a-layer "mention")
  * [#refactor-of-gw\_trg\_link\_connecrotation\_update.-drop-not-necessary-code-and-make-it-useful-for-qgis-l](#refactor-of-gw_trg_link_connecrotation_update.-drop-not-necessary-code-and-make-it-useful-for-qgis-l "mention")
  * [#new-field-meter\_code-on-man\_meter-ws](#new-field-meter_code-on-man_meter-ws "mention")
* [#om](#om "mention")
  * [#allow-using-the-selected-exploitations-on-mapzones-analysis](#allow-using-the-selected-exploitations-on-mapzones-analysis "mention")
* [#epa](#epa "mention")
  * [#enable-tab-additional-pump-in-dscenario-and-add-edit-controls-and-rules-with-proper-dialog](#enable-tab-additional-pump-in-dscenario-and-add-edit-controls-and-rules-with-proper-dialog "mention")
  * [#calculate-avg\_press-on-mapzones-for-corporate-results](#calculate-avg_press-on-mapzones-for-corporate-results "mention")
* [#admin-system](#admin-system "mention")
  * [#pg\_service-improve-management-of-credentials-when-using-pgservice-file](#pg_service-improve-management-of-credentials-when-using-pgservice-file "mention")

## **INVENTORY**

### <mark style="color:blue;">Refactor database structure to manage additional fields</mark>

A huge refactor has been done in order to manage additional fields (addfields), which results in a better database organization and efficiency. In terms of the appearance, an enhancement has been done in the dialogs in order to ease the addition of fields to all features, specific features or each singular element from table cat\_feature. Moreover, the value domain of the selectors and text boxes from the dialog have been changed in order to standardize and fix the relation between the dialog and table "config\_form\_fields".&#x20;

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2F6s5iS2VF8EcmTTkCUjuK%2Fimage.png?alt=media&amp;token=b3bb3713-17da-4aef-9d15-0538e9178096" alt=""><figcaption></figcaption></figure>

In terms of functionality, the table "man\_addfields\_value" has been removed with the purpose of simpliflying the management of values of the additional fields that are created. Thus, for each feature involved in the creation of an additional field, a new separate table is created in order to store the values of its additional fields.&#x20;

As an example, an additional field created for hydrants will lead to the creation of a new table consisting of the feature\_id and as many columns as there are additional fields for the hydrant. On the other hand, when additional fields for multiple features are created, a new column for each additional table is created. Finally, the additional fields are added to child views by joining these additional tables to the editable views.

### <mark style="color:blue;">Change QGIS templates: add direction arrow on links and delete flowtrace layers for UD</mark>

An arrow has been added to links' symbology of the QGIS template project in order to show their direction. This arrow can only be seen at high zooms.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FD2ZAuVg36i21cZESDN1u%2Fimage.png?alt=media&amp;token=2768d537-79a8-42c1-a9bc-da77d4834792" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">CAD Tools: Show a preview of what will be drawn & change circle geometry type to MultiCurve</mark>

An enhancement in CAD tools has been implemented by showing a preview of the geometry as values are entered in the text boxes. This results in a more interactive tool and easy to use.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FfMHgIW5QyPAvC8ZABZfx%2Fimage.png?alt=media&amp;token=1b532473-8f93-4065-a2d5-2601ce730a42" alt=""><figcaption></figcaption></figure>

Moreover, the geometry type of circles has been changed to multicurve as an enhancement in order to simplify the geometry.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FgabLoJIOCg5dFI5QXiRs%2Fimage.png?alt=media&amp;token=490e628b-7ae3-4e89-b404-037f487af371" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Add layers button: ask before removing a layer</mark>

A warning appears when a layer that has been previously loaded through Add Giswater Layers button is going to be removed from QGIS Canvas.&#x20;

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2Fa44MMclJ0S0q2vSj5PL9%2Fimage.png?alt=media&amp;token=e0fc2f90-b377-4f5e-90e4-be44e7c076bd" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Refactor of gw\_trg\_link\_connecrotation\_update. Drop not necessary code and make it useful for QGIS latest versions (quadrant has change to position priority)</mark>

An enhancement has been done in connecs' symbology in order to rotate its label using the angle between the pipe and its link. This is controlled through a variable in table "config\_param\_system" called "edit\_link\_update\_connecrotation" and it takes boolean values (true or false to enable or disable this property).&#x20;

Once the variable is set to True, the symbology of connecs must be configurated by using the parameters' configuration written in column "descript" of table "config\_param\_system" for the parameter "edit\_link\_update\_connecrotation".

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FEMpe3pBjxnWQWx4JrlP8%2Fimage.png?alt=media&amp;token=01150592-f05b-48db-8b85-72f0ac0beb26" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">New field meter\_code on man\_meter (WS)</mark>

A new field has been added to table "man\_meter" under the name of "meter\_code" in order to type the serial number or identification code for that meter.

## **OM**

### <mark style="color:blue;">Allow using the selected exploitations on mapzones analysis</mark>

A new option has been added to the dialog of Mapzones Analysis in order to execute the mapzones analysis for the selected exploitation in the Giswater Selector.&#x20;

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FCUAIHT1KoqyhQPDUTnME%2Fimage.png?alt=media&amp;token=87dc41dd-07da-474e-8dd0-2cce5a153b61" alt=""><figcaption></figcaption></figure>

## **EPA**

### <mark style="color:blue;">Enable tab 'Additional pump' in Dscenario and add/edit controls & rules with proper dialog</mark>

The dialogs for Additional Pumps, Rules and Controls have been enabled. Now, it is possible to add additional pumps, controls or rules to the selected dscenario.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FtSzCPwfEkHFzpjqPzZic%2Fimage.png?alt=media&amp;token=1c52f12b-329c-4c35-aeec-f3dd0343701e" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Calculate avg\_press on mapzones for corporate results</mark>

Now, when a hydraulic model is set as a corporate, the mean pressure of all nodes and/or connecs (depending on the selected simulation options) is calculated for all the mapzones involved in that model. This value is stored in column "avg\_press" for each mapzone table in WS projects.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FzmovKGr9qsOUtTVFCEHZ%2Fimage.png?alt=media&amp;token=a70e3acf-852d-4cd2-9c1c-5f1c1d918ec3" alt=""><figcaption></figcaption></figure>

## **ADMIN/SYSTEM**

### <mark style="color:blue;">PG\_SERVICE: Improve management of credentials when using pgservice file</mark>

An enhancement has been done in order to manage the PG Service credentials by adding a new environment variable.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2F14ZghpatPBS7BQ9kdnfR%2Fimage.png?alt=media&amp;token=1af42f14-8dda-4119-b307-1ad3d2e0f742" alt=""><figcaption></figcaption></figure>