Topic: Script editor SQL multiline queries
Is there a way to write multiline SQL queries within the script editor? It becomes easily difficult to follow a pretty long query.
I would like to be able to write
'SELECT columns
FROM table
JOIN table2 on tableid=table2id
WHERE condition='my condition'
AND second_condition='my second condition'
AND third condition="'+fieldObject.txt+'";'
ETC...