[Suche] Javascript das eine Tabelle im JSON ausgibt

paul53

@quorle
Versuche es mal hiermit:

<xml xmlns="https://developers.google.com/blockly/xml">
 <variables>
   <variable id="Fwt*3`3ScyT(qDt?gf(T">ObjectID</variable>
   <variable id="}dJI#n7D?(yn(S7IZetS">Liste</variable>
   <variable id="K@h0-NY5VaI|@t!5/iJh">Wert</variable>
   <variable id="2TXuU=:-J^z#1tz2?m+)">test</variable>
   <variable id="W6/l[G~B{Zwv5)Rz4siZ">anzahl_oben</variable>
   <variable id="Sk[;o=!/U_$I6Wr,/;!b">anzahl_unten</variable>
   <variable id="fe!@@dhB{4wJ~YaxWG%C">i</variable>
 </variables>
 <block type="procedures_defcustomreturn" id="!t;U0AgoNU@W*^{W;)1~" x="-1288" y="-1812">
   <mutation statements="false">
     <arg name="Liste" varid="}dJI#n7D?(yn(S7IZetS"></arg>
     <arg name="Wert" varid="K@h0-NY5VaI|@t!5/iJh"></arg>
   </mutation>
   <field name="NAME">Multisort</field>
   <field name="SCRIPT">dmFyIFdlcnQgPSBXZXJ0IC0gMTsgCkxpc3RlLnNvcnQoZnVuY3Rpb24oYSwgYil7CiAgICByZXR1cm4gYltXZXJ0XSAtIGFbV2VydF07Cn0pOwpyZXR1cm4gTGlzdGU7</field>
   <comment pinned="false" h="80" w="160">Beschreibe diese Funktion …</comment>
 </block>
 <block type="variables_set" id="M*e-%li=rNRAKW!{S*Fi" disabled="true" x="-1287" y="-1761">
   <field name="VAR" id="2TXuU=:-J^z#1tz2?m+)">test</field>
   <value name="VALUE">
     <block type="convert_json2object" id="HodxuAjF0Dakr,,xDdpw">
       <value name="VALUE">
         <block type="text" id="s=LJUvclbq%Wb6B;E/^k">
           <field name="TEXT">[["WC Status untere Position",false],["WC oben",true],["Schlafzimmer Fenster Status untere Position",false],["Schlafzimmer Fenster oben",true],["Schlafzimmer Balkontüre Status untere Position",false],["Schlafzimmer Balkontüre oben",true],["Kinderzimmer Lea Status untere Position",false],["Kinderzimmer Lea oben",true],["Kinderzimmer Antonia Status untere Position",false],["Kinderzimmer Antonia oben",true],["Gästezimmer Status untere Position",true],["Gästezimmer oben",false],["Jonas Fenster Status untere Position",false],["Jonas Fenster oben",true],["Wohnzimmer Fenster Status untere Position",false],["Wohnzimmer Fenster oben",true],["Wohnzimmer Balkontüre Status untere Position",false],["Wohnzimmer Balkontüre oben",true],["WC Fenster Status untere Position",false],["WC Fenster oben",true],["Küche Fenster Status untere Position",false],["Küche Fenster oben",true]]</field>
         </block>
       </value>
     </block>
   </value>
   <next>
     <block type="schedule" id="Cqz)^1L5B-*_#wudd;?i">
       <field name="SCHEDULE">*/20 * * * * *</field>
       <statement name="STATEMENT">
         <block type="variables_set" id="sWqJxa.MyY?*y-S}mHPz">
           <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
           <value name="VALUE">
             <block type="lists_create_with" id="s1KG8o;:gtQ6DjJt@w9I">
               <mutation items="0"></mutation>
             </block>
           </value>
           <next>
             <block type="variables_set" id="R6exgi+-F7xoKVW/[NE.">
               <field name="VAR" id="W6/l[G~B{Zwv5)Rz4siZ">anzahl_oben</field>
               <value name="VALUE">
                 <block type="math_number" id="AHHG~c/mltPLQ?]Ik;5M">
                   <field name="NUM">0</field>
                 </block>
               </value>
               <next>
                 <block type="variables_set" id="**}`+OgV6}BW5TBMd{`s">
                   <field name="VAR" id="Sk[;o=!/U_$I6Wr,/;!b">anzahl_unten</field>
                   <value name="VALUE">
                     <block type="math_number" id="u(R`,V@+GYc(yI=W0rOU">
                       <field name="NUM">0</field>
                     </block>
                   </value>
                   <next>
                     <block type="controls_forEach" id="~PaFX`X@5n{TM9K^{Jw6">
                       <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                       <value name="LIST">
                         <block type="selector" id="xQ^Q5{h5V@5PLI+YO@i.">
                           <field name="TEXT">*_Position(functions=blinds)</field>
                         </block>
                       </value>
                       <statement name="DO">
                         <block type="debug" id="XZDv+4g$1.=ljXu_70B*" disabled="true">
                           <field name="Severity">warn</field>
                           <value name="TEXT">
                             <shadow type="text">
                               <field name="TEXT">test</field>
                             </shadow>
                             <block type="variables_get" id="WiV$3M9_AvyO[2zGP3_e">
                               <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                             </block>
                           </value>
                           <next>
                             <block type="controls_if" id="BpYF0w{plR^$Bj;f$G-X">
                               <mutation elseif="1"></mutation>
                               <value name="IF0">
                                 <block type="logic_compare" id=":U;pkPjDX!X*x`]J^[=f">
                                   <field name="OP">GT</field>
                                   <value name="A">
                                     <block type="text_indexOf" id="dQ?$f$~34KAwRQzHZy2v">
                                       <field name="END">FIRST</field>
                                       <value name="VALUE">
                                         <block type="variables_get" id="YN=/IOiNU1e/z47W_hYO">
                                           <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                         </block>
                                       </value>
                                       <value name="FIND">
                                         <shadow type="text" id="YJ_ZaIlitzIz0lbSIy]Z">
                                           <field name="TEXT">obere</field>
                                         </shadow>
                                       </value>
                                     </block>
                                   </value>
                                   <value name="B">
                                     <block type="math_number" id="(4uegeXx!R!5`x./Zrpy">
                                       <field name="NUM">0</field>
                                     </block>
                                   </value>
                                 </block>
                               </value>
                               <statement name="DO0">
                                 <block type="math_change" id=";nI|WSdj!-!_]9^hXce=">
                                   <field name="VAR" id="W6/l[G~B{Zwv5)Rz4siZ">anzahl_oben</field>
                                   <value name="DELTA">
                                     <shadow type="math_number" id="7NsDd4.5wRJiN$ohzcPz">
                                       <field name="NUM">1</field>
                                     </shadow>
                                   </value>
                                   <next>
                                     <block type="lists_setIndex" id="V%X2]!(FWN#b!Icp,vEn">
                                       <mutation at="true"></mutation>
                                       <field name="MODE">INSERT</field>
                                       <field name="WHERE">FROM_START</field>
                                       <value name="LIST">
                                         <block type="variables_get" id="d@?Y!wCwVm2J;5#}l@|s">
                                           <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
                                         </block>
                                       </value>
                                       <value name="AT">
                                         <block type="variables_get" id="I{J?cUEic):/$hl^3n{K">
                                           <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                         </block>
                                       </value>
                                       <value name="TO">
                                         <block type="procedures_callcustomreturn" id="Qf=s6+J.KB`I0omt2dx-" inline="true">
                                           <mutation name="Name">
                                             <arg name="ObjectID"></arg>
                                           </mutation>
                                           <value name="ARG0">
                                             <block type="variables_get" id="7`$xI^f!0)3kG%TM66sA">
                                               <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                             </block>
                                           </value>
                                         </block>
                                       </value>
                                     </block>
                                   </next>
                                 </block>
                               </statement>
                               <value name="IF1">
                                 <block type="logic_compare" id=",#NtYtMgV}/:2E1_hNrG">
                                   <field name="OP">GT</field>
                                   <value name="A">
                                     <block type="text_indexOf" id="Yg}H-~{a7x8)+qu:9M|/">
                                       <field name="END">FIRST</field>
                                       <value name="VALUE">
                                         <block type="variables_get" id="8;*NmuJL+=2ZjdGLV@w*">
                                           <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                         </block>
                                       </value>
                                       <value name="FIND">
                                         <shadow type="text" id="NE#zvIT-6LZjV3/;?~mp">
                                           <field name="TEXT">untere</field>
                                         </shadow>
                                       </value>
                                     </block>
                                   </value>
                                   <value name="B">
                                     <block type="math_number" id="J(GT5p9jH?jE][E#[[@;">
                                       <field name="NUM">0</field>
                                     </block>
                                   </value>
                                 </block>
                               </value>
                               <statement name="DO1">
                                 <block type="math_change" id=":_uor[5yVl8xBU+`cMV;">
                                   <field name="VAR" id="Sk[;o=!/U_$I6Wr,/;!b">anzahl_unten</field>
                                   <value name="DELTA">
                                     <shadow type="math_number" id="ieNW@ocv}L*#oj8$X~P1">
                                       <field name="NUM">1</field>
                                     </shadow>
                                   </value>
                                   <next>
                                     <block type="lists_setIndex" id="3`60`J~EA:*j}OOf+Z*c">
                                       <mutation at="true"></mutation>
                                       <field name="MODE">INSERT</field>
                                       <field name="WHERE">FROM_START</field>
                                       <value name="LIST">
                                         <block type="variables_get" id="Q|]yh,v=L+mdd_rKMQdY">
                                           <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
                                         </block>
                                       </value>
                                       <value name="AT">
                                         <block type="variables_get" id="iyFeezsq|O~{G,#T^e=-">
                                           <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                         </block>
                                       </value>
                                       <value name="TO">
                                         <block type="procedures_callcustomreturn" id="Z_doi2a.Vs634-ZCc8|6" inline="true">
                                           <mutation name="Name">
                                             <arg name="ObjectID"></arg>
                                           </mutation>
                                           <value name="ARG0">
                                             <block type="variables_get" id="fA)(tvzda:,Du0s;bs-#">
                                               <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                             </block>
                                           </value>
                                         </block>
                                       </value>
                                     </block>
                                   </next>
                                 </block>
                               </statement>
                             </block>
                           </next>
                         </block>
                       </statement>
                       <next>
                         <block type="control" id="?B@5=?PqH6v*6zKv6fcp">
                           <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation>
                           <field name="OID">javascript.0.test.Test_gemischt</field>
                           <field name="WITH_DELAY">FALSE</field>
                           <value name="VALUE">
                             <block type="convert_object2json" id="qbFE#Dr-U2bJkWET{;3/">
                               <field name="PRETTIFY">FALSE</field>
                               <value name="VALUE">
                                 <block type="variables_get" id="f6)^4$,h523yANg6}Xp7">
                                   <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
                                 </block>
                               </value>
                             </block>
                           </value>
                           <next>
                             <block type="debug" id="Xar6oL7+k!M:2n0atyZt">
                               <field name="Severity">warn</field>
                               <value name="TEXT">
                                 <shadow type="text" id="E(2nqnZZxAhV95m0d7U|">
                                   <field name="TEXT">test</field>
                                 </shadow>
                                 <block type="variables_get" id="JVA=ISb(J?rC5aZV)=i?">
                                   <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
                                 </block>
                               </value>
                             </block>
                           </next>
                         </block>
                       </next>
                     </block>
                   </next>
                 </block>
               </next>
             </block>
           </next>
         </block>
       </statement>
     </block>
   </next>
 </block>
 <block type="procedures_defcustomreturn" id="]lQM=r`L^2M}s^@n(USH" x="-988" y="-1638">
   <mutation statements="false">
     <arg name="ObjectID" varid="Fwt*3`3ScyT(qDt?gf(T"></arg>
   </mutation>
   <field name="NAME">Name</field>
   <field name="SCRIPT">bGV0IG15U3RhdGU7CmdldFN0YXRlKE9iamVjdElEKS52YWwgPyBteVN0YXRlPSLimqoiIDogbXlTdGF0ZT0i4pqrIgpsZXQgbmFtZSA9IGdldE9iamVjdChPYmplY3RJRCkuY29tbW9uLm5hbWUuc3Vic3RyaW5nKDEyKTsKbmFtZSA9IG5hbWUucmVwbGFjZSgnU3RhdHVzIG9iZXJlIFBvc2l0aW9uJywgJ29iZW4nKTsKbmFtZSA9IG5hbWUucmVwbGFjZSgnU3RhdHVzIHVudGVyZSBQb3NpdGlvbicsICd1bnRlbicpOwpyZXR1cm4geyAgICAKICAgICJOYW1lIjogbmFtZSwKICAgICJTdGF0dXMiOiBteVN0YXRlCn0=</field>
   <comment pinned="false" h="80" w="160">Beschreibe diese Funktion …</comment>
 </block>
