13.2.0 — iDempiere 13

SQL Query Enhanced Form for iDempiere 13 (Java 17)

What's new

• The statement history is stored in its own table SOP_SQLQueryHistory (user, statement, records, elapsed time) instead of being read from AD_Issue, which is usually cleaned or truncated in maintenance tasks. Thanks to Carlos Ruiz for the suggestion.
• The table is created automatically by the plug-in's 2Pack (META-INF/2Pack_1.0.0.zip, EntityType SOP) the first time the bundle starts.
• Statements are still logged in AD_Issue like the core form (SysConfig FORM_SQL_QUERY_LOG_ISSUE), but the history no longer depends on it.

Upgrade notes

• The history logged in AD_Issue by 13.1.0 is not imported: it starts empty.
• The optional index ad_issue_formuser_idx of 13.1.0 is no longer needed: DROP INDEX ad_issue_formuser_idx;

Install

Download com.soropeza.sqlquery-13.2.0.jar and install it from the Felix web console (/osgi/system/console/bundles, Install/Update..., Start Bundle) or the OSGi console. See the README and the CHANGELOG.

12.2.0 — iDempiere 12

SQL Query Enhanced Form for iDempiere 12 (Java 17)

What's new

• The statement history is stored in its own table SOP_SQLQueryHistory (user, statement, records, elapsed time) instead of being read from AD_Issue, which is usually cleaned or truncated in maintenance tasks. Thanks to Carlos Ruiz for the suggestion.
• The table is created automatically by the plug-in's 2Pack (META-INF/2Pack_1.0.0.zip, EntityType SOP) the first time the bundle starts.
• Statements are still logged in AD_Issue like the core form (SysConfig FORM_SQL_QUERY_LOG_ISSUE), but the history no longer depends on it.

Upgrade notes

• The history logged in AD_Issue by 12.1.0 is not imported: it starts empty.
• The optional index ad_issue_formuser_idx of 12.1.0 is no longer needed: DROP INDEX ad_issue_formuser_idx;

Install

Download com.soropeza.sqlquery-12.2.0.jar and install it from the Felix web console (/osgi/system/console/bundles, Install/Update..., Start Bundle) or the OSGi console. See the README and the CHANGELOG.

10.2.0 — iDempiere 10

SQL Query Enhanced Form for iDempiere 10 (Java 11)

What's new

• The statement history is stored in its own table SOP_SQLQueryHistory (user, statement, records, elapsed time) instead of being read from AD_Issue, which is usually cleaned or truncated in maintenance tasks. Thanks to Carlos Ruiz for the suggestion.
• The table is created automatically by the plug-in's 2Pack (META-INF/2Pack_1.0.0.zip, EntityType SOP) the first time the bundle starts.
• Statements are still logged in AD_Issue like the core form (SysConfig FORM_SQL_QUERY_LOG_ISSUE), but the history no longer depends on it.
• The 2Pack is the same as in 13.2.0, except that SOP_SQLQueryHistory_UU uses the String reference (the UUID reference does not exist in iDempiere 10).

Upgrade notes

• The history logged in AD_Issue by 10.1.0 is not imported: it starts empty.
• The optional index ad_issue_formuser_idx of 10.1.0 is no longer needed: DROP INDEX ad_issue_formuser_idx;

Install

Download com.soropeza.sqlquery-10.2.0.jar and install it from the Felix web console (/osgi/system/console/bundles, Install/Update..., Start Bundle) or the OSGi console. See the README and the CHANGELOG.

13.1.0 — iDempiere 13

SQL Query Enhanced Form for iDempiere 13 (Java 17)

What's new

• SQL code editor with syntax highlighting and line numbers (CodeMirror 5.65.16, bundled, no CDN). Can be disabled with SysConfig SQLQUERY_ENHANCED_CODE_EDITOR=N.
• Run only the selected text (Ctrl+Enter or the execute button).
• Tab / Shift+Tab indent and unindent.
• Statement history persisted across sessions (read from AD_Issue), with time and row count.
• NULL values shown in grey italics; record count and duration in the toolbar.
• "?" button with the keyboard shortcuts.
• Optional index ad_issue_formuser_idx for the history lookup (scripts in migration/).

Fixes

• Selecting a statement in the history combo did nothing.
• Statements ending with ; were rejected as multiple commands.
• -- line comments covered the whole statement.
• Allowed keywords are matched as whole words.

Installation

Download com.soropeza.sqlquery-13.1.0.jar and install it from the Felix web console (/osgi/system/console/bundles) or the OSGi console (install file:/path/com.soropeza.sqlquery-13.1.0.jar). See the README.

For other iDempiere versions: v12.1.0 (iDempiere 12), v10.1.0 (iDempiere 10).

12.1.0 — iDempiere 12

SQL Query Enhanced Form for iDempiere 12 (Java 17)

What's new

Port of 13.1.0 to iDempiere 12, same features:

• SQL code editor with syntax highlighting and line numbers (CodeMirror 5.65.16, bundled, no CDN). Can be disabled with SysConfig SQLQUERY_ENHANCED_CODE_EDITOR=N.
• Run only the selected text (Ctrl+Enter or the execute button).
• Tab / Shift+Tab indent and unindent.
• Statement history persisted across sessions (read from AD_Issue), with time and row count.
• NULL values shown in grey italics; record count and duration in the toolbar.
• "?" button with the keyboard shortcuts.
• Optional index ad_issue_formuser_idx for the history lookup (scripts in migration/).

Fixes

• Selecting a statement in the history combo did nothing.
• Statements ending with ; were rejected as multiple commands.
• -- line comments covered the whole statement.
• Allowed keywords are matched as whole words.

Installation

Download com.soropeza.sqlquery-12.1.0.jar and install it from the Felix web console (/osgi/system/console/bundles) or the OSGi console (install file:/path/com.soropeza.sqlquery-12.1.0.jar). See the README.

For other iDempiere versions: v13.1.0 (iDempiere 13), v10.1.0 (iDempiere 10).

10.1.0 — iDempiere 10

SQL Query Enhanced Form for iDempiere 10 (Java 11)

What's new

Port of 13.1.0 to iDempiere 10, same features:

• SQL code editor with syntax highlighting and line numbers (CodeMirror 5.65.16, bundled, no CDN). Can be disabled with SysConfig SQLQUERY_ENHANCED_CODE_EDITOR=N.
• Run only the selected text (Ctrl+Enter or the execute button).
• Tab / Shift+Tab indent and unindent.
• Statement history persisted across sessions (read from AD_Issue), with time and row count.
• NULL values shown in grey italics; record count and duration in the toolbar.
• "?" button with the keyboard shortcuts.
• Optional index ad_issue_formuser_idx for the history lookup (scripts in migration/).

Fixes

• Selecting a statement in the history combo did nothing.
• Statements ending with ; were rejected as multiple commands.
• -- line comments covered the whole statement.
• Allowed keywords are matched as whole words.

Installation

Download com.soropeza.sqlquery-10.1.0.jar and install it from the Felix web console (/osgi/system/console/bundles) or the OSGi console (install file:/path/com.soropeza.sqlquery-10.1.0.jar). See the README.

For other iDempiere versions: v13.1.0 (iDempiere 13), v12.1.0 (iDempiere 12).