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).