</xml>

quorle

@paul53 :

Soweit so gut, die Ausgabe der Namen Passt nun einwandfrei. Danke für deine Hilfe.

@liv-in-sky :

Wie würde ich jetzt in die Tabellen ein PNG Bild bekommen?
Benutze noch dein Widget, was du hier gepostet hast.
Aber wenn ich im Widget Spalte 1 als Image deklariere, verschwindet der Text.

liv-in-sky

@quorle

poste mal die daten, die jetzt da sind - dann kann ich die importieren und ansehen

quorle

@liv-in-sky

<xml xmlns="https://developers.google.com/blockly/xml">
 <variables>
   <variable id="X^G~Pk/;SH@G?XbLq.{o">ObjectID</variable>
   <variable id="}dJI#n7D?(yn(S7IZetS">Liste</variable>
   <variable id="K@h0-NY5VaI|@t!5/iJh">Wert</variable>
   <variable id="2TXuU=:-J^z#1tz2?m+)">test</variable>
   <variable id="W6/l[G~B{Zwv5)Rz4siZ">anzahl_oben</variable>
   <variable id="Sk[;o=!/U_$I6Wr,/;!b">anzahl_unten</variable>
   <variable id="fe!@@dhB{4wJ~YaxWG%C">i</variable>
 </variables>
 <block type="procedures_defcustomreturn" id="]lQM=r`L^2M}s^@n(USH" x="-1212" y="-1863">
   <mutation statements="false">
     <arg name="ObjectID" varid="X^G~Pk/;SH@G?XbLq.{o"></arg>
   </mutation>
   <field name="NAME">Name</field>
   <field name="SCRIPT">bGV0IG15U3RhdGU7CmdldFN0YXRlKE9iamVjdElEKS52YWwgPyBteVN0YXRlPSLimqoiIDogbXlTdGF0ZT0i4pqrIgpsZXQgbmFtZSA9IGdldE9iamVjdChPYmplY3RJRCkuY29tbW9uLm5hbWUuc3Vic3RyaW5nKDEyKTsKbmFtZSA9IG5hbWUucmVwbGFjZSgnU3RhdHVzIG9iZXJlIFBvc2l0aW9uJywgJ29iZW4nKTsKbmFtZSA9IG5hbWUucmVwbGFjZSgnU3RhdHVzIHVudGVyZSBQb3NpdGlvbicsICd1bnRlbicpOwpyZXR1cm4geyAgICAKICAgICJOYW1lIjogbmFtZSwKICAgICJTdGF0dXMiOiBteVN0YXRlCn0=</field>
   <comment pinned="false" h="80" w="160">Beschreibe diese Funktion …</comment>
 </block>
 <block type="procedures_defcustomreturn" id="!t;U0AgoNU@W*^{W;)1~" x="-1288" y="-1812">
   <mutation statements="false">
     <arg name="Liste" varid="}dJI#n7D?(yn(S7IZetS"></arg>
     <arg name="Wert" varid="K@h0-NY5VaI|@t!5/iJh"></arg>
   </mutation>
   <field name="NAME">Multisort</field>
   <field name="SCRIPT">dmFyIFdlcnQgPSBXZXJ0IC0gMTsgCkxpc3RlLnNvcnQoZnVuY3Rpb24oYSwgYil7CiAgICByZXR1cm4gYltXZXJ0XSAtIGFbV2VydF07Cn0pOwpyZXR1cm4gTGlzdGU7</field>
   <comment pinned="false" h="80" w="160">Beschreibe diese Funktion …</comment>
 </block>
 <block type="variables_set" id="M*e-%li=rNRAKW!{S*Fi" disabled="true" x="-1287" y="-1761">
   <field name="VAR" id="2TXuU=:-J^z#1tz2?m+)">test</field>
   <value name="VALUE">
     <block type="convert_json2object" id="HodxuAjF0Dakr,,xDdpw">
       <value name="VALUE">
         <block type="text" id="s=LJUvclbq%Wb6B;E/^k">
           <field name="TEXT">[["WC Status untere Position",false],["WC oben",true],["Schlafzimmer Fenster Status untere Position",false],["Schlafzimmer Fenster oben",true],["Schlafzimmer Balkontüre Status untere Position",false],["Schlafzimmer Balkontüre oben",true],["Kinderzimmer Lea Status untere Position",false],["Kinderzimmer Lea oben",true],["Kinderzimmer Antonia Status untere Position",false],["Kinderzimmer Antonia oben",true],["Gästezimmer Status untere Position",true],["Gästezimmer oben",false],["Jonas Fenster Status untere Position",false],["Jonas Fenster oben",true],["Wohnzimmer Fenster Status untere Position",false],["Wohnzimmer Fenster oben",true],["Wohnzimmer Balkontüre Status untere Position",false],["Wohnzimmer Balkontüre oben",true],["WC Fenster Status untere Position",false],["WC Fenster oben",true],["Küche Fenster Status untere Position",false],["Küche Fenster oben",true]]</field>
         </block>
       </value>
     </block>
   </value>
   <next>
     <block type="schedule" id="Cqz)^1L5B-*_#wudd;?i">
       <field name="SCHEDULE">*/20 * * * * *</field>
       <statement name="STATEMENT">
         <block type="variables_set" id="sWqJxa.MyY?*y-S}mHPz">
           <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
           <value name="VALUE">
             <block type="lists_create_with" id="s1KG8o;:gtQ6DjJt@w9I">
               <mutation items="0"></mutation>
             </block>
           </value>
           <next>
             <block type="variables_set" id="R6exgi+-F7xoKVW/[NE.">
               <field name="VAR" id="W6/l[G~B{Zwv5)Rz4siZ">anzahl_oben</field>
               <value name="VALUE">
                 <block type="math_number" id="AHHG~c/mltPLQ?]Ik;5M">
                   <field name="NUM">0</field>
                 </block>
               </value>
               <next>
                 <block type="variables_set" id="**}`+OgV6}BW5TBMd{`s">
                   <field name="VAR" id="Sk[;o=!/U_$I6Wr,/;!b">anzahl_unten</field>
                   <value name="VALUE">
                     <block type="math_number" id="u(R`,V@+GYc(yI=W0rOU">
                       <field name="NUM">0</field>
                     </block>
                   </value>
                   <next>
                     <block type="controls_forEach" id="~PaFX`X@5n{TM9K^{Jw6">
                       <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                       <value name="LIST">
                         <block type="selector" id="xQ^Q5{h5V@5PLI+YO@i.">
                           <field name="TEXT">*_Position(functions=blinds)</field>
                         </block>
                       </value>
                       <statement name="DO">
                         <block type="debug" id="XZDv+4g$1.=ljXu_70B*" disabled="true">
                           <field name="Severity">warn</field>
                           <value name="TEXT">
                             <shadow type="text">
                               <field name="TEXT">test</field>
                             </shadow>
                             <block type="variables_get" id="WiV$3M9_AvyO[2zGP3_e">
                               <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                             </block>
                           </value>
                           <next>
                             <block type="controls_if" id="BpYF0w{plR^$Bj;f$G-X">
                               <mutation elseif="1"></mutation>
                               <value name="IF0">
                                 <block type="logic_compare" id=":U;pkPjDX!X*x`]J^[=f">
                                   <field name="OP">GT</field>
                                   <value name="A">
                                     <block type="text_indexOf" id="dQ?$f$~34KAwRQzHZy2v">
                                       <field name="END">FIRST</field>
                                       <value name="VALUE">
                                         <block type="variables_get" id="YN=/IOiNU1e/z47W_hYO">
                                           <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                         </block>
                                       </value>
                                       <value name="FIND">
                                         <shadow type="text" id="YJ_ZaIlitzIz0lbSIy]Z">
                                           <field name="TEXT">obere</field>
                                         </shadow>
                                       </value>
                                     </block>
                                   </value>
                                   <value name="B">
                                     <block type="math_number" id="(4uegeXx!R!5`x./Zrpy">
                                       <field name="NUM">0</field>
                                     </block>
                                   </value>
                                 </block>
                               </value>
                               <statement name="DO0">
                                 <block type="math_change" id=";nI|WSdj!-!_]9^hXce=">
                                   <field name="VAR" id="W6/l[G~B{Zwv5)Rz4siZ">anzahl_oben</field>
                                   <value name="DELTA">
                                     <shadow type="math_number" id="7NsDd4.5wRJiN$ohzcPz">
                                       <field name="NUM">1</field>
                                     </shadow>
                                   </value>
                                   <next>
                                     <block type="lists_setIndex" id="V%X2]!(FWN#b!Icp,vEn">
                                       <mutation at="true"></mutation>
                                       <field name="MODE">INSERT</field>
                                       <field name="WHERE">FROM_START</field>
                                       <value name="LIST">
                                         <block type="variables_get" id="d@?Y!wCwVm2J;5#}l@|s">
                                           <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
                                         </block>
                                       </value>
                                       <value name="AT">
                                         <block type="variables_get" id="I{J?cUEic):/$hl^3n{K">
                                           <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                         </block>
                                       </value>
                                       <value name="TO">
                                         <block type="procedures_callcustomreturn" id="Qf=s6+J.KB`I0omt2dx-" inline="true">
                                           <mutation name="Name">
                                             <arg name="ObjectID"></arg>
                                           </mutation>
                                           <value name="ARG0">
                                             <block type="variables_get" id="7`$xI^f!0)3kG%TM66sA">
                                               <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                             </block>
                                           </value>
                                         </block>
                                       </value>
                                     </block>
                                   </next>
                                 </block>
                               </statement>
                               <value name="IF1">
                                 <block type="logic_compare" id=",#NtYtMgV}/:2E1_hNrG">
                                   <field name="OP">GT</field>
                                   <value name="A">
                                     <block type="text_indexOf" id="Yg}H-~{a7x8)+qu:9M|/">
                                       <field name="END">FIRST</field>
                                       <value name="VALUE">
                                         <block type="variables_get" id="8;*NmuJL+=2ZjdGLV@w*">
                                           <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                         </block>
                                       </value>
                                       <value name="FIND">
                                         <shadow type="text" id="NE#zvIT-6LZjV3/;?~mp">
                                           <field name="TEXT">untere</field>
                                         </shadow>
                                       </value>
                                     </block>
                                   </value>
                                   <value name="B">
                                     <block type="math_number" id="J(GT5p9jH?jE][E#[[@;">
                                       <field name="NUM">0</field>
                                     </block>
                                   </value>
                                 </block>
                               </value>
                               <statement name="DO1">
                                 <block type="math_change" id=":_uor[5yVl8xBU+`cMV;">
                                   <field name="VAR" id="Sk[;o=!/U_$I6Wr,/;!b">anzahl_unten</field>
                                   <value name="DELTA">
                                     <shadow type="math_number" id="ieNW@ocv}L*#oj8$X~P1">
                                       <field name="NUM">1</field>
                                     </shadow>
                                   </value>
                                   <next>
                                     <block type="lists_setIndex" id="3`60`J~EA:*j}OOf+Z*c">
                                       <mutation at="true"></mutation>
                                       <field name="MODE">INSERT</field>
                                       <field name="WHERE">FROM_START</field>
                                       <value name="LIST">
                                         <block type="variables_get" id="Q|]yh,v=L+mdd_rKMQdY">
                                           <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
                                         </block>
                                       </value>
                                       <value name="AT">
                                         <block type="variables_get" id="iyFeezsq|O~{G,#T^e=-">
                                           <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                         </block>
                                       </value>
                                       <value name="TO">
                                         <block type="procedures_callcustomreturn" id="Z_doi2a.Vs634-ZCc8|6" inline="true">
                                           <mutation name="Name">
                                             <arg name="ObjectID"></arg>
                                           </mutation>
                                           <value name="ARG0">
                                             <block type="variables_get" id="fA)(tvzda:,Du0s;bs-#">
                                               <field name="VAR" id="fe!@@dhB{4wJ~YaxWG%C">i</field>
                                             </block>
                                           </value>
                                         </block>
                                       </value>
                                     </block>
                                   </next>
                                 </block>
                               </statement>
                             </block>
                           </next>
                         </block>
                       </statement>
                       <next>
                         <block type="control" id="?B@5=?PqH6v*6zKv6fcp">
                           <mutation xmlns="http://www.w3.org/1999/xhtml" delay_input="false"></mutation>
                           <field name="OID">javascript.0.test.Test_gemischt</field>
                           <field name="WITH_DELAY">FALSE</field>
                           <value name="VALUE">
                             <block type="convert_object2json" id="qbFE#Dr-U2bJkWET{;3/">
                               <field name="PRETTIFY">TRUE</field>
                               <value name="VALUE">
                                 <block type="variables_get" id="f6)^4$,h523yANg6}Xp7">
                                   <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
                                 </block>
                               </value>
                             </block>
                           </value>
                           <next>
                             <block type="debug" id="Xar6oL7+k!M:2n0atyZt">
                               <field name="Severity">warn</field>
                               <value name="TEXT">
                                 <shadow type="text" id="E(2nqnZZxAhV95m0d7U|">
                                   <field name="TEXT">test</field>
                                 </shadow>
                                 <block type="variables_get" id="JVA=ISb(J?rC5aZV)=i?">
                                   <field name="VAR" id="}dJI#n7D?(yn(S7IZetS">Liste</field>
                                 </block>
                               </value>
                             </block>
                           </next>
                         </block>
                       </next>
                     </block>
                   </next>
                 </block>
               </next>
             </block>
           </next>
         </block>
       </statement>
     </block>
   </next>
 </block>
