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 [2023/01/05 14:38] (current) – external edit 127.0.0.1
@@ 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 =====
+  * __CODE used in the project:__ **https://github.com/ubaidadib/EMRP_WS_2021_Project**
   * Mix-Playlist about different topics: https://www.youtube.com/playlist?list=PL2SRmCaIeDVibo6IUItyKcmDCH955hqAT
   * Link for ttn: https://www.thethingsnetwork.org/
   * 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