# 3.6.003

## INDEX

* [#inventory](#inventory "mention")
  * [#add-new-function-to-make-massive-interpolation-for-nodes-ud](#add-new-function-to-make-massive-interpolation-for-nodes-ud "mention")
* [#epa](#epa "mention")
  * [#go2epa-multistep-approach](#go2epa-multistep-approach "mention")
  * [#add-properties-button-in-dscenario-dialog](#add-properties-button-in-dscenario-dialog "mention")
  * [#improvements-and-fixes-to-flowregulator-and-demand-actions](#improvements-and-fixes-to-flowregulator-and-demand-actions "mention")
* [#admin-system](#admin-system "mention")
  * [#drop-config\_visit\_class\_x\_feature-unused-table](#drop-config_visit_class_x_feature-unused-table "mention")
  * [#reduce-the-time-it-takes-to-open-the-info-form](#reduce-the-time-it-takes-to-open-the-info-form "mention")
  * [#fix-highlight-for-polygons](#fix-highlight-for-polygons "mention")

## INVENTORY

### <mark style="color:blue;">Add new function to make massive interpolation for nodes (UD)</mark>

Massive interpolation is a new function very similar to the conventional Interpolation Function that already exists and it updates the elevation of all nodes by means of interpolation.

This function has to be executed through SQL Query on a data base manager outside from QGIS and it only works for Giswater UD Projects. A sample query can be found in the upper part of the file where the function is stored. It is optional to carefully modify the last statement from the sample function, which corresponds to the "queryFilter" parameter. The "queryFilter" parameter can contain a SQL statement in order to execute the function for a specific group of nodes that share any characteristic (for example, those nodes whose elevation is a null value). The value for the "queryFilter" parameter (which is the SQL statement) can be left null by keeping its double quotes and therefore the function will work for all nodes without any exception.&#x20;

```sql
SELECT ud.gw_fct_node_interpolate_massive ($${"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, "feature":{}, "data":{"parameters":{"queryFilter":""}}}$$);
```

## EPA

### <mark style="color:blue;">Go2Epa multistep approach</mark>

This enhancement not only consists of a more detailed log message when exporting the inp file but also consists of a better performance of the whole process. This means that the process is faster and does not block the tables of the database that are involved in it.&#x20;

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2Fo6LhZzKSpH9LA6aSNCSa%2Fimage.png?alt=media&#x26;token=1408cf85-c6be-4ea6-89ba-b21a524a149e" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Add properties button in dscenario dialog</mark>

A button of **Properties** has been added to each individual dscenario in order to manage its general options in a more efficient way. The user can modify the general dscenario properties and eventually they will be updated immediately. On the other hand, the specific features involved in each dscenario can be modified the same way as before.

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FEmDzbk8YTZ8TRZ3qzvCB%2Fimage.png?alt=media&#x26;token=1305f0c2-849f-4236-8d0f-48bf772587d7" alt=""><figcaption></figcaption></figure>

### <mark style="color:blue;">Improvements & fixes to flowregulator & demand actions</mark>

Some fixes have been done in the upper tool bar of the tab EPA that have been recently introduced in version 3.6.&#x20;

## ADMIN/SYSTEM

### <mark style="color:blue;">Drop config\_visit\_class\_x\_feature (unused table)</mark>

Table **config\_visit\_class\_x\_feature** have been deleted as this table is deprecated.&#x20;

### <mark style="color:blue;">Reduce the time it takes to open the info form</mark>

Performance on opening the Info Form has been enhanced and now it opens faster.&#x20;

### <mark style="color:blue;">Fix highlight for polygons</mark>

This prevents the plugin from crashing when using the Info Button for a polygon of a feature. Now, it is save to do this procedure without any problem.&#x20;

<figure><img src="https://78444640-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3OfYgdaTSD51CRsy2UO6%2Fuploads%2FlRIoLb4QnwTZSFgmpVLN%2Fimage.png?alt=media&#x26;token=bad2b539-3228-487c-8e06-9a5cc93c94fa" alt=""><figcaption></figcaption></figure>