Differences

This shows you the differences between two versions of the page.

--- emrp2021:start [2022/03/09 20:34] – [5. Dynamic pivot and DashPlotly] sinan001
+++ emrp2021:start [2022/03/09 20:42] – [6. Links and Tutorials] sinan001
@@ Line 423: / Line 423: @@
 As a result, it is now possible to call up the last measured values for each device in a pivoted manner, instead of having to decide on a measurement type as in the previous version, it is now possible to call up the last date and the corresponding measurements for all devices.
-{{:emrp2021:all_measurements.png?980|}}
+{{:emrp2021:all_measurements.png?990|}}
 |//Figure 60: last measurement per device//|
+In order for it to work, all columns must always be displayed, instead of defining only some columns statically, as was done in the previous version.
+{{:emrp2021:choose_all_columns.png?600|}}
+|//Figure 61: choose all columns//|
 ===== 6. Links and Tutorials =====
@@ Line 432: / Line 438: @@
   * SQL-Querries (Postgresql) in Node-Red: https://flows.nodered.org/node/node-red-contrib-postgresql/in/MFnap-qr-MJE
   * TTN, MQTT Node-REd: https://www.thethingsindustries.com/docs/integrations/mqtt/
+  * dynamic pivoting using Postgresql PL/PGSQL: https://github.com/hnsl/colpivot