Skip to content

13.2.0 — iDempiere 13

Latest

Choose a tag to compare

@sergioropeza sergioropeza released this 13 Oct 22:33

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.