# verine_info

autor_name: Köhle&Hatzesberger
informationen:
Beinhaltet alle Vokabeln aus Blue Line 5<br><div class="text-center"><button id="btnGotoExerciseTab" class=" btn btn-outline-success " data-toggle="tooltip" data-placement="top">zur Aufgabe</button></div>


# verine_forms

form_data:
{"title":"Wortsuche engl","id":1,"parameters":[{"name":"param01","position":0,"label":"englisch","value":""}],"query":"SELECT deutsch, englisch FROM vokabeln WHERE englisch LIKE 'param01%'","queryTextarea":"","queryHTML":"<span class=\"codeline\"><span class=\"codeElement_1 btnSelect synSQL sqlSelect start parent sqlIdentifier inputFields\" data-sql-element=\"SELECT\">SELECT<span class=\"codeElement_2 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_3 selColumn synColumns vokabeln inputField sqlIdentifier root\" data-sql-element=\"SELECT_SELECT\" data-next-element=\"7\" data-element-group=\"undefined\">deutsch</span><span class=\"codeElement_15 leerzeichen\" data-goto-element=\"parent\">, </span><span class=\"codeElement_16 selColumn synColumns vokabeln inputField sqlIdentifier extended\" data-sql-element=\"SELECT_SELECT\" data-next-element=\"undefined\" data-element-group=\"undefined\">englisch</span><span class=\"codeElement_4 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_5\" data-goto-element=\"1\">FROM</span><span class=\"codeElement_6 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_7 selTable synTables inputField sqlIdentifier root\" data-sql-element=\"SELECT_FROM\" data-next-element=\"3\" data-element-group=\"undefined\">vokabeln</span></span></span><span class=\"codeline\"><span class=\"codeElement_8 btnWhere synSQL sqlWhere parent sqlIdentifier inputFields\" data-sql-element=\"WHERE\">WHERE<span class=\"codeElement_9 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_10 selColumn synColumns vokabeln inputField sqlIdentifier root\" data-sql-element=\"WHERE_1\" data-next-element=\"12\" data-element-group=\"undefined\">englisch</span><span class=\"codeElement_11 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_12 selOperators synOperators sqlWhere inputField sqlIdentifier root\" data-sql-element=\"WHERE_2\" data-next-element=\"14\" data-element-group=\"undefined\">LIKE</span><span class=\"codeElement_13 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_14 inputField root sqlIdentifier  input inputValue synValues\" data-sql-element=\"WHERE_3\" data-next-element=\"10\">'param01%'</span></span></span>","queryHTMLlastId":17,"isCodeSwitched":false}


form_data:
{"title":"Wortsuche dt","id":2,"parameters":[{"name":"param01","position":0,"label":"deutsch","value":"a"}],"query":"SELECT deutsch, englisch FROM vokabeln WHERE deutsch LIKE 'param01%'","queryTextarea":"","queryHTML":"<span class=\"codeline\"><span class=\"codeElement_1 btnSelect synSQL sqlSelect start parent sqlIdentifier inputFields \" data-sql-element=\"SELECT\">SELECT<span class=\"codeElement_2 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_3 selColumn synColumns vokabeln inputField sqlIdentifier root\" data-sql-element=\"SELECT_SELECT\" data-next-element=\"7\" data-element-group=\"undefined\">deutsch</span><span class=\"codeElement_15 leerzeichen\" data-goto-element=\"parent\">, </span><span class=\"codeElement_16 selColumn synColumns vokabeln inputField sqlIdentifier extended\" data-sql-element=\"SELECT_SELECT\" data-next-element=\"undefined\" data-element-group=\"undefined\">englisch</span><span class=\"codeElement_4 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_5\" data-goto-element=\"1\">FROM</span><span class=\"codeElement_6 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_7 selTable synTables inputField sqlIdentifier root\" data-sql-element=\"SELECT_FROM\" data-next-element=\"3\" data-element-group=\"undefined\">vokabeln</span></span></span><span class=\"codeline\"><span class=\"codeElement_8 btnWhere synSQL sqlWhere parent sqlIdentifier inputFields\" data-sql-element=\"WHERE\">WHERE<span class=\"codeElement_9 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_10 selColumn synColumns vokabeln inputField sqlIdentifier root\" data-sql-element=\"WHERE_1\" data-next-element=\"12\" data-element-group=\"undefined\">deutsch</span><span class=\"codeElement_11 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_12 selOperators synOperators sqlWhere inputField sqlIdentifier root\" data-sql-element=\"WHERE_2\" data-next-element=\"14\" data-element-group=\"undefined\">LIKE</span><span class=\"codeElement_13 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_14 inputField root sqlIdentifier input inputValue synValues\" data-sql-element=\"WHERE_3\" data-next-element=\"10\">'param01%'</span></span></span>","queryHTMLlastId":17,"isCodeSwitched":false}


form_data:
{"title":"Unit","id":3,"parameters":[{"name":"param01","position":0,"label":"unit","value":"3"}],"query":"SELECT englisch, deutsch FROM vokabeln WHERE unit LIKE '%param01%'","queryTextarea":"","queryHTML":"<span class=\"codeline\"><span class=\"codeElement_1 btnSelect synSQL sqlSelect start parent sqlIdentifier inputFields\" data-sql-element=\"SELECT\">SELECT<span class=\"codeElement_2 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_3 selColumn synColumns vokabeln inputField sqlIdentifier root\" data-sql-element=\"SELECT_SELECT\" data-next-element=\"7\" data-element-group=\"undefined\">englisch</span><span class=\"codeElement_15 leerzeichen\" data-goto-element=\"parent\">, </span><span class=\"codeElement_16 selColumn synColumns vokabeln inputField sqlIdentifier extended\" data-sql-element=\"SELECT_SELECT\" data-next-element=\"undefined\" data-element-group=\"undefined\">deutsch</span><span class=\"codeElement_4 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_5\" data-goto-element=\"1\">FROM</span><span class=\"codeElement_6 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_7 selTable synTables inputField sqlIdentifier root\" data-sql-element=\"SELECT_FROM\" data-next-element=\"3\" data-element-group=\"undefined\">vokabeln</span></span></span><span class=\"codeline\"><span class=\"codeElement_8 btnWhere synSQL sqlWhere parent sqlIdentifier inputFields\" data-sql-element=\"WHERE\">WHERE<span class=\"codeElement_9 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_10 selColumn synColumns vokabeln inputField sqlIdentifier root\" data-sql-element=\"WHERE_1\" data-next-element=\"12\" data-element-group=\"undefined\">unit</span><span class=\"codeElement_11 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_12 selOperators synOperators sqlWhere inputField sqlIdentifier root\" data-sql-element=\"WHERE_2\" data-next-element=\"14\" data-element-group=\"undefined\">LIKE</span><span class=\"codeElement_13 leerzeichen\" data-goto-element=\"parent\">&nbsp;</span><span class=\"codeElement_14 vokabeln inputField sqlIdentifier root input inputValue synValues \" data-sql-element=\"WHERE_3\" data-next-element=\"10\" data-element-group=\"undefined\">'%param01%'</span></span></span>","queryHTMLlastId":34,"isCodeSwitched":false,"description":"Vokabeln einer Unit auflisten"}


