Here you see the export of the flow:
[{"id":"5652cf9d.e232e","type":"tab","label":"Diagramme","disabled":false,"info":""},{"id":"ec61f421.769e88","type":"inject","z":"5652cf9d.e232e","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":true,"onceDelay":0.1,"x":130,"y":60,"wires":[["6c86c495.88178c"]]},{"id":"6c86c495.88178c","type":"function","z":"5652cf9d.e232e","name":"Sensoren abfragen","func":"msg.topic = \"SELECT `ID`, `Name` FROM `komponenten` WHERE `Komponententyp` = 1\";\nreturn msg;","outputs":1,"noerr":0,"x":330,"y":60,"wires":[["4fe5c17a.a153f8"]]},{"id":"23f78aa8.195c9e","type":"function","z":"5652cf9d.e232e","name":"Sensoren fĂĽr DropDown anpassen","func":"var data = msg.payload;\nmsg = {};\n\nmsg.options = data.map(function(value) {\n var v = {};\n v[value.Name] = value.ID;\n return v;\n})\nreturn msg;\n\n/*var objekt = [];\nvar Laenge = msg.payload.length;\n\nvar zaehler = 0;\nwhile (zaehler <= Laenge - 1){\n var tempArray = {};\n var Identifier = msg.payload[zaehler].ID;\n var User = msg.payload[zaehler].Name;\n tempArray = {1 : User};\n objekt.push(tempArray);\n zaehler++;\n}\nmsg.options = objekt;\n\nreturn msg;*/","outputs":1,"noerr":0,"x":860,"y":60,"wires":[["74d54ddb.8a875c","ad684031.8a57f"]]},{"id":"74d54ddb.8a875c","type":"ui_dropdown","z":"5652cf9d.e232e","name":"","label":"","tooltip":"","place":"Select option","group":"bc3130eb.587ef8","order":1,"width":0,"height":0,"passthru":false,"options":[],"payload":"","topic":"","x":1100,"y":60,"wires":[[]]},{"id":"4fe5c17a.a153f8","type":"mysql","z":"5652cf9d.e232e","mydb":"266f9218.e6ca8e","name":"Datenbank BLA_ALPHA","x":570,"y":60,"wires":[["23f78aa8.195c9e"]]},{"id":"ad684031.8a57f","type":"debug","z":"5652cf9d.e232e","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"options","targetType":"msg","x":1110,"y":160,"wires":[]},{"id":"bc3130eb.587ef8","type":"ui_group","name":"Group 1","tab":"895c7501.0a7268","order":1,"disp":true,"width":6},{"id":"266f9218.e6ca8e","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"BLA_ALPHA","tz":""},{"id":"895c7501.0a7268","type":"ui_tab","z":"","name":"Diagramme","icon":"dashboard","order":4,"disabled":false,"hidden":true}]