</xml>

Ausgabe in den State:

[{"tpl":"i-vis-jsontable","data":{"g_fixed":false,"g_visibility":false,"g_css_font_text":true,"g_css_background":false,"g_css_shadow_padding":false,"g_css_border":false,"g_gestures":false,"g_signals":true,"g_last_change":false,"visibility-cond":"==","visibility-val":1,"visibility-groups-action":"hide","iTblRowLimit":"100","iTableRefreshRate":"0","iColCount":"3","iColShow1":"true","iTblCellFormat1":"normal","iTblCellImageSize1":"59","iTblTextAlign1":"left","iOpacityAll":"1","iTblRowEvenColor":"#333333","iTblRowUnevenColor":"#38739f","iTblHeaderColor":"#333333","iRowSpacing":"3.1","iTblRowEvenTextColor":"#ffffff","iTblRowUnevenTextColor":"#ffffff","iTblHeaderTextColor":"#ffffff","iBorderSize":"2","iBorderStyleLeft":"none","iBorderStyleRight":"none","iBorderStyleUp":"none","iBorderStyleDown":"none","iBorderColor":"#38739f","signals-cond-0":"==","signals-val-0":true,"signals-icon-0":"/vis/signals/lowbattery.png","signals-icon-size-0":0,"signals-blink-0":false,"signals-horz-0":0,"signals-vert-0":0,"signals-hide-edit-0":false,"signals-cond-1":"==","signals-val-1":true,"signals-icon-1":"/vis/signals/lowbattery.png","signals-icon-size-1":0,"signals-blink-1":false,"signals-horz-1":0,"signals-vert-1":0,"signals-hide-edit-1":false,"signals-cond-2":"==","signals-val-2":true,"signals-icon-2":"/vis/signals/lowbattery.png","signals-icon-size-2":0,"signals-blink-2":false,"signals-horz-2":0,"signals-vert-2":0,"signals-hide-edit-2":false,"lc-type":"last-change","lc-is-interval":true,"lc-is-moment":false,"lc-format":"","lc-position-vert":"top","lc-position-horz":"right","lc-offset-vert":0,"lc-offset-horz":0,"lc-font-size":"12px","lc-font-family":"","lc-font-style":"","lc-bkg-color":"","lc-color":"","lc-border-width":"0","lc-border-style":"","lc-border-color":"","lc-border-radius":10,"lc-zindex":0,"oid":"javascript.0.test.Test_gemischt","iHorScroll":true,"iColShow2":"true","iTblCellFormat2":"normal","iTblCellImageSize2":"200","iTblTextAlign2":"center","iBorderRemoveDouble":false,"iColShow3":"true","iTblCellFormat3":"image","iTblCellImageSize3":"200","iTblTextAlign3":"right","iColWidth3":"50","iColWidth2":"50","iColWidth1":"50","iTblCellBooleanCheckbox1":"false","iTblCellBooleanColorFalse1":"#ff0000","iTblCellBooleanColorTrue1":"#00ff00","iTblCellNumberDecimals1":"2","iTblCellNumberDecimalSeperator1":".","iTblCellNumberThousandSeperator1":",","iTblCellBooleanCheckbox2":"false","iTblCellBooleanColorFalse2":"#ff0000","iTblCellBooleanColorTrue2":"#00ff00","iTblCellNumberDecimals2":"2","iTblCellNumberDecimalSeperator2":".","iTblCellNumberThousandSeperator2":",","iTblCellBooleanCheckbox3":false,"iTblCellBooleanColorFalse3":"#ff0000","iTblCellBooleanColorTrue3":"#00ff00","iTblCellNumberDecimals3":"2","iTblCellNumberDecimalSeperator3":".","iTblCellNumberThousandSeperator3":",","iTblCellPlaceholder1":"","iColAttr2":"Status","iColAttr3":"","iColAttr1":"Name","iColShow4":true,"iTblCellFormat4":"normal","iTblCellImageSize4":"200","iTblCellBooleanCheckbox4":"false","iTblCellBooleanColorFalse4":"#ff0000","iTblCellBooleanColorTrue4":"#00ff00","iTblCellNumberDecimals4":"2","iTblCellNumberDecimalSeperator4":".","iTblCellNumberThousandSeperator4":",","iTblTextAlign4":"left","iTblShowHead":true,"iVertScroll":true,"iTblCellPlaceholder3":"","iColName3":"","iColName2":"","iTblCellPlaceholder2":""},"style":{"left":"463px","top":"27px","width":"948px","height":"343px","font-size":"large","overflow-y":"scroll"},"widgetSet":"vis-inventwo"}]

