https://wiki.idempiere.org/w-en/index.php?action=history&feed=atom&title=SQL_Convention 2026-10-01T10:03:08Z Revision history for this page on the wiki MediaWiki 1.35.2 https://wiki.idempiere.org/w-en/index.php?title=SQL_Convention&diff=21854&oldid=prev 2023-12-06T17:44:25Z

<p>Note about convention of sql to pass parse</p> <p><b>New page</b></p><div>SQL use on idempiere need to follow some strict rule to pass internal parse [https://mattermost.idempiere.org/idempiere/pl/pjdwg9kwsfrwxqrg5nnguwk8ny sql parse discuss on mattermost]<br /> <br /> sql can come from somewhere as virtual column,...<br /> <br /> ==== 1. ON clause need to input condition on &quot;()&quot; ====<br /> FROM tabel1 tb1 JOIN table2 tb2 ON tb1.column1 = tb2.column1<br /> then &quot;tb1.column1 = tb2.column1&quot; need to inside &quot;()&quot;<br /> <br /> reference bellow code on AccessSqlParser.getTableInfo<br /> indexClose = from.lastIndexOf(')', indexNextOn);<br /> <br /> ==== 2. Keyword should use uppercase ====<br /> ==== 3. no space between &quot;(&quot; and keyword ====<br /> Select column1, ( Select column2 FROM subTb stb) AS cl2 FROM mainTb<br /> reference bellow code on AccessSqlParser.getSubSQL<br /> index = sql.indexOf(&quot;(SELECT &quot;, 7);</div>

Hieplq