projects
/
eg5120
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
d1c923d
)
show by type and mac
author
Dobrica Pavlinusic
<dpavlin@rot13.org>
Sat, 8 Jul 2023 13:50:19 +0000
(15:50 +0200)
committer
Dobrica Pavlinusic
<dpavlin@rot13.org>
Sat, 8 Jul 2023 13:50:19 +0000
(15:50 +0200)
queries.sql
patch
|
blob
|
history
diff --git
a/queries.sql
b/queries.sql
index
221cbbe
..
216f518
100644
(file)
--- a/
queries.sql
+++ b/
queries.sql
@@
-1,2
+1,12
@@
-select count(*),min(time),max(time),sensor_type,json->'sensor_name' as sensor_name from eg5120 group by sensor_type,sensor_name;
+select count(*),min(time),max(time),
+sensor_type,
+addr as mac,
+json->'sensor_name' as sensor_name
+from eg5120
+group by
+sensor_type,
+addr,
+sensor_name
+order by sensor_type asc, max desc
+;