liv-in-sky

@quorle di daten bitte aus dem log rauskopieren und posten

es sind aber keine bilder zu sehen - der schwarze und weiße punkt ist ein emiji und daher ein text

liv-in-sky

@quorle

was sollen die bilder eigentlich anzeigen bzw wie aussehen ?

quorle

@liv-in-sky

Ja die schwarzen Punkte sind Emojis und werden in der JS-Funktion Name gebildet ( eingefügt ).
Es sollten Bilder ( png ) sein, die man in der VIS dann einbinden kann. Die Bilder stammen von Inventwo. Einmal "Rollo offen", wenn der Status Rollo offen ist und ein geschlossen.

17.1.2021, 16:04:00.005	[warn ]: javascript.0 (3043) script.js.common.TEST-Scripte.Skript_2: [{'Name':'WC unten','Status':'⚫'},{'Name':'WC oben','Status':'⚪'},{'Name':'Schlafzimmer Fenster unten','Status':'⚫'},{'Name':'Schlafzimmer Fenster oben','Status':'⚪'},{'Name':'Schlafzimmer Balkontüre unten','Status':'⚫'},{'Name':'Schlafzimmer Balkontüre oben','Status':'⚪'},{'Name':'Kinderzimmer Lea unten','Status':'⚫'},{'Name':'Kinderzimmer Lea oben','Status':'⚪'},{'Name':'Kinderzimmer Antonia unten','Status':'⚫'},{'Name':'Kinderzimmer Antonia oben','Status':'⚪'},{'Name':'Gästezimmer unten','Status':'⚫'},{'Name':'Gästezimmer oben','Status':'⚪'},{'Name':'Jonas Fenster unten','Status':'⚫'},{'Name':'Jonas Fenster oben','Status':'⚪'},{'Name':'Wohnzimmer Fenster unten','Status':'⚫'},{'Name':'Wohnzimmer Fenster oben','Status':'⚪'},{'Name':'Wohnzimmer Balkontüre unten','Status':'⚫'},{'Name':'Wohnzimmer Balkontüre oben','Status':'⚪'},{'Name':'WC Fenster unten','Status':'⚫'},{'Name':'WC Fenster oben','Status':'⚪'},{'Name':'Küche Fenster unten','Status':'⚫'},{'Name':'Küche Fenster oben','Status':'⚪'}]

