Skip to content

12.2.0 — iDempiere 12

Choose a tag to compare

View all tags
@sergioropeza sergioropeza released this 13 Oct 22:34
· 4 commits to 13.0 since this release
v12.2.0
6fac64c

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.

Assets 3
Loading