> 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.011.md).

# 3.6.011

* [#inventory](#inventory "mention")
  * [#add-tab-muni-on-selector-showing-as-many-exploitations-as-the-municipality-has-disabled-by-default](#add-tab-muni-on-selector-showing-as-many-exploitations-as-the-municipality-has-disabled-by-default "mention")
  * [#enable-the-possibility-to-use-a-specific-sequence-on-code-for-every-feature-type](#enable-the-possibility-to-use-a-specific-sequence-on-code-for-every-feature-type "mention")
  * [#relate-connec.plot\_code-with-table-by-using-plot-code-if-variable-edit\_connec\_autofill\_plotcode-is-t](#relate-connec.plot_code-with-table-by-using-plot-code-if-variable-edit_connec_autofill_plotcode-is-t "mention")
  * [#new-field-on-ext\_municipality-ext\_region-ext\_province-ext\_code](#new-field-on-ext_municipality-ext_region-ext_province-ext_code "mention")
  * [#add-utils-table-ext\_province\_x\_region-with-double-fk-to-ext\_municipality](#add-utils-table-ext_province_x_region-with-double-fk-to-ext_municipality "mention")
  * [#add-combo-for-feature\_type-on-dimensions-dialog-arc-node-connec-gully](#add-combo-for-feature_type-on-dimensions-dialog-arc-node-connec-gully "mention")
* [#om](#om "mention")
  * [#rename-config\_graph\_inlet-to-config\_graph\_mincut](#rename-config_graph_inlet-to-config_graph_mincut "mention")
  * [#remove-expl\_id-from-config\_graph\_mincut](#remove-expl_id-from-config_graph_mincut "mention")
  * [#disable-mincut-if-user-hasnt-any-inlet-on-canvas-to-work-with](#disable-mincut-if-user-hasnt-any-inlet-on-canvas-to-work-with "mention")
  * [#remove-config\_graph\_valve-strategy-by-using-graph\_delimiter-column-from-cat\_feature](#remove-config_graph_valve-strategy-by-using-graph_delimiter-column-from-cat_feature "mention")
  * [#add-symbol-on-profiles-slope](#add-symbol-on-profiles-slope "mention")
* [#epa](#epa "mention")
  * [#remove-to\_arc-and-status-on-inp\_shortpipe.-instead-now-inventory-values-are-used](#remove-to_arc-and-status-on-inp_shortpipe.-instead-now-inventory-values-are-used "mention")
* [#masterplan](#masterplan "mention")
  * [#new-variable-plan\_node\_replace\_code](#new-variable-plan_node_replace_code "mention")
  * [#new-fields-on-plan\_netscenario\_presszone-and-plan\_netscenario\_dma-stylesheet-expl\_id2](#new-fields-on-plan_netscenario_presszone-and-plan_netscenario_dma-stylesheet-expl_id2 "mention")
* [#admin-system](#admin-system "mention")
  * [#enhance-cat\_manager-by-working-with-system-users-and-roles](#enhance-cat_manager-by-working-with-system-users-and-roles "mention")
  * [#clean-dbmodel-drop-views-vi\_parent\_arc-and-v\_anl\_flow](#clean-dbmodel-drop-views-vi_parent_arc-and-v_anl_flow "mention")

## **INVENTORY**

### <mark style="color:blue;">Add tab muni on Selector showing as many exploitations as the municipality has (disabled by default)</mark>

A new tab has been added in order to see the exploitations that each municipality has. To enable this tab, the column "enabled" in table "config\_param\_system" has to be set to "True" for the parameter "basic\_selector\_tab\_municipality".

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2F5OXZUnRlPoizaWdOe99R%2Fimage.png?alt=media&amp;token=8a25a707-85d6-4444-ac78-7be18cc93e4d" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Enable the possibility to use a specific sequence on code for every feature type</mark>

A new functionality has been developed in order to set a customized code for feature types. First, it is necessary to create a sequence on the database which name is the concatenation of the "id" of table "cat\_feature" and the words "code\_seq" (i.e "circ\_manhole\_code\_seq). Then, this sequence is going to be used when inserting new objects of that type of feature.&#x20;

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2F8mzdcF8z3f63HdVKCaUe%2Fimage.png?alt=media&amp;token=04f53f4e-6a4b-4b44-a6ac-1c87372c1734" alt=""><figcaption></figcaption></figure>

Additionally, a prefix can be used in combination of the sequence to build the code for the object. To do so, a JSON string has be to added in column "addparam" of table "cat\_feature". This JSON has to contain the key "code\_prefix" and the prefix itself as the value of that key.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FKXtEvNGBQk4eBcKc7Wyi%2Fimage.png?alt=media&amp;token=b931b127-d7e1-4e45-bd80-77858d419920" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Relate connec.plot\_code with table by using plot code if variable edit\_connec\_autofill\_plotcode is true</mark>

If true, this variable enables the possibility to capture by intersection the plot code for the connec inserted. It can be found in table "config\_param\_system" where parameter name is "edit\_connec\_autofill\_plotcode". It is necessary to fill the table "ext\_plot" with the geometries of the plots and its cadastral reference or plot code in order to see how it works.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2Fz9o9pvyw4VlpCxlcIlIx%2Fimage.png?alt=media&amp;token=5c0fdf91-d7cd-4b1b-8c84-5f7e321a4f17" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">New field on ext\_municipality, ext\_region, ext\_province: ext\_code</mark>

A new field has been added into tables "ext\_municipality", "ext\_region" and "ext\_province" under the name of "ext\_code". The aim of this field is to enable the possibility to use an external code to identify the municipality, region and province. This code can be either an oficial standard code or a customized code.

### <mark style="color:blue;">Add utils table ext\_province\_x\_region with double fk to ext\_municipality</mark>

A new table called "ext\_province\_x\_region" has been added with foreign keys to table "ext\_muncipality". This table stores the relationship between province and regions.&#x20;

### <mark style="color:blue;">Add combo for feature\_type on dimensions dialog \[ARC, NODE, CONNEC {GULLY}]</mark>

Now, it it possible to choose the feature type in the info form of a dimension object.&#x20;

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FDEzPk1P2AQTBoGCqzgVh%2Fimage.png?alt=media&amp;token=8c8bd678-f04b-409b-9492-2f7ee70dc69d" alt=""><figcaption></figcaption></figure>

## **OM**

### <mark style="color:blue;">Rename config\_graph\_inlet to config\_graph\_mincut</mark>

Table "config\_graph\_inlet" has been renamed to "config\_graph\_mincut".&#x20;

### <mark style="color:blue;">Remove expl\_id from config\_graph\_mincut</mark>

Column "expl\_id" has been removed from table "config\_graph\_mincut".&#x20;

### <mark style="color:blue;">Disable mincut if user hasn't any inlet on canvas to work with</mark>

Mincut is disabled unless an operative inlet is located in the working canvas.

### <mark style="color:blue;">Remove config\_graph\_valve strategy by using graph\_delimiter column from cat\_feature</mark>

The configuration for valves now it is done by column "graphdelimiter" of table "cat\_feature".

### <mark style="color:blue;">Add '%' symbol on profile's slope</mark>

The symbol "%" now appears in the profile picture in order to show the units of slope.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FnnFLFgGtZ91VTO0UOjd3%2Fimage.png?alt=media&amp;token=2c06dcce-4741-47b8-8a66-85a5c7b5ed24" alt=""><figcaption></figcaption></figure>

## **EPA**

### <mark style="color:blue;">Remove to\_arc and status on inp\_shortpipe. Instead, now inventory values are used</mark>

Columns "to\_arc" and "status" can now be found in table "config\_graph\_checkvalve" as part of the inventory values.&#x20;

## **MASTERPLAN**

### <mark style="color:blue;">New variable "plan\_node\_replace\_code"</mark>

The aim of this variables is to trace the original code to a node that has been involved in a feature when a node replace is done in planification mode using the spceific tool Psector Relations tab. This variable can be found in table "config\_param\_system" under the name of "plan\_node\_replace\_code".&#x20;

### <mark style="color:blue;">New field on plan\_netscenario\_presszone: presszone\_type</mark>

A new column "presszone\_type" has been added to table "plan\_netscenario\_presszone". The available values for this columns are present in catalog "edit\_typevalue" where column "typevalue" is "presszone\_type".

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FQRqzNtlI25626ynxbOdT%2Fimage.png?alt=media&amp;token=87e30c8d-879e-43f4-ac7a-7db16c078d86" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">New fields on plan\_netscenario\_presszone and plan\_netscenario\_dma: stylesheet, expl\_id2</mark>

New columns "stylesheet" and "expl\_id2" have been added to tables "plan\_netscenario\_presszone" and "plan\_netscenario\_dma".

## **ADMIN/SYSTEM**

### <mark style="color:blue;">Enhance cat\_manager by working with system users and roles</mark>

Now, the table "cat\_manager" works with database system roles and users instead of working with the content of table "cat\_users".

### <mark style="color:blue;">Clean dbmodel: Drop views vi\_parent\_arc, and v\_anl\_flow\_\*</mark>

Views vi\_parent\_arc and v\_anl\_flow views have been deleted in order to clean unnecessary views.