liv-in-sky

@quorle

hier werden die emojis gesetzt - ich nehme an, hier willst du bilder haben

Image 1.png

wenn du die bilder in der vis im darin enthaltenen dateimanager sehen kannst,

beispiel mit bild:

Image 2.png

Image 4.png

quorle

@liv-in-sky

Habe das einmal eingefügt,

jedoch kommt bei mir dann nur der Link:

liv-in-sky

@quorle

hast du im widget die 2te spalte auf image umgestellt ?

quorle

@liv-in-sky

Ok, danke dir, manchmal sind es wirklich die Kleinigkeiten, an die man nicht denkt.

So, große Frage:

Kann man das ganze eventuell so gestalten, dass alle "oben" zusammengefasst und alle "unten" zusammengefasst werden? Und dann nur ein Bild für "oben" und "unten" in die Liste eingetragen wird?

liv-in-sky

@quorle

kann man durch sotieren der daten bekommen - meinst du in die richtung

Image 2.png

3 änderungen im teil-script , indem wir die liste schreiben:

Image 3.png

neues teilscript sortieren - kommt vor schreiben des datenpunktes:

Image 5.png

import sortieren funktions-baustein:

<block xmlns="https://developers.google.com/blockly/xml" type="procedures_defcustomnoreturn" id="sAEni8c8vYD]#@?(D/A9" x="-812.4906005859375" y="-1062.3208312988281">
 <mutation statements="false"></mutation>
 <field name="NAME">sortieren</field>
 <field name="SCRIPT">DQoNCi8vU29ydGllcnVuZyBOYW1lDQogICAgIExpc3RlLnNvcnQoZnVuY3Rpb24gKGFscGhhLCBiZXRhKSB7DQogICAgICAgICAgICAgaWYgKGFscGhhLk5hbWUgPiBiZXRhLk5hbWUpDQogICAgICAgICAgICAgICAgcmV0dXJuIDE7DQogICAgICAgICAgICAgaWYgKGJldGEuTmFtZSA+IGFscGhhLk5hbWUpDQogICAgICAgICAgICAgICAgcmV0dXJuIC0xOw0KICAgICAgICAgICAgIHJldHVybiAwOw0KICAgICAgICAgICAgfSk7ICANCiAvL1NvcnRpZXJ1bmcgb2JlbiB1bnRlbiAgDQogICBMaXN0ZS5zb3J0KGZ1bmN0aW9uIChhbHBoYSwgYmV0YSkgew0KICAgICAgICAgICAgIGlmIChhbHBoYS5zb3J0aWVydW5nID4gYmV0YS5zb3J0aWVydW5nKQ0KICAgICAgICAgICAgICAgIHJldHVybiAxOw0KICAgICAgICAgICAgIGlmIChiZXRhLnNvcnRpZXJ1bmcgPiBhbHBoYS5zb3J0aWVydW5nKQ0KICAgICAgICAgICAgICAgIHJldHVybiAtMTsNCiAgICAgICAgICAgICByZXR1cm4gMDsNCiAgICAgICAgICAgIH0pOyANCiAgLy9Mw7ZzY2hlbiDDvGJlcmZsw7xzc2lnZXIgYmlsZGVyICANCiAgICBsZXQgaGVscGVyPSIiICAgICAgICANCiAgICBmb3IobGV0IGRkPTA7ZGQ8TGlzdGUubGVuZ3RoO2RkKyspIHsNCiAgICAgIGlmIChMaXN0ZVtkZF0uc29ydGllcnVuZyAhPSBoZWxwZXIpICB7aGVscGVyPUxpc3RlW2RkXS5zb3J0aWVydW5nIH0gZWxzZSB7TGlzdGVbZGRdLlN0YXR1cz0iIn0NCiAgICAgICAgDQogICAgfSAgICAgICAgDQogICAgDQogICAgbG9nKEpTT04uc3RyaW5naWZ5KExpc3RlKSk=</field>
 <comment pinned="false" h="80" w="160">Beschreibe diese Funktion …</comment>
</block>

quorle

@liv-in-sky

Ja, so in der Art. Theoretisch sollte es so aussehen ( die Liste sollte mit einem PopUp in der VIS aufgehen.

liv-in-sky

@quorle

warum baust du die anleitung nicht nach ? da scheint doch alles drin zu sein

es gibt auch noch ein script für offene fenster im forum

sorry - eigentlich habe ich nicht vor, dass alles nochmal nachzubauen - ich nutze es eh nicht - ich habe dir bis zur liste geholfen - mir wird das jetzt etwas zu viel.

vielleicht findet sich jmd anders

Community Forum

NEWS

[Suche] Javascript das eine Tabelle im JSON ausgibt

Support us

848

32.4k

81.5k

1.3m