SQ MIN

[{"id":"19c5d0a6.21b61f","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"378edf5.a46da2","type":"comment","z":"19c5d0a6.21b61f","name":"Samuel Bertone","info":"","x":860,"y":60,"wires":[]},{"id":"efad1733.73d9d8","type":"inject","z":"19c5d0a6.21b61f","name":"SELECT min(Milliseconds) FROM tracks;","topic":"1","payload":"","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":580,"y":160,"wires":"565a0b74.8b18b4"},{"id":"1103fbfc.9bead4","type":"sqlite","z":"19c5d0a6.21b61f","mydb":"e1049c36.50552","sqlquery":"msg.topic","sql":"","name":"SQLite MIN Database","x":920,"y":360,"wires":"32f63ee3.4857d2","9455a566.d020d8"},{"id":"fea93e00.10b1f","type":"ui_template","z":"19c5d0a6.21b61f","group":"a1a48baf.c479a8","name":" TrackId, Name, AlbumId","order":1,"width":"6","height":"16","format":"<style>\n.table\n{\n \n background:lightblue;\n}\n</style>\n<div class="table">\n<table style="width:100%">\n

\n Milliseconds \n \n <tr ng-repeat="x in msg.payload | limitTo:50">\n {{msg.selected[$index].Milliseconds}}\n \n\n","storeOutMessages":true,"fwdInMessages":true,"templateScope":"local","x":1130,"y":260,"wires":]]},{"id":"565a0b74.8b18b4","type":"function","z":"19c5d0a6.21b61f","name":"SELECT min(Milliseconds) FROM tracks;","func":"msg.topic = "SELECT min(Milliseconds) FROM tracks;"\nreturn msg;\n\n\n","outputs":1,"noerr":0,"x":620,"y":260,"wires":[["1591b37b.b0130d","1103fbfc.9bead4","fea93e00.10b1f"},{"id":"1591b37b.b0130d","type":"debug","z":"19c5d0a6.21b61f","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":950,"y":160,"wires":[]},{"id":"32f63ee3.4857d2","type":"change","z":"19c5d0a6.21b61f","name":"","rules":[{"t":"set","p":"selected","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1150,"y":360,"wires":"fea93e00.10b1f"},{"id":"9455a566.d020d8","type":"debug","z":"19c5d0a6.21b61f","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":1150,"y":480,"wires":[]},{"id":"b0581c2e.47519","type":"ui_button","z":"19c5d0a6.21b61f","name":"","group":"8c4f6084.e7771","order":1,"width":0,"height":0,"passthru":false,"label":"Start","tooltip":"","color":"","bgcolor":"","icon":"","payload":"","payloadType":"date","topic":"SELECT min(Milliseconds) FROM tracks;","x":330,"y":260,"wires":"565a0b74.8b18b4"},{"id":"e1049c36.50552","type":"sqlitedb","z":"","db":"C:\Users\s.bertone\Desktop\db\chinook.db","mode":"RWC"},{"id":"a1a48baf.c479a8","type":"ui_group","z":"","name":"Default","tab":"756402b1.aa9a8c","disp":true,"width":"6","collapse":false},{"id":"8c4f6084.e7771","type":"ui_group","z":"","name":"Other-UI","tab":"756402b1.aa9a8c","disp":true,"width":"6","collapse":false},{"id":"756402b1.aa9a8c","type":"ui_tab","z":"","name":"Other DB","icon":"dashboard","disabled":false,"hidden